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
