From: Rick James
Date: May 2 2012 7:01pm
Subject: RE: Can the mysql replication limited to one database
List-Archive: http://lists.mysql.com/mysql/227299
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB1485A7E066@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Doing both is redundant.  Doing binlog (on the Master) is more efficient be=
cause 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
>=20
> Quoting "Brown, Charles" <CBrown@stripped>:
>=20
>=20
> > Can the mysql replication limited to selected schema or database?
>=20
> Hi, yes it can. On the master side you control what is written to the
> binlog with my.cnf entries for each DB like:
>=20
> binlog-do-db=3DDB1
> binlog-do-db=3DDB2
>=20
> And on the slave side you use entries like:
>=20
> replicate-do-db=3DDB1
> replicate-do-db=3DDB2
>=20
> thanks Andy.
>=20
>=20
>=20
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql