From: Manuel Arostegui
Date: February 15 2013 10:01am
Subject: Re: slave replication with lots of 'duplicate entry' errors
List-Archive: http://lists.mysql.com/mysql/228977
Message-Id: <CAA8xrZfxcRppH2pDtyRbcT2NQzZPhvh=zZqGG+8BYaySRY7Uig@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=f46d04430476bf713404d5c07595

--f46d04430476bf713404d5c07595
Content-Type: text/plain; charset=ISO-8859-1

2013/2/14 Robert Citek <robert.citek@stripped>

>
>
> According to the client, nothing is writing to the slave and
> everything is being logged at the master.  I have not had the
> opportunity to independently verified any of this, yet.  I do know
> that the slave is not in read-only mode, but rather "we promise not to
> write to it" mode.
>

The only way to be totally safe is to enable it.


>
> At the moment, I am trying to come up with plausible explanations for
> the observations.


If you are sure you're setting the correct master IP, logfile and position
that appears in your mysqldump...the only explanation is...they are writing
directly into the slave.

Manuel.

--f46d04430476bf713404d5c07595--