0

I have two mysql server which are master-master replicated. One of them working updated without any problem. The other one gets slave replication error.

I want to disable master-master relation. How can I disable this relation? And is there any data corruption/loss risk?

Thanks

Mysql version:5.7

Improve this question
6
  • More details needed!
    – Rick James
    Aug 9 at 16:49
  • Can you please be more specific about what kind of details?
    – user3648566
    Aug 9 at 17:01
  • Data in broken database is not important.
    – user3648566
    Aug 9 at 17:35
  • The replica (each machine in Primary-Primary) controls whether it is replicating from a Primary. So, do SLAVE STOP on each.
    – Rick James
    Aug 9 at 17:49
  • Thanks. After this command, does mysql delete mysql-bin and relay-bin logs?
    – user3648566
    Aug 10 at 8:24

1 Answer 1

Reset to default
0

Slave replication error often shows there are data confliction between servers. If you just want to stop the master-slave replaction, "stop slave" is the command.

let say server A and B. if the slave status in A is normal, and B gets slave replication error, you can run stop slave in B.

it will not lead to data corruption, but the update in server A will not replicate to B. but the update in B will continue repaly in A.

you should decide whether this is that you except.

nomarlly, if you need a M-M struct, this is not enough, solve the slave status proble in B will be better.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.