RE: Can the mysql replication limited to one database

2012-05-02 Thread Rick James
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

RE: Can the mysql replication limited to one database

2012-05-02 Thread Rick James
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

RE: Can the mysql replication limited to one database

2012-05-02 Thread Rick James
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, >

RE: Can the mysql replication limited to one database

2012-05-02 Thread Brown, Charles
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

Re: Can the mysql replication limited to one database

2012-05-02 Thread Singer X.J. Wang
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

Re: Can the mysql replication limited to one database

2012-05-02 Thread Claudio Nanni
-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, > > &

RE: Can the mysql replication limited to one database

2012-05-02 Thread Rick James
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

Re: Can the mysql replication limited to one database

2012-05-02 Thread a . smith
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 en

Re: The MySQL Replication...

2004-04-28 Thread Victoria Reznichenko
Dyego Souza Dantas Leal <[EMAIL PROTECTED]> wrote: > Hello Guys !!! > > I'm want to solve this problem with the replication : > > > MASTER <- SLAVE OF MASTER <- SLAVE OF SLAVE 1 > > The replication on MySQL supports this "schema" ? > > Exists a possibility to use Slave of Slave on Replication

RE: The MySQL Replication...

2004-04-28 Thread Victor Pendleton
This daisy-chained master scenario is possible. -Original Message- From: Dyego Souza Dantas Leal To: [EMAIL PROTECTED] Sent: 4/28/04 6:47 AM Subject: The MySQL Replication... Importance: High Hello Guys !!! I'm want to solve this problem with the replication : MASTER <-

The MySQL Replication...

2004-04-28 Thread Dyego Souza Dantas Leal
Hello Guys !!! I'm want to solve this problem with the replication : MASTER <- SLAVE OF MASTER <- SLAVE OF SLAVE 1 The replication on MySQL supports this "schema" ? Exists a possibility to use Slave of Slave on Replication ? The Insert is STORED on MASTER and REPLICATED to SLAVE1 and REPLIC