Re: Replication : request DELETE is not executed on slave

2010-04-28 Thread Tom Worster
> 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

RE: Replication : request DELETE is not executed on slave

2010-04-28 Thread David Florella
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,

Re: Replication : request DELETE is not executed on slave

2010-04-28 Thread Mattia Merzi
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

Re: Replication : request DELETE is not executed on slave

2010-04-28 Thread Tom Worster
: '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

RE: Replication : request DELETE is not executed on slave

2010-04-28 Thread Jerry Schwartz
>-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

RE: Replication : request DELETE is not executed on slave

2010-04-28 Thread David Florella
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

Re: Replication : request DELETE is not executed on slave

2010-04-28 Thread Krishna Chandra Prajapati
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