snippetsqlMinor
How to sync MySQL database between two servers
Viewed 0 times
serversdatabasemysqlbetweentwohowsync
Problem
I need to sync a MySQL database between two servers.
If a new record will be added in server A, then server B fetch new record.
If a new record will be added in server B, then server A fetch new record.
If a new record will be added in server A, then server B fetch new record.
If a new record will be added in server B, then server A fetch new record.
Solution
You should probably go for Master-Master Replication .
http://www.howtoforge.com/mysql_master_master_replication
http://www.howtoforge.com/mysql_master_master_replication
Context
StackExchange Database Administrators Q#36354, answer score: 4
Revisions (0)
No revisions yet.