List:Replication« Previous MessageNext Message »
From:Krishna Chandra Prajapati Date:October 17 2008 6:56am
Subject:Replication Setup
View as plain text  
Hi List,

Below is a sample structure of replication.

                   master
slave/master                                       slave
                      A ----------------------------> B
------------------------------------> C
                      db1
db1                                                  db1

db2                                                  db2

db3                                                  db3


   1. In the above setup server B is both master and slave.
   2. On server B i have used log_slave_updates and replicate_do_db = db1

Question   Do i need to use binlog_do_db = db1 db2 db3 on server B to
replicate the data to server C or automatically all the data will be
replicated to server C. On server C do i need to use replicate_do_db = db1
db2 db3 in order to replicate or automatically replicate.

Thanks,
Krishna Chandra Prajapati
MySQL DBA,
Mob: 9912924044
Email-id: prajapatikc@stripped

Thread
Replication SetupKrishna Chandra Prajapati17 Oct
  • RE: Replication SetupRick James18 Oct
    • Re: Replication SetupMoon's Father21 Oct