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