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]