Enable events in Azure MySQL database

Question

Enable events in Azure MySQL database

Alejandro Sanchez Sanchez 0

I just migrated a MySQL database schema from a local server to Azure. In this schema, I have two SQL events verifying some data at a certain point of the day. both the events worked fine in the on-premises server, but not in the azure mysql database instance. Is there any additional configuration required for SQL event handling in Azure MySQL database? Thanks in advance. I was using MySQL server 8.0.35 in the on-premises server. I've already tried deleting and creating the events again in Azure.

GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator

2023-11-30T13:51:17.62+00:00

Hi @Alejandro Sanchez Sanchez Thanks for posting your question in the Microsoft Q&A forum.

Our Azure MySQL is currently on 8.0.34 version, can you please share the exact error you are seeing?

Regards

Geetha
Alejandro Sanchez Sanchez 0 Reputation points

2023-11-30T15:20:58.4233333+00:00

It's not displaying an error. I created an event in MySQL that checks, every 24 hours, if there's a new entry to a specific table on the database. If not, then updates a column on another table. It worked just fine in an on-premises server, which contained the database initially, but even if the event is actually showing with status enabled on the Azure Database for MySQL, it does not do what it's supposed to do. Here's a screenshot of the event in MySQL workbench:
GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator

2023-12-01T16:44:54.38+00:00

Hi @Alejandro Sanchez Sanchez This needs more troubleshooting I would suggest raising a support case For deeper investigation and immediate assistance, If you have a support plan you may file a support ticket, else could you please send an email to AzCommunity[at]Microsoft[dot]com with the below details, to work closely on this issue.

Email subject: <Attn - Geetha : Microsoft Q&A Thread title>

Thread URL: <Microsoft Q&A Thread>

Subscription ID: <your subscription id>

Looking forward to your reply.

Regards,

Geetha

1 answer

Your answer

GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator

2023-11-30T13:51:17.62+00:00

Hi @Alejandro Sanchez Sanchez Thanks for posting your question in the Microsoft Q&A forum.

Our Azure MySQL is currently on 8.0.34 version, can you please share the exact error you are seeing?

Regards

Geetha
Alejandro Sanchez Sanchez 0 Reputation points

2023-11-30T15:20:58.4233333+00:00

It's not displaying an error. I created an event in MySQL that checks, every 24 hours, if there's a new entry to a specific table on the database. If not, then updates a column on another table. It worked just fine in an on-premises server, which contained the database initially, but even if the event is actually showing with status enabled on the Azure Database for MySQL, it does not do what it's supposed to do. Here's a screenshot of the event in MySQL workbench:
GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator

2023-12-01T16:44:54.38+00:00

Hi @Alejandro Sanchez Sanchez This needs more troubleshooting I would suggest raising a support case For deeper investigation and immediate assistance, If you have a support plan you may file a support ticket, else could you please send an email to AzCommunity[at]Microsoft[dot]com with the below details, to work closely on this issue.

Email subject: <Attn - Geetha : Microsoft Q&A Thread title>

Thread URL: <Microsoft Q&A Thread>

Subscription ID: <your subscription id>

Looking forward to your reply.

Regards,

Geetha

Answer 1

Claudia Dos Santos Haz (CONCENTRIX CORPORATION) 1,145 Microsoft External Staff

Hi @Alejandro Sanchez Sanchez ,

I hope this article can be of help to you:

https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/sql-server-to-sql-managed-instance-assessment-rules?view=azuresql

Best regards,

Share via

Enable events in Azure MySQL database

1 answer

Your answer