Questions tagged [master-master]

24 questions
0
votes
2 answers

Master-Master replication how to catch up sync if shutdown

for work I was supposed to set up a master-master replication of 2 servers ( raspberry pi 3 debian ), which I did and it works, but now I have come to the issue of why we set up the replicas in the 1srt place : Server 1 is the main master and server…
0
votes
1 answer

Master/Master and Master/slave replication issues on raspberry pi 3

So for 2 weeks, I've been trying to set a Master/Master replication ( with apache2 web server and mariadb database ) on two Raspberry pi using different methods I've found all over the web ( french tutorials as well ). Many of these methods were…
0
votes
1 answer

Making master server slave of another master

I have 4 MySQL servers Master1, Master2, Master3 and Master4. Both Master1 and Master2 are masters of each other while Master3 and Master4 are masters of each other. I want to make Master3 slave of Master1. Is this possible? Following diagram shows…
Frank Martin
  • 741
  • 2
  • 12
  • 24
0
votes
2 answers

What's the issue of have all dns server as master zone

I want to configure 4 dns server using bind. Is there any problem to configure all of them as master with no dns transfer. # server one zone "example1.com" { type master; file "example1.com.zone"; allow-update { none; }; …
0
votes
1 answer

MySQL Master-Master Replication Issue

I have two databases that sync data through Master-Master replication. The setup was created using the following guide: digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-replication Until 2 days ago the system had been running…
0
votes
1 answer

Netstat shows Time_Wait in MySQL Master to master replication

During my master to master replication, I got a problem on telnet. After fixing it also my replication on both side doesn't work. Master 2 replicates all the database of Master 1 but Master 1 is unable to replicate it. When I see "netstat" command…
Udhy
  • 103
  • 3
0
votes
1 answer

How to enable telnet with port 3306 during Master to master replication on MySQL Server

I am trying to do Master to Master Replication in Windows Server 2008. I am successfully able to replicate all the database of Master 1 to Master 2. But I am unable to replicate the changes made on Master 2 to Master 1. Later on I found that, I can…
0
votes
1 answer

MariaDB Master-Master replication with 3 servers, no ports open on master

I want three MariaDB database servers, one master and two "slaves". I want to be able to read and write on every server, and have this replicated on the other servers. I read on the internet that this is called "master-master replication". Now I do…
0
votes
1 answer

keepalived delay before bringing ip up

Is it possible to configure a delay before bringing the virtual IP up in keepalived? Background: I have multiple Master/Master MySQL Setups. Only one Master is used at time. Keepalived is used for VIP that is used for mysql traffic. When the VIP is…
1
2