Master---------->Slave1/Master---------------->Slave2 (Chain 1 to 1) Slave1 should have --log_slave_updates
Master----------------------------->Slave1/Slave2/Slave3......... (Parallel 1 to many) --log_slave_updates is not required If all the slaves are in a single chain model then --log_slave_updates is required. Other in 1 to many model --log_slave_updates is not required Thanks, Krishna Chandra Prajapati On Fri, Apr 4, 2008 at 2:28 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > so, we should not have --log-slave-update on slaves on setup with one > master and multiple slaves...right. > > regards > anandkl > > > On 4/4/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > > > In case of master is down. Slave 1 has to be made as master and > > --log_slave_updates has to be removed. Slave2 will act as slave. There will > > be no "duplicate key" > > > > On Thu, Apr 3, 2008 at 1:02 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > > > > > But, it also says, that if slave1 is made master and if > > > log-slave-update is set on it, then > > > slave2 might receive data that it might have arleady got from the old > > > master, which might cause errors like "duplicate keys" etc. > > > > > > > > > On 4/3/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > > > > > > > Hi, > > > > There is nothing that, you can not enable log_slave_updates on > > > > slave. Basically, it is useful in a situation when you have 1 master > > > > and 2 > > > > or more slave in chain series. In this model 1st slave server should > > > > work as > > > > master as well as slave. So, log_slave_update and binlog can be enabled > > > > to > > > > log all the queries to binlog. In this way 2nd slave get the updates > > > > from > > > > 1st slave. > > > > > > > > Krishna Chandra Prajapati > > > > > > > > > > > > On Thu, Apr 3, 2008 at 12:02 PM, Ananda Kumar <[EMAIL PROTECTED]> > > > > wrote: > > > > > > > > > Hi All, > > > > > I have Master - Slave setup, with just one slave. > > > > > Can i set --log-slave-update on slave. > > > > > > > > > > I have mysql running on debain with 8 cpu and 8 GB RAM. > > > > > > > > > > Also in this link > > > > > > > > > > > > > > > http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-switch.html > > > > > > > > > > Its says not to set --log-slave-update on slave, so does this > > > > > apply only if > > > > > there are more than one slave connecting to the same master, or > > > > > does it > > > > > apply also on setup with one master and one slave. > > > > > > > > > > regards > > > > > anandkl > > > > > > > > > > > > > > > > > > > > > -- > > > > Krishna Chandra Prajapati > > > > MySQL DBA, > > > > Email-id: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > -- > > Krishna Chandra Prajapati > > MySQL DBA, > > Ed Ventures e-Learning Pvt.Ltd. > > 1-8-303/48/15, Sindhi Colony > > P.G.Road, Secunderabad. > > Pin Code: 500003 > > Office Number: 040-66489771 > > Mob: 9912924044 > > URL: ed-ventures-online.com > > Email-id: [EMAIL PROTECTED] > > > > -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 500003 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED]
