DB Management with multiple data centers
Posted by ilikepie on October 27, 2010 at 4:15pm
Hi there,
We had a second site in the cloud that has all of our sites set up and ready to go with a quick DNS change. MySQL is kept up to date with replication over an SSH tunnel, and we use lsync to keep the files in sync. The problem that I'm seeing is that, if we switch to the disaster recovery/second site and new data starts to be written to MySQL on the slave server, what would be the best workflow for returning this data back to the primary site?
Read more