Register now or log in to join your professional community.
I have 2 vps servers with mysql installed. I have successfully set up the master-master replication process on both servers. When server2 goes down and then comes back to life. it does not automatically fetch all the entries that were added while it was down. Can someone help with why this could be?
check your previleges & check your DNS adress of your computers group
This article is about setting up MySQL Master-Master database replication between two Cloud Servers. Master-Master data replication allows for replicated data, stored on multiple computers, to be updated by any authorized contributing member of the group. This allows for more open collaboration than Master-Slave replication where any needed changes identified by a group member must to be submitted to the designated “master” of the node.
Verify that the master has binary logging enabled
Use show processlist and check slave has established a connection to the master
Check previleges set