[PHP-DB] MySQL replication delaying issue
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 + [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.dotw.com/ 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.
Re: [PHP-DB] MySQL replication delaying issue
On Tue, Feb 26, 2008 at 10:49 AM, Lasitha Alawatta [EMAIL PROTECTED] wrote:
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.
Ask on a MySQL list. It has nothing to do with PHP.
http://lists.mysql.com/
Specifically: Replication - http://lists.mysql.com/replication
--
/Dan
Daniel P. Brown
Senior Unix Geek
? while(1) { $me = $mind--; sleep(86400); } ?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RES: [PHP-DB] 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:[EMAIL PROTECTED] Enviada em: terça-feira, 26 de fevereiro de 2008 13:47 Para: Thiago Pojda Assunto: RE: [PHP-DB] MySQL replication delaying issue Hay, If U dont 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. Thats Y I sent that message to phpresources list also. From: Thiago Pojda [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 26, 2008 8:39 PM To: Lasitha Alawatta; php-db@lists.php.net; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RES: [PHP-DB] 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:[EMAIL PROTECTED] Enviada em: terça-feira, 26 de fevereiro de 2008 12:50 Para: php-db@lists.php.net; [EMAIL PROTECTED]; [EMAIL PROTECTED] Assunto: [PHP-DB] 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 its 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 + [EMAIL PROTECTED] 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.
RES: [PHP-DB] 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:[EMAIL PROTECTED] Enviada em: terça-feira, 26 de fevereiro de 2008 12:50 Para: php-db@lists.php.net; [EMAIL PROTECTED]; [EMAIL PROTECTED] Assunto: [PHP-DB] 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 its 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:[EMAIL PROTECTED] [EMAIL PROTECTED] 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.
RE: [PHP-DB] MySQL replication delaying issue
Oky, Sorry for that.. J From: Thiago Pojda [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 26, 2008 8:49 PM To: Lasitha Alawatta Cc: php-db@lists.php.net Subject: RES: [PHP-DB] 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:[EMAIL PROTECTED] Enviada em: terça-feira, 26 de fevereiro de 2008 13:47 Para: Thiago Pojda Assunto: RE: [PHP-DB] 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:[EMAIL PROTECTED] Sent: Tuesday, February 26, 2008 8:39 PM To: Lasitha Alawatta; php-db@lists.php.net; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RES: [PHP-DB] 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:[EMAIL PROTECTED] Enviada em: terça-feira, 26 de fevereiro de 2008 12:50 Para: php-db@lists.php.net; [EMAIL PROTECTED]; [EMAIL PROTECTED] Assunto: [PHP-DB] 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 + [EMAIL PROTECTED] cid:image002.jpg@01C7A7A4.0AC70A00 http://www.dotw.com/ 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. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MySQL replication delaying issue
Hello, Thanks a LOT... Best Regards, Lasitha From: Thiago Pojda [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 26, 2008 9:51 PM To: Lasitha Alawatta Cc: php-db@lists.php.net Subject: RES: [PHP-DB] MySQL replication delaying issue 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:[EMAIL PROTECTED] Enviada em: terça-feira, 26 de fevereiro de 2008 14:44 Para: Thiago Pojda Cc: php-db@lists.php.net Assunto: RE: [PHP-DB] MySQL replication delaying issue Oky, Sorry for that.. J From: Thiago Pojda [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 26, 2008 8:49 PM To: Lasitha Alawatta Cc: php-db@lists.php.net Subject: RES: [PHP-DB] 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:[EMAIL PROTECTED] Enviada em: terça-feira, 26 de fevereiro de 2008 13:47 Para: Thiago Pojda Assunto: RE: [PHP-DB] 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:[EMAIL PROTECTED] Sent: Tuesday, February 26, 2008 8:39 PM To: Lasitha Alawatta; php-db@lists.php.net; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RES: [PHP-DB] 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:[EMAIL PROTECTED] Enviada em: terça-feira, 26 de fevereiro de 2008 12:50 Para: php-db@lists.php.net; [EMAIL PROTECTED]; [EMAIL PROTECTED] Assunto: [PHP-DB] 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 + [EMAIL PROTECTED] cid:image002.jpg@01C7A7A4.0AC70A00 http://www.dotw.com/ 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. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RES: [PHP-DB] MySQL replication delaying issue
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:[EMAIL PROTECTED] Enviada em: terça-feira, 26 de fevereiro de 2008 14:44 Para: Thiago Pojda Cc: php-db@lists.php.net Assunto: RE: [PHP-DB] MySQL replication delaying issue Oky, Sorry for that.. J From: Thiago Pojda [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 26, 2008 8:49 PM To: Lasitha Alawatta Cc: php-db@lists.php.net Subject: RES: [PHP-DB] 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:[EMAIL PROTECTED] Enviada em: terça-feira, 26 de fevereiro de 2008 13:47 Para: Thiago Pojda Assunto: RE: [PHP-DB] MySQL replication delaying issue Hay, If U dont 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. Thats Y I sent that message to phpresources list also. From: Thiago Pojda [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 26, 2008 8:39 PM To: Lasitha Alawatta; php-db@lists.php.net; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RES: [PHP-DB] 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:[EMAIL PROTECTED] Enviada em: terça-feira, 26 de fevereiro de 2008 12:50 Para: php-db@lists.php.net; [EMAIL PROTECTED]; [EMAIL PROTECTED] Assunto: [PHP-DB] 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 its 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 + [EMAIL PROTECTED] 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.
