Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

MySQL master-master replication not working?

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?

user-image
Question added by Amer Chaudhary , Software Engineer , Recovery Database Network
Date Posted: 2016/03/02
yassine staili
by yassine staili , designer , NOunPRINT

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.

RAHUL P DIVAKARAN
by RAHUL P DIVAKARAN , Specialist , NOKIA

Verify that the master has binary logging enabled 

Use show processlist and check slave has established a connection to the master

Check previleges set

 

 

More Questions Like This