On Fri, Aug 9, 2013 at 7:36 AM, Bèrto ëd Sèra <berto.d.sera@xxxxxxxxx> 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,
