Hi Jeff, On Tue, 2002-05-21 at 11:15, Jeff Field wrote: > I think I understand how to set up replication but have a couple unanswered > questions. I'm hoping the list can help. > > I have two servers with MySQL. Each server currently has completely > different databases, except for the standard mysql permissions database. > Server 1 is in production and server 2 is basically a development box. I > would like to replicate server 1's databases to server 2 (in effect, > creating a hot-swap), but then that would mean that server 2 not only has > the production db's, but also the development db's. My question are: > > 1) Is that even possible to do? Can a slave to a master also have > additional db's on it that the master doesn't even know about? > > 2) If the answer to question one is yes, then what do you do regarding the > mysql permissions db on the slave? > > BTW, I'm thinking that my setup perhaps has to be more along the following > lines:
I think the main question is: why do this? I realise you want to use the development box as a backup. But, that does not mean you need to use the same mysql development installation there to do the replication. After all, you can run multiple mysql servers on a single machine. So I'd suggest doing that. Makes for a much clearer (and safer) setup, keeps your development stuff separate. Regards, Arjen. -- MySQL Training in Australia: 9-13 Sep 2002, https://order.mysql.com/?marl __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ www.mysql.com --------------------------------------------------------------------- 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
