How do I mirror a MySQL database?
Posted
by user45745
on Server Fault
See other posts from Server Fault
or by user45745
Published on 2010-06-14T08:38:45Z
Indexed on
2010/06/14
8:43 UTC
Read the original article
Hit count: 150
I'm running two load balanced servers for one website, and I'd like the databases to be synchronized. Queries may be run on either of the two servers because they are both production sites, so the replication can't just work one way.
It doesn't have to be in real-time, just fairly accurate so people don't notice a difference when they get switched to a different server.
© Server Fault or respective owner