gistfile1.txt

Purpose:

To migrate the emcee data out of the publisher mysql database, while continuing to maintain a current copy of that data in the Publisher database, with minimal downtime for both Publisher and Emcee.

Plan:

configure new emcee database to replicate only the emcee database to the publisher master database (into a different database name)

configure new emcee database to replicate all data to emcee slave.

configure old publisher master to import the emcee data into the new database, would be amazing if then this data will all be replicated into the publisher slave.

replicate the data from the current publisher database to new emcee master database.

check results...

refine until this works.

When time to cut over:

Turn off emcee.

Turn off publisher replication to emcee master.

Turn off emcee replication to publisher master.

reconfigure publisher to import emcee data into emcee database.

drop emcee database

rename new emcee database to 'emcee'

restart publisher database

restart replication

restart publisher

Point emcee to new database and turn back on.

Refine this until it works...