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 + <mailto:lasitha.a@xxxxxxxx> 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.
