ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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
تم إضافة السؤال من قبل Amer Chaudhary , Software Engineer , Recovery Database Network
تاريخ النشر: 2016/03/02
yassine staili
من قبل 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
من قبل 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

 

 

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟