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]
