Doing both is redundant. Doing binlog (on the Master) is more efficient because it eliminates sending the other dbs.
> -----Original Message----- > From: [email protected] [mailto:[email protected]] > Sent: Wednesday, May 02, 2012 8:50 AM > To: [email protected] > Subject: Re: Can the mysql replication limited to one database > > Quoting "Brown, Charles" <[email protected]>: > > > > 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
