Can you paste you backup mysqldump statement ? ( It should not occur if
that is consistent ) and secondly I'm thinking about mixed engine types in
a transaction can also cause such duplicate keys.
Remember though we set slave's to read only, the super user's can still do
the writes. So, drop any such user's privileges.
On Mon, Jul 15, 2013 at 11:24 AM, Johan De Meersman <vegivamp@stripped>wrote:
> ----- Original Message -----
> > From: "Jamen McGranahan" <jamen.mcgranahan@stripped>
> > Subject: RE: 2 slaves - one Master; continues to fail
> > Thanks for this message. I’m assuming the percona tool needs to be
> > installed on the MASTER host? Is that correct?
> They're useful everywhere, really :-) For this usage, I do believe the
> master will suffice.
> Unhappiness is discouraged and will be corrected with kitten pictures.
MySQL & MongoDB DBA