1
vote
0answers
130 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 ...
0
votes
1answer
329 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
1answer
101 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 ...
2
votes
3answers
335 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: ...
0
votes
1answer
121 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 ...
5
votes
1answer
514 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 ...
1
vote
1answer
71 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 ...