|
mysql master to master replication how to resync
I encountered an error on my setup due to issue on my machine. Lets say Node1 and Node2. Update in Node1 is replication to Node2 and update in Node2 is replication to Node1. MySQL master to master replication is now working fine but there is discrepancies. I believe there is missing data before the replication got fix.
Slave_IO_State: Waiting for master to send event
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Since replication is now working. The good data is in Node1. How can I copy the missing data to Node2? It will take days if I will use mysqldump to transfer data Node2
mysql> use node1db;select count(id) from log;
Database changed
+-----------+
| count(id) |
+-----------+
| 4154583 |
mysql> use node2db;select count(id) from log;
Database changed
+-----------+
| count(id) |
+-----------+
| 4150386 |
+-----------+
1 row in set (1.24 sec)
|
