Questions tagged [master-master]
23 questions
8
votes
1 answer
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. we only use replication for HA).
I have…
David Cournapeau
- 243
- 4
- 13
7
votes
2 answers
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. Each server node has an i7 quad core, 16GB RAM,…
spa
- 293
- 2
- 8
5
votes
1 answer
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 tried googling but a lot of posts that I find are…
thanasisk
- 941
- 6
- 16
3
votes
3 answers
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
sync_binlog=1
We use a load balancer to round…
Justin
- 5,008
- 19
- 58
- 82
2
votes
1 answer
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 entries are needed because I am defining channels in…
Frank Martin
- 721
- 2
- 10
- 23
2
votes
0 answers
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-bin = mysql.bin
bind-address = 0.0.0.0
server2 >…
stanley
- 21
- 2
1
vote
1 answer
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 only databases db1 and db2, and thise databases…
B14D3
- 5,110
- 13
- 58
- 82
1
vote
1 answer
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 implement if for 3 different MySQL Servers.
Does…
Mahendra Liya
- 339
- 1
- 5
- 13
1
vote
0 answers
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 gives position XXX, then I jump to Master 2 and print…
barisinanc
- 23
- 1
- 4
1
vote
1 answer
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 the other database via replication.
It is…
Michael Franze
- 131
- 5
1
vote
1 answer
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 one server then make these two MySQL servers act…
Sam W.
- 41
- 1
- 6
0
votes
1 answer
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…
mohan reddy
- 11
- 2
0
votes
0 answers
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 HA_ERR_KEY_NOT_FOUND; the event's master log…
Mai Tarek
- 1
- 2
0
votes
1 answer
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 data from different site using CRON on every 10…
jack
- 101
- 1
- 3
0
votes
3 answers
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-increment-offset = 1
So it writes only odd…
Dean Householder
- 101
- 1
- 4