List:Replication« Previous MessageNext Message »
From:Rick James Date:February 26 2008 5:09pm
Subject:RE: MySQL replication delaying issue
View as plain text  
I hope you don't mean 6 masters in a circle.  If one fails, you will
have a mess.


________________________________

	From: Lasitha Alawatta [mailto:Lasitha.A@stripped] 
	Sent: Tuesday, February 26, 2008 8:28 AM
	To: replication@stripped
	Subject: 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
	+ lasitha.a@stripped <mailto:lasitha.a@stripped>  

	cid:image002.jpg@stripped <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.
	


Thread
MySQL replication delaying issueLasitha Alawatta26 Feb
  • Re: MySQL replication delaying issueMarcus Bointon26 Feb
  • RE: MySQL replication delaying issueRick James26 Feb
    • Re: MySQL replication delaying issueMarcus Bointon26 Feb
      • Re: MySQL replication delaying issueJed Reynolds26 Feb
        • Re: MySQL replication delaying issueMarcus Bointon26 Feb
          • RE: MySQL replication delaying issueRick James26 Feb
            • Re: MySQL replication delaying issueJed Reynolds26 Feb
        • Re: MySQL replication delaying issueEric Bergen26 Feb
  • Re: MySQL replication delaying issueJed Reynolds26 Feb
    • RE: MySQL replication delaying issueRick James26 Feb
  • RE: MySQL replication delaying issueLasitha Alawatta27 Feb