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]