Due to Disk space issue Master2 server crashed and it was rebuilt again using mysqldump of Master1.
Both Master 1 and Master2 are in sync and Master2 is in Read_only mode.
During the crash, I stopped the Slave instance in Master1 and it's been over a week now. Now how to restart replication from Master2 to Master1.
Can changing the Master Log position in Master1 to current Master2 status works?
Mysql – Sync MySql Replication from Master2 to Master1 after failover
master-master-replicationMySQLmysql-5.7replication
Related Question
- Mysql – re-enabling a table for thesql replication
- MySQL Master-Master Replication not syncing
- MySQL – How to Recover Master from Slave After Failover
- Thesql slave replication doesn’t work due to error 1236
- MySQL – Master to Master Replication Without Downtime
- MySQL – How to Change Master-Master Replication to Master-Slave
Best Answer
As Master2 is in read-only;
Master2:
SHOW MASTER STATUS
Master1:
Where the master log file name/pos are from the Master2
SHOW MASTER STATUS
The rapidly changing master status isn't an issue as its binary logs are from Master1 anyway. Master1 won't write its own binary log message back again when received via replication.