What would be my best MySQL Synchronization method?

Posted by Kerry on Stack Overflow See other posts from Stack Overflow or by Kerry
Published on 2010-05-27T18:46:32Z Indexed on 2010/05/27 19:01 UTC
Read the original article Hit count: 139

We're moving a social media service to be on separate data centers with global load balancing, as our other hosting provider's entire data center went down. Twice.

This means that both websites need to be synchronized in some sense -- I'm less worried about the code of the pages, that's easy enough to sync, but they need to have the same database data.

From my research on SO, it seems MySQL Replication is a good option, but the MySQL manual, for scaling out, says that its best when there are far more reads then there are writes/updates: http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-scaleout.html

In our case, it's about equal. We're getting around 200-300 thousand requests a day right now, and we can grow rapidly. Every request is both a read and write request.

What would be the best method or tool to handle this?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about synchronization