rajapati
>
> 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
> >
> >
>
ati
>
> 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/
odel 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
>
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 ha
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 PR
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]&g
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 sl
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