Questions tagged [master-master]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2 votes
1 answer
4k views

Multi source replication not working in MySQL

I am trying to setup multi source replication. In my slave I have defined following two properties in its configuration file. master-info-repository=table relay-log-info-repository=table These ...
0 votes
4 answers
8k views

MySQL Master-Master with offsets getting ERROR 1872

I'm trying to fix the replication between a master-master MySQL database replication model. Server 1 (with the IP of 192.168.2.6) is configured with: auto-increment-increment = 2 auto-...
0 votes
1 answer
324 views

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 ...
0 votes
1 answer
2k views

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 ...
0 votes
1 answer
1k views

Master- Master Replication breaks after server Reboot

I have a Master-Master Replication with the following Configuration. Due to some patches, we have to Reboot the both the masters. But when i check the replication i s broken. MASTER 1: [mysqld] ...
0 votes
0 answers
497 views

Master Master replication between RDS and database instance on EC2 Errno: 1032

I face this error many times with my replication Last_SQL_Error: Could not execute Delete_rows event on table db_name.event; Can't find record in 'event', Error_code: 1032; handler error ...
0 votes
1 answer
701 views

Mariadb live sync using cron or replication

We have around 14 eCommerce sites which are working in 2 LAMP server. Two sites in server one and second server consist of rest of the sites. There is one central DB in which we are syncing all the ...
0 votes
2 answers
892 views

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 ...
0 votes
1 answer
445 views

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 ...
0 votes
1 answer
149 views

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 ...
0 votes
2 answers
1k views

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....
1 vote
1 answer
103 views

Filtered master-master replication-is it possible?

I got task to configure I think some sort of monster. My boss want to have two mysql servers. Let's say serverA and serverB have databases db1,db2,db3,db4. He wanted that serverA will be master for ...
7 votes
2 answers
4k views

Magento hosting on a budget

I have to do a setup for Magento. My constraint is primarily ease of setup and fault tolerance/fail over. Furthermore costs are an issue. I have three identical physical servers to get the job done. ...
8 votes
1 answer
4k views

Recovery strategy for Master-Master replication

I have implemented a HA solution for mysql based on master-master replication. There is a mechanism on the front end part which guarantees that only one db will be read/written to at a given time (i.e....
0 votes
1 answer
959 views

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-...
2 votes
0 answers
3k views

MYSQL master master replication show master status show empty record

Environment: Windows 2008 R2, MySQL 5.051b Two servers: server1: 192.168.2.8 server2: 192.168.2.9 server1 > my.ini [mysqld] server-id = 1 auto-increment-increment = 2 auto-increment-offset = 1 log-...
5 votes
1 answer
4k views

postgres 9.1 master-master setup using Bucardo

is anyone aware of any comprehensive tutorials for setting up 2 postgres 9.1 databases in master-master configuration? What "add-ons" are required (for example is Bucardo still a necessity?). I have ...
1 vote
1 answer
620 views

MySQL master-master replication between database running on 3 different server

I am trying to implement a master-master replication between 3 MySQL Databases running on 3 different servers. I implemented master-master replication for 2 servers, but can't figure out how can I ...
0 votes
1 answer
742 views

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 ...
0 votes
1 answer
2k views

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 ...
1 vote
0 answers
1k views

MySQL Replication not working on binlog-do-db

I set up MySQL master-master replication on my 2 Ubuntu VM. Configuration and connection done correctly according to this guide. Here is my problem. I print the master status on master 1 and it ...
3 votes
3 answers
1k views

MySQL Master-Master Replication Lag

I have configured two MySQL servers (MySQL-1, MySQL-2) in master-master replication in the same datacenter using a local backend connection with the following options: innodb_flush_log_at_trx_commit=...
1 vote
1 answer
573 views

MySQL Replication with "same value wins" conflict resolution for updates

I have set up normal (non-clustered, ndb) two server Mysql Master-Master replication for high availability. Each server has an application that can update the local database, the changes propagate to ...
1 vote
1 answer
84 views

MySQL database solution

I have 2 offices that are located around 500km apart and both offices need to access the MySQL database frequently. So to make it faster I am planning to set up two MySQL servers where each office has ...