To turn off GTID replication in Azure MySQL Database

2024-03-04T10:38:48.5033333+00:00

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.

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
842 questions
{count} votes

Accepted answer
  1. Oury Ba-MSFT 19,421 Reputation points Microsoft Employee
    2024-03-05T01:07:20.66+00:00

    @Srikar Gondesi - UAS Database Administrator

    Thank you for reaching out.

    User's image

    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

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. RahulRandive 9,901 Reputation points
    2024-03-05T02:36:35.74+00:00

    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!

    0 comments No comments

  2. 2024-03-06T05:07:37.3733333+00:00

    duplicate answer. please ignore this.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.