Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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 ajoutée par Amer Chaudhary , Software Engineer , Recovery Database Network
Date de publication: 2016/03/02
yassine staili
par 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
par 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

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?