Nice reply. On Fri, Apr 4, 2008 at 5:19 PM, Krishna Chandra Prajapati < [EMAIL PROTECTED]> wrote:
> 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] > -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
