Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Robert Citek (rwcitekalum.calberkeley.org)
Date: Wed Dec 08 2010 - 21:50:23 CST
Greetings to all,
Can I migrate slave databases between slave servers?
Imagine the following scenario: I have one master database server with
10 databases. I also have two slave database servers, one replicating
5 of the 10 databases, the other replicating the other 5 databases.
Can I migrate one of the replicated databases from one slave to the
other, resulting in one slave having 6 databases and the other having
4? I'm using the term "migrate", but is there a more appropriate
The docs mention various replication strategies, including
splitting out different databases to different slaves. In the extreme
case, I would like to do the opposite, consolidate databases among
slaves, with the final state being all 10 databases on one slave and
none on the second.
Thanks in advance for your help, especially pointers to any references.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql