e the table won't be on the Slave.
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: Wednesday, May 02, 2012 10:25 AM
To: Rick James
Cc: Brown, Charles; mysql@lists.mysql.com
Subject: Re: Can the mysql replication limited to one database
I recommend to use the 'wild' mod
ct: Re: Can the mysql replication limited to one database
>
> Quoting "Brown, Charles" :
>
>
> > 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 entr
both is redundant.
> -Original Message-
> From: Brown, Charles [mailto:cbr...@bmi.com]
> Sent: Wednesday, May 02, 2012 11:15 AM
> To: Rick James
> Cc: mysql@lists.mysql.com
> Subject: RE: Can the mysql replication limited to one database
>
> Hello Rick,
>
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 G
nore-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: Wednesd
-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,
> >
&
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 G
Quoting "Brown, Charles" :
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:
r
