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

How do I mirror a MySQL database?

Posted by user366133 on Stack Overflow See other posts from Stack Overflow or by user366133
Published on 2010-06-14T08:33:02Z Indexed on 2010/06/14 8:42 UTC
Read the original article Hit count: 149

Filed under:
|
|
|
|

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.

© Stack Overflow or respective owner

Related posts about mysql

Related posts about load-balancing