> David.
>
> -Message d'origine-
> De : Mattia Merzi [mailto:mattia.me...@gmail.com]
> Envoyé : mercredi 28 avril 2010 17:54
> À : mysql@lists.mysql.com
> Objet : Re: Replication : request DELETE is not executed on slave
>
> AFAIR you can use LIMIT with rep
ELETE is not executed on slave
AFAIR you can use LIMIT with replication only if you use row-based
replication (or mixed), that means that you must use mysql 5.1.
Greetings,
Mattia.
2010/4/28 Tom Worster :
> 16.3.1.9. Replication and LIMIT
> Replication of LIMIT clauses in DELETE, UPDATE,
AFAIR you can use LIMIT with replication only if you use row-based
replication (or mixed), that means that you must use mysql 5.1.
Greetings,
Mattia.
2010/4/28 Tom Worster :
> 16.3.1.9. Replication and LIMIT
> Replication of LIMIT clauses in DELETE, UPDATE, and INSERT ... SELECT
> statements is
: 'Krishna Chandra Prajapati'
>> Subject: RE: Replication : request DELETE is not executed on slave
>>
>> Hi,
>>
>> In the MySQL documentation, it is written that the two versions are
>> compatible to make a replication.
>>
>> It seems th
>-Original Message-
>From: David Florella [mailto:dflore...@legos.fr]
>Sent: Wednesday, April 28, 2010 10:51 AM
>To: mysql@lists.mysql.com
>Cc: 'Krishna Chandra Prajapati'
>Subject: RE: Replication : request DELETE is not executed on slave
>
>Hi,
&g
andra Prajapati [mailto:prajapat...@gmail.com]
Envoyé : mercredi 28 avril 2010 11:15
À : dflore...@legos.fr
Cc : mysql@lists.mysql.com
Objet : Re: Replication : request DELETE is not executed on slave
Hi dflorella,
The important thing about mysql replication is same mysql version for both
master as well as
Hi dflorella,
The important thing about mysql replication is same mysql version for both
master as well as slave should be used. It should be taken as good practice.
You need to check that master and slave are in sync. Is there any error
(replication) on the slave server. Check the mode, strict o