MySQL parameter innodb_flush_log_at_trx_commit.

Question

MySQL parameter innodb_flush_log_at_trx_commit.

Alex Titley 25

I'm looking to change innodb_flush_log_at_trx_commit parameter on our MySQL flexible server, according to the documentation support has now been added for this parameter as of last month however it still seems to be greyed out in the portal?

We require changing this setting due to wanting to do data-in replication with a very high transactional database in order to migrate our production environment to a MySQL flexible server. When we've tried this previously replication just falls behind as the flexible instance replica can't keep up with the transactions.

Accepted answer

0 additional answers

Your answer

Answer 1

Konstantinos Passadis 19,586 MVP

Hello @Alex Titley !

Welcome to Microsoft QnA!

One thing i can suggest is to go to preview.portal.azure.com and see whether the option is available

If no luck , i would suggest to contact directly Azure Support and raise a case with your issue!

I hope this helps!

Kindly mark the answer as Accepted and Upvote in case it helped!

Regards

Alex Titley 25 Reputation points

2023-07-03T16:51:02.1933333+00:00

@Konstantinos Passadis Thanks, the option wasn't in the preview portal either I'll raise a case with Support. Thanks for the help.
Konstantinos Passadis 19,586 Reputation points MVP

2023-07-03T17:00:48.76+00:00

Hello @Alex Titley !

Thank you for the update and the Acceptance

In case you find an answer and it is not a hassle for you , kindly post any new feedback !

Regards!
Alex Titley 25 Reputation points

2023-07-05T12:15:01.8566667+00:00

After speaking with Azure Support it's a setting that only they can change so they have done this for us. @Konstantinos Passadis once again thanks for the help and quick response !

Share via

MySQL parameter innodb_flush_log_at_trx_commit.

0 additional answers

Your answer