Re: replication questions

From the mySQL Replication docs... snip -------------------------------------------------------------- In Version 3.23.15, all of the tables and databases will be replicated. Starting in Version 3.23.16, you can restrict replication to a set of databases with replicate-do-db directives in `my.cnf' or just exclude a set of databases with replicate-ignore-db. -------------------------------------------------------------- Two-way replication is not supported yet. http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Replication 'Luck -Szii ----- Original Message ----- From: "Jeff Field" <jfield@aaaq.com> To: <php-db@lists.php.net> Sent: Monday, May 20, 2002 6:03 PM Subject: [PHP-DB] replication questions > 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: > > The master contains all my db's, both production and development. The > production db's (as well as the development db's) would sit there in > production on server 1, replicating all the data to server 2. I would have > to set the permissions for both production and development db's on server 1. > > Meanwhile, as the production server is sitting there and replicating all > it's important data to the development box, I could still work on the > development db's on the slave box (thereby not fooling around with the > production box). > > The issue, as I see it, would be that the slave box's development db's would > soon go out of synch with the development db's on the master (because I'd be > inserting, updating, etc. records on the development db's on the slave and > the master would never know). I could set up two-way replication, but since > I don't really care about the development db's being in synch on the master, > why bother. Does this make sense? > > Anyway, I hope I've made this clear enough for someone to jump with answers > and comments. > > Jeff > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php