Nothing in the slave's my.cnf. On the Master, binlog-do/ignore-* filters before leaving the Master. On the Slave, replicate-do/ignore-* (if used) would filter after getting to the Slave.
That is, you _could_ do the replicate-* instead of the binlog-*, but that would be inefficient. Doing both is redundant. > -----Original Message----- > From: Brown, Charles [mailto:cbr...@bmi.com] > Sent: Wednesday, May 02, 2012 11:15 AM > To: Rick James > Cc: mysql@lists.mysql.com > Subject: RE: Can the mysql replication limited to one database > > Hello Rick, > What goes into your my.cnf slave ? > Given dbname1 and dbname2 > > > > > -----Original Message----- > From: Rick James [mailto:rja...@yahoo-inc.com] > Sent: Wednesday, May 02, 2012 12:05 PM > To: Brown, Charles > Cc: mysql@lists.mysql.com > Subject: RE: Can the mysql replication limited to one database > > 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. > > ******************************************** > ******************************************** > 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
