RBR solves the default db case.. S
On Wed, May 2, 2012 at 1:25 PM, Claudio Nanni <claudio.na...@gmail.com>wrote: > 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> > > > 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] > > > Sent: Wednesday, May 02, 2012 8:44 AM > > > To: Rick James > > > Cc: 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 > -- -- Get an insider’s guide to ODA performance. Join Gwen Shapira, Oracle Ace Director and Senior Pythian Consultant, on May 10th as she presents her findings in an informative webinar. Register today, bit.ly/odaperfwebinar
