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,
>
Hello Rick,
What goes into your my.cnf slave ?
Given dbname1 and dbname2
-Original Message-
From: Rick James [mailto:rja...@yahoo-inc.com]
Sent: Wednesday, May 02, 2012 12:05 PM
To: Brown, Charles
Cc: mysql@lists.mysql.com
Subject: RE: Can the mysql replication limited to one
RBR solves the default db case..
S
On Wed, May 2, 2012 at 1:25 PM, Claudio Nanni wrote:
> I recommend to use the 'wild' modifier, if you have a default db and you
> specify the schema in the query like update
> schemanotreplicated.mytable. you will miss that.
>
> Claudio
>
> 2012/5/2 Rick
I recommend to use the 'wild' modifier, if you have a default db and you
specify the schema in the query like update
schemanotreplicated.mytable. you will miss that.
Claudio
2012/5/2 Rick James
> Yes, doable. In my.cnf on master:
> Binlog-do-database = dbname1
> Binlog-do-database = db
Yes, doable. In my.cnf on master:
Binlog-do-database = dbname1
Binlog-do-database = dbname2
Would replicate those two dbs only.
There are many other combinations using
binlog/replicate-do/ignore-db/table/wild. See the manual on replication, and
especially the flowchart on how those interact
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
