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] >
