Doing both is redundant. Doing binlog (on the Master) is more efficient because it eliminates sending the other dbs.
> -----Original Message----- > From: a.sm...@ukgrid.net [mailto:a.sm...@ukgrid.net] > Sent: Wednesday, May 02, 2012 8:50 AM > To: mysql@lists.mysql.com > Subject: Re: Can the mysql replication limited to one database > > Quoting "Brown, Charles" <cbr...@bmi.com>: > > > > Can the mysql replication limited to selected schema or database? > > Hi, yes it can. On the master side you control what is written to the > binlog with my.cnf entries for each DB like: > > binlog-do-db=DB1 > binlog-do-db=DB2 > > And on the slave side you use entries like: > > replicate-do-db=DB1 > replicate-do-db=DB2 > > thanks Andy. > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql