Replication Setup

[Krishna Chandra Prajapati]

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: [phone]
Email-id: prajapatikc@stripped