Azure MySQL event scheduler Issue

정석 오 0

I'm using the Azure Database for MySQL service. After a maintenance event on Azure, MySQL restarted.

After the restart, the event_scheduler was turned OFF, and the MySQL events we had registered are now in a "DISABLED ON SLAVE" state, which is affecting our service. How can we resolve this issue?

ShaktiSingh-MSFT 15,421 Reputation points

2024-08-28T06:31:07.3066667+00:00

Hi 정석 오 •,

We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks
정석 오 0 Reputation points

2024-08-29T01:55:43.7166667+00:00

@Shaktisingh

Yes, High Availability is configured correctly. However, the problem is that when scheduled maintenance occurs on Azure, the event_scheduler is changed to the default value of OFF. I need to manually adjust the settings.
정석 오 0 Reputation points

2024-08-29T01:56:27.46+00:00

@Shaktisingh
Yes, High Availability is configured correctly. However, the problem is that when scheduled maintenance occurs on Azure, the event_scheduler is changed to the default value of OFF. I need to manually adjust the settings.
ShaktiSingh-MSFT 15,421 Reputation points

2024-08-30T05:59:08.96+00:00

Hi 정석 오 •,

We regret to inform you that it is product limitation.

https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-server-parameters#limitations

Refer to the existing limitation in product document snippet here:

Please share your feedback over https://feedback.azure.com/d365community/forum/47b1e71d-ee24-ec11-b6e6-000d3a4f0da0 Azure MySQL feedback channel so that team can work on this feature depending on the importance and up-votes.

Thanks

1 answer

ShaktiSingh-MSFT 15,421 Reputation points

2024-08-27T07:50:33.59+00:00

Hi 정석 오 •,

Welcome to Microsoft Q&A forum.

As I understand, your event_scheduler parameter is turned off for Azure MySQL Server.

It looks like you MySQL server has High Availability configured, when failover occurs, it's possible that the event_scheduler server parameter will be set to 'OFF'. If this occurs, when the failover is complete, configure the parameter to set the value to 'ON'.

Login to your Azure portal > ${your_sql_server} > click on "Server Parameters" tab and you should be able to set all your global parameters like "event_scheduler"

See : Configure server parameters in Azure Database for MySQL - Flexible Server using the Azure portal

Hope this helps.

Let us know if you have more queries.

Thanks
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure MySQL event scheduler Issue

1 answer

Your answer