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…
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…
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…
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…
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…
1
2