Here's the use case that screws up a lot of people: USE db_that_is_not_replicated; INSERT INTO db_that_IS_replicate.tbl ...;
Surprise! That INSERT is not replicated. Workaround: *wild will notice it. The other way around, the INSERT will be replicated, then hang replication because the table won't be on the Slave. From: Claudio Nanni [mailto:claudio.na...@gmail.com] Sent: Wednesday, May 02, 2012 10:25 AM To: Rick James Cc: Brown, Charles; mysql@lists.mysql.com Subject: Re: Can the mysql replication limited to one database I recommend to use the 'wild' modifier, if you have a default db and you specify the schema in the query like update schemanotreplicated.mytable..... you will miss that. Claudio 2012/5/2 Rick James <rja...@yahoo-inc.com<mailto:rja...@yahoo-inc.com>> Yes, doable. In my.cnf on master: Binlog-do-database = dbname1 Binlog-do-database = dbname2 Would replicate those two dbs only. There are many other combinations using binlog/replicate-do/ignore-db/table/wild. See the manual on replication, and especially the flowchart on how those interact (sometimes in unexpected ways). > -----Original Message----- > From: Brown, Charles [mailto:cbr...@bmi.com<mailto:cbr...@bmi.com>] > Sent: Wednesday, May 02, 2012 8:44 AM > To: Rick James > Cc: mysql@lists.mysql.com<mailto:mysql@lists.mysql.com> > Subject: Can the mysql replication limited to one database > > Hi Gurus, > > Can the mysql replication limited to selected schema or database? I've > been asked to set up mysql for only 1 out 5 databases exist in > production. Please advise if this is doable > > Thanks > > ******************************************** > This message is intended only for the use of the Addressee and may > contain information that is PRIVILEGED and CONFIDENTIAL. > > If you are not the intended recipient, you are hereby notified that any > dissemination of this communication is strictly prohibited. > > If you have received this communication in error, please erase all > copies of the message and its attachments and notify us immediately. > > Thank you. > ******************************************** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql -- Claudio
