From: Moon's Father (yueliangdao0608gmail.com)
Date: Mon Apr 07 2008 - 00:28:13 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Nice reply.

On Fri, Apr 4, 2008 at 5:19 PM, Krishna Chandra Prajapati <
prajapatikcgmail.com> 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 <anandklgmail.com> 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 <prajapatikcgmail.com> 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 <anandklgmail.com>
> 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 <prajapatikcgmail.com>
> 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 <anandklgmail.com>
> > > > > 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: prajapatikcgmail.com
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > > --
> > > 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: prajapatikcgmail.com
> > >
> >
> >
>
>
> --
> 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: prajapatikcgmail.com
>

--
I'm a mysql DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]