To turn off GTID replication in Azure MySQL Database

Question

Hello Team,

I am trying to remove GTID data-in replication from my Azure MySQL database instance.
I ran the related stored procedure to stop the replication but I am not able to turn off below variables.

1. gtid_mode
2. enforce_gtid_consistency

Error:
{"customHtml":{"htmlTemplate":"<code><div>{\r\n "status": "Failed",\r\n "error": {\r\n "code": "ResourceDeploymentFailure",\r\n "message": "The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'.",\r\n "details": [\r\n {\r\n "code": "InvalidConfigurationValue",\r\n "message": "The value 'ON_PERMISSIVE' for configuration 'gtid_mode' is not valid. The allowed values are 'ON'."\r\n }\r\n ]\r\n }\r\n}</div></code>","viewModel":null}}

please help.

Answer 1

@Srikar Gondesi - UAS Database Administrator

Thank you for reaching out.

We can only turn off the GTID for standalone server at the backend. We cannot turn server which is part of Primary/Replica topology.

This can only be done at the back end. Meaning you need to create to create a support ticket.

Regards,

Oury

Answer 2

Hi @Srikar Gondesi - UAS Database Administrator

Please try and follow the sequence below

First change enforce_gtid_consistency to OFF.

Then, change gtid_mode from ON to ON_PERMISSIVE then OFF_PERMISSIVE and finally OFF.

Thank You!

Answer 3

duplicate answer. please ignore this.