Questions tagged [master-master]
The master-master tag has no usage guidance.
24
questions
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 ...