On Fri, Aug 9, 2013 at 7:36 AM, Bèrto ëd Sèra <berto.d.s...@gmail.com>wrote:
> --all you need to do is switch master and slave so that "master" is the > one box you are currently on > That probably isn't a reasonable solution, considering the OP mentioned that she was not a professional DBA. Setting up a hot/warm standby, failing over, resetting the slave from the new master, lather, rinse, repeat is certainly scriptable but doesn't seem like the best option here. I don't know of any commercial solutions, but writing some code might be required. Synchronizing data isn't that difficult, but synchronizing changes to database table structure will be a bit tricky,
