|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: Replication : request DELETE is not executed on slave
From: Mattia Merzi (mattia.merzi
gmail.com)
Date: Wed Apr 28 2010 - 10:54:26 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 <fsbthefsb.org>:
> 16.3.1.9. Replication and LIMIT
> Replication of LIMIT clauses in DELETE, UPDATE, and INSERT ... SELECT
> statements is not guaranteed, since the order of the rows affected is not
> defined. Such statements can be replicated correctly only if they also
> contain an ORDER BY clause.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]