That's ok, good luck with your problem.
Perhaps this could help :)
http://forums.mysql.com/read.php?26,197734,197734#msg-197734
_____
De: Lasitha Alawatta [mailto:Lasitha.A@xxxxxxxx]
Enviada em: terça-feira, 26 de fevereiro de 2008 14:44
Para: Thiago Pojda
Cc: php-db@xxxxxxxxxxxxx
Assunto: RE: MySQL replication delaying issue
Oky, Sorry for that.. J
From: Thiago Pojda [mailto:thiago.pojda@xxxxxxxxxxxxxxxxxx]
Sent: Tuesday, February 26, 2008 8:49 PM
To: Lasitha Alawatta
Cc: php-db@xxxxxxxxxxxxx
Subject: RES: MySQL replication delaying issue
I did not say: do not ask on this list.
I said: you would get BETTER answers if you asked on a MySQL list.
_____
De: Lasitha Alawatta [mailto:Lasitha.A@xxxxxxxx]
Enviada em: terça-feira, 26 de fevereiro de 2008 13:47
Para: Thiago Pojda
Assunto: RE: MySQL replication delaying issue
Hay,
If U don?t know about that then u can ignore that mail. U need not to answer
each and every mails in this list.
MOST of the PHP developer are using MYSQL as backend.
That?s Y I sent that message to phpresources list also.
From: Thiago Pojda [mailto:thiago.pojda@xxxxxxxxxxxxxxxxxx]
Sent: Tuesday, February 26, 2008 8:39 PM
To: Lasitha Alawatta; php-db@xxxxxxxxxxxxx; patg@xxxxxxxx;
phpresource@xxxxxxxxxxxxxxx
Subject: RES: MySQL replication delaying issue
Not trying to be an ass, but wouldn't you get better answers if you asked in
a MySQL list?
I work with PHP, but have near to 0 experience with MySQL.
_____
De: Lasitha Alawatta [mailto:Lasitha.A@xxxxxxxx]
Enviada em: terça-feira, 26 de fevereiro de 2008 12:50
Para: php-db@xxxxxxxxxxxxx; patg@xxxxxxxx; phpresource@xxxxxxxxxxxxxxx
Assunto: MySQL replication delaying issue
Prioridade: Alta
Hello Everybody,
We have 6 multi-master MySql instances within a LAN , that are replicating
is a sequential manner.
Server Environment : Six identical Linux Enterprise version 4 running,
servers with having MySQL version 6.
we are using ?MySQL multi-master replication? method for database
replication.
There is a delay (5-7 minutes) of that data replication process.
We notice that it?s because of MySQL table locking.
Your comments are highly appreciated.
Many thanks in advance and best regards,
Lasitha Alawatta
Application Developer
Destinations of the World Holding Establishment
P O Box: 19950
Dubai, United Arab Emirates
( Ph +971 4 295 8510 (Board) / 1464 (Ext.)
7 Fax +971 4 295 8910
+ lasitha.a@xxxxxxxx
<http://www.dotw.com/> cid:image002.jpg@01C7A7A4.0AC70A00
DOTW DISCLAIMER:
This e-mail and any attachments are strictly confidential and intended for
the addressee only. If you are not the named addressee you must not
disclose, copy or take
any action in reliance of this transmission and you should notify us as soon
as possible. If you have received it in error, please contact the message
sender immediately.
This e-mail and any attachments are believed to be free from viruses but it
is your responsibility to carry out all necessary virus checks and DOTW
accepts no liability
in connection therewith.
This e-mail and all other electronic (including voice) communications from
the sender's company are for informational purposes only. No such
communication is intended
by the sender to constitute either an electronic record or an electronic
signature or to constitute any agreement by the sender to conduct a
transaction by electronic means.
