Two-way MySQL replication?
Posted on 2014-02-01
There are two web servers: server1 and server2. Server1 is the primary and server2 is the backup / redundant box.
We have failover DNS setup through DNSMadeEasy so that if there is an issue with Server1, the DNS will re-point to server2 until server1 can come back online.
Both of these servers run a single php / mysql based website.
Here's the question: if we setup MySQL replication, will that accomplish the following:
1. If server1 goes down, server2 will show up with all the content. (Content is in the database).
2. If users make changes or upload things to server2, when server1 comes back up, will the changes replicate back to server1?
Right now, the though is to use MySQL replication to replicate the data, and rsync to sync the files.
I know this can be done. the question is, what are the specifics? And, how long would it take a competent MySQL admin to set this up?