MySQL per-database replication?

Posted by LucasBr on Server Fault See other posts from Server Fault or by LucasBr
Published on 2012-07-05T16:26:02Z Indexed on 2012/07/08 3:17 UTC
Read the original article Hit count: 605

So, my problem is interesting: we want to migrate from one server to another. We made a master-slave replication, but my boss came with the idea to make migration one database at a time.

So he asked me to setup at the new server another MySQL instance, let the slave almost as-is and make the new instance be the new master incrementally, one database at a time. Is it possible, that is, can I transfer the database 'x' from old master to new master and just tell slave to synchronize 'x' at the new master from now on?

I've read at this old thread ( Mysql Replication - are per-database threads possible? ) that this was not possible at that time. This can be done now?

Thanks!

Lucas Bracher.

© Server Fault or respective owner

Related posts about mysql

Related posts about replication