Hello. On Fri 2002-12-06 at 09:59:32 -0500, [EMAIL PROTECTED] wrote: > MySQL folks, > > I have a server which handles hundreds of connections at a time typically. > Many of these are actually inserting data. It is currently configured as a > replication master. Let's call it A. The slave is currently only used as a > backup. Let's call the slave B. But this is not really about B. We have > yet another replication master, C, and I would like to set up server A as > a slave for a couple of databases from C. The databases that would be > replicated from C to A are completely independent of those that exist on A > (no mysql, no test for example). I'm assuming that this scheme is kosher. > > I am wondering if there is any way to reconfigure A as a slave to C > without bringing down the server. Like a "mysqladmin reload" for stuff > other than privilege information. It is hard to find a time window to fool > around with server A.
AFAICS, on the slave side, you only need step 7 and 9 of http://www.mysql.com/doc/en/Replication_HOWTO.html in order to make A a slave to C. Be sure that C has a different server-id than A beforehand. That may need a _quick_ restart of _C_. Step 8 (the restart of the slave), is IMHO only needed to make it aware of a new server-id, which A already has, because it's a master already. Note that you can replace step 7 by LOAD DATA FROM MASTER since MySQL v4.0.1, which eases the initial synchronization of the slave. HTH, Benjamin. -- [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
