------_=_NextPart_001_01C8788F.317F0FA7
Content-Type: multipart/alternative;
boundary="----_=_NextPart_002_01C8788F.317F0FA7"
------_=_NextPart_002_01C8788F.317F0FA7
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
=0D=0A=0D=0AHello Everybody,=0D=0A=0D=0A =0D=0A=0D=0AWe have 6 multi-m=
aster MySql instances within a LAN , that are=0D=0Areplicating is a sequent=
ial manner.=0D=0A=0D=0AServer Environment : Six identical Linux Enterprise=
version 4 running,=0D=0Aservers with having MySQL version 6. =0D=0A=0D=0A=
we are using "MySQL multi-master replication" method for database=0D=0Arepl=
ication.=0D=0A=0D=0A =0D=0A=0D=0AThere is a delay (5-7 minutes) of that d=
ata replication process. =0D=0A=0D=0AWe notice that it's because of MySQL=
table locking.=0D=0A=0D=0A =0D=0A=0D=0AYour comments are highly apprecia=
ted.=0D=0A=0D=0A =0D=0A=0D=0A =0D=0A=0D=0AMany thanks in advance and be=
st regards,=0D=0A=0D=0A =0D=0A=0D=0ALasitha Alawatta=0D=0A=0D=0AApplicati=
on Developer=0D=0A=0D=0ADestinations of the World Holding Establishment=0D=0A=0D=
=0AP O Box: 19950=0D=0A=0D=0ADubai, United Arab Emirates=0D=0A=0D=0A( Ph +9=
71 4 295 8510 (Board) / 1464 (Ext.)=0D=0A=0D=0A7 Fax +971 4 295 8910=0D=0A+=
lasitha.a [at] dotw.com <mailto:lasitha.a [at] dotw.com> =0D=0A=0D=0A <http://ww=
w.dotw.com/> =0D=0A=0D=0A =0D=0A=0D=0ADOTW DISCLAIMER:=0D=0A=0D=0AThis =
e-mail and any attachments are strictly confidential and intended for the a=
ddressee only. If you are not the named addressee you must not disclose, co=
py or take=0D=0Aany action in reliance of this transmission and you should =
notify us as soon as possible. If you have received it in error, please con=
tact the message sender immediately.=0D=0AThis e-mail and any attachments a=
re believed to be free from viruses but it is your responsibility to carry =
out all necessary virus checks and DOTW accepts no liability=0D=0Ain connec=
tion therewith. =0D=0A=0D=0AThis e-mail and all other electronic (includi=
ng voice) communications from the sender's company are for informational pu=
rposes only. No such communication is intended=0D=0Aby the sender to const=
itute either an electronic record or an electronic signature or to constitu=
te any agreement by the sender to conduct a transaction by electronic means=
=2E=0D=0A
------_=_NextPart_002_01C8788F.317F0FA7
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" xmlns:p=3D"urn:schemas-m=
icrosoft-com:office:powerpoint" xmlns:a=3D"urn:schemas-microsoft-com:office=
:access" xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s=3D"=
uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs=3D"urn:schemas-microsof=
t-com:rowset" xmlns:z=3D"#RowsetSchema" xmlns:b=3D"urn:schemas-microsoft-co=
m:office:publisher" xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadshee=
t" xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" xmlns=
:oa=3D"urn:schemas-microsoft-com:office:activation" xmlns:html=3D"http://ww=
w.w3.org/TR/REC-html40" xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope=
/" xmlns:D=3D"DAV:" xmlns:x2=3D"http://schemas.microsoft.com/office/excel/2=
003/xml" xmlns:ois=3D"http://schemas.microsoft.com/sharepoint/soap/oi s/" xm=
lns:dir=3D"http://schemas.microsoft.com/sharepoint/soap/dire ctory/" xmlns:d=
s=3D"http://www.w3.org/2000/09/xmldsig#" xmlns:dsp=3D"http://schemas.micros=
oft.com/sharepoint/dsp" xmlns:udc=3D"http://schemas.microsoft.com/data/udc"=
xmlns:xsd=3D"http://www.w3.org/2001/XMLSchema" xmlns:sub=3D"http://schemas=
=2Emicrosoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec=3D"http://www.w3.=
org/2001/04/xmlenc#" xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" =
xmlns:sps=3D"http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi=3D"ht=
tp://www.w3.org/2001/XMLSchema-instance" xmlns:udcxf=3D"http://schemas.micr=
osoft.com/data/udc/xmlfile" xmlns:wf=3D"http://schemas.microsoft.com/sharep=
oint/soap/workflow/" xmlns:mver=3D"http://schemas.openxmlformats.org/markup=
-compatibility/2006" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12=
/omml" xmlns:mrels=3D"http://schemas.openxmlformats.org/package/200 6/relati=
onships" xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/2006=
/types" xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/2006/=
messages" xmlns=3D"http://www.w3.org/TR/REC-html40">=0D=0A=0D=0A<head>=0D=0A=
<meta http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii">=0D=
=0A<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">=0D=
=0A<!--[if !mso]>=0D=0A<style>=0D=0Av\:* {behavior:url(#default#VML);}=0D=0A=
o\:* {behavior:url(#default#VML);}=0D=0Aw\:* {behavior:url(#default#VML);}=0D=
=0A.shape {behavior:url(#default#VML);}=0D=0A</style>=0D=0A<![endif]-->=0D=0A=
<style>=0D=0A<!--=0D=0A /* Font Definitions */=0D=0A [at] font-face=0D=0A=09{fo=
nt-family:Wingdings;=0D=0A=09panose-1:5 0 0 0 0 0 0 0 0 0;}=0D=0A [at] font-face=0D=
=0A=09{font-family:"Cambria Math";=0D=0A=09panose-1:2 4 5 3 5 4 6 3 2 4;}=0D=
=0A [at] font-face=0D=0A=09{font-family:Calibri;=0D=0A=09panose-1 :2 15 5 2 2 2 4=
3 2 4;}=0D=0A [at] font-face=0D=0A=09{font-family:Tahoma;=0D=0A=09pan ose-1:2 11=
6 4 3 5 4 4 2 4;}=0D=0A [at] font-face=0D=0A=09{font-family:"Wingdings 2";=0D=0A=
=09panose-1:5 2 1 2 1 5 7 7 7 7;}=0D=0A /* Style Definitions */=0D=0A p.Mso=
Normal, li.MsoNormal, div.MsoNormal=0D=0A=09{margin:0in;=0D=0A=09margin-bot=
tom:.0001pt;=0D=0A=09font-size:11.0pt;=0D=0A=09font-family:" Calibri","sans-=
serif";}=0D=0Aa:link, span.MsoHyperlink=0D=0A=09{mso-style-priority:99;=0D=0A=
=09color:blue;=0D=0A=09text-decoration:underline;}=0D=0Aa:vi sited, span.Mso=
HyperlinkFollowed=0D=0A=09{mso-style-priority:99;=0D=0A=09co lor:purple;=0D=0A=
=09text-decoration:underline;}=0D=0Ap.MsoAcetate, li.MsoAcetate, div.MsoAce=
tate=0D=0A=09{mso-style-priority:99;=0D=0A=09mso-style-link: "Balloon Text C=
har";=0D=0A=09margin:0in;=0D=0A=09margin-bottom:.0001pt;=0D= 0A=09font-size:=
8.0pt;=0D=0A=09font-family:"Tahoma","sans-serif";}=0D=0Aspan .EmailStyle17=0D=
=0A=09{mso-style-type:personal-compose;=0D=0A=09font-family: "Calibri","sans=
-serif";=0D=0A=09color:windowtext;}=0D=0Aspan.BalloonTextCha r=0D=0A=09{mso-=
style-name:"Balloon Text Char";=0D=0A=09mso-style-priority:99;=0D=0A=09mso-=
style-link:"Balloon Text";=0D=0A=09font-family:"Tahoma","sans-serif";}=0D=0A=
=2EMsoChpDefault=0D=0A=09{mso-style-type:export-only;}=0D=0A [at] page Section1=0D=
=0A=09{size:8.5in 11.0in;=0D=0A=09margin:1.0in 1.0in 1.0in 1.0in;}=0D=0Adiv=
=2ESection1=0D=0A=09{page:Section1;}=0D=0A-->=0D=0A</style>=0D=0A<!--[if gt=
e mso 9]><xml>=0D=0A <o:shapedefaults v:ext=3D"edit" spidmax=3D"2050" />=0D=
=0A</xml><![endif]--><!--[if gte mso 9]><xml>=0D=0A <o:shapelayout v:ext=3D=
"edit">=0D=0A <o:idmap v:ext=3D"edit" data=3D"1" />=0D=0A </o:shapelayout>=
</xml><![endif]-->=0D=0A</head>=0D=0A=0D=0A<body lang=3DEN-US link=3Dblue v=
link=3Dpurple>=0D=0A=0D=0A<div class=3DSection1>=0D=0A=0D=0A<p class=3DMsoN=
ormal><o:p> </o:p></p>=0D=0A=0D=0A<p class=3DMsoNormal>Hello Everybody=
,<o:p></o:p></p>=0D=0A=0D=0A<p class=3DMsoNormal><o:p> </o:p></p>=0D=0A=0D=
=0A<p class=3DMsoNormal>We have 6 multi-master MySql instances within a LAN=
, that=0D=0Aare replicating is a sequential manner.<o:p></o:p></p>=0D=0A=0D=
=0A<p class=3DMsoNormal>Server Environment : Six identical Linux Ente=
rprise version=0D=0A4 running, servers with having MySQL version 6. <o:p></=
o:p></p>=0D=0A=0D=0A<p class=3DMsoNormal>we are using “MySQL multi-ma=
ster replication” method=0D=0Afor database replication.<o:p></o:p></p=
>=0D=0A=0D=0A<p class=3DMsoNormal><o:p> </o:p></p>=0D=0A=0D=0A<p class=
=3DMsoNormal>There is a delay (5-7 minutes) of that data replication proces=
s.=0D=0A<o:p></o:p></p>=0D=0A=0D=0A<p class=3DMsoNormal>We notice that it&#=
8217;s because of MySQL table locking.<o:p></o:p></p>=0D=0A=0D=0A<p class=3D=
MsoNormal><o:p> </o:p></p>=0D=0A=0D=0A<p class=3DMsoNormal>Your commen=
ts are highly appreciated.<o:p></o:p></p>=0D=0A=0D=0A<p class=3DMsoNormal><=
o:p> </o:p></p>=0D=0A=0D=0A<p class=3DMsoNormal><o:p> </o:p></p>=0D=
=0A=0D=0A<p class=3DMsoNormal>Many thanks in advance and best regards,<o:p>=
</o:p></p>=0D=0A=0D=0A<p class=3DMsoNormal><span style=3D'font-size:10.0pt;=
font-family:"Arial","sans-serif"'><o:p> </o:p></span></p>=0D=0A=0D=0A<=
p class=3DMsoNormal><b><span style=3D'font-size:8.0pt;font-family:"Tahoma",=
"sans-serif";=0D=0Acolor:gray'>Lasitha Alawatta</span></b><span style=3D'fo=
nt-size:12.0pt;=0D=0Afont-family:"Times New Roman","serif";color:gray'><o:p=
></o:p></span></p>=0D=0A=0D=0A<p class=3DMsoNormal><b><span style=3D'font-s=
ize:8.0pt;font-family:"Tahoma","sans-serif";=0D=0Acolor:gray '>Application D=
eveloper</span></b><span style=3D'font-size:8.0pt;=0D=0Afont-family:"Tahoma=
","sans-serif";color:gray'><o:p></o:p></span></p>=0D=0A=0D=0A<p class=3DMso=
Normal><b><span style=3D'font-size:7.0pt;font-family:"Tahoma","sans-serif";=0D=
=0Acolor:silver'>Destinations of the World Holding Establishment</span></b>=
<span=0D=0Astyle=3D'font-size:7.0pt;font-family:"Tahoma","sans-serif";color=
:silver'><o:p></o:p></span></p>=0D=0A=0D=0A<p class=3DMsoNormal><b><span st=
yle=3D'font-size:7.0pt;font-family:"Tahoma","sans-serif";=0D =0Acolor:silver=
'>P O Box: 19950</span></b><span style=3D'font-size:7.0pt;font-family:=0D=0A=
"Tahoma","sans-serif";color:silver'><o:p></o:p></span></p>=0D=0A=0D=0A<p cl=
ass=3DMsoNormal><b><span style=3D'font-size:7.0pt;font-family:"Tahoma","san=
s-serif";=0D=0Acolor:silver'>Dubai, United Arab Emirates</span></b><span st=
yle=3D'font-size:=0D=0A7.0pt;font-family:"Tahoma","sans-seri f";color:silver=
'><o:p></o:p></span></p>=0D=0A=0D=0A<p class=3DMsoNormal><b><span style=3D'=
font-size:7.0pt;font-family:Wingdings;=0D=0Acolor:silver'>(</span></b><b><s=
pan style=3D'font-size:7.0pt;font-family:"Tahoma","sans-serif";= 0D=0Acolor:=
silver'> Ph +971 4 295 8510 (Board) / 1464 (Ext.)</span></b><span=0D=0Astyl=
e=3D'font-size:7.0pt;font-family:"Tahoma","sans-serif";color :silver'><o:p><=
/o:p></span></p>=0D=0A=0D=0A<p class=3DMsoNormal><b><span style=3D'font-siz=
e:7.0pt;font-family:"Wingdings 2";=0D=0Acolor:silver'>7</span></b><b><span =
style=3D'font-size:7.0pt;font-family:"Tahoma","sans-serif";= 0D=0Acolor:silv=
er'> Fax +971 4 295 8910</span></b><span style=3D'font-size:7.0pt;=0D=0Afon=
t-family:"Tahoma","sans-serif";color:green'><br>=0D=0A</span><b><span style=
=3D'font-size:7.0pt;font-family:Wingdings;color:silver'>+</span></b><b><spa=
n=0D=0Astyle=3D'font-size:7.0pt;font-family:"Tahoma","sans-s erif";color:gra=
y'> </span></b><u><span=0D=0Astyle=3D'font-size:7.0pt;font-family:"Tah=
oma","sans-serif";color:blue'><a=0D=0Ahref=3D"mailto:lasitha.a [at] dotw.com"><s=
pan style=3D'color:blue'>lasitha.a [at] dotw.com</span></a></span></u> <spa=
n=0D=0Astyle=3D'font-size:12.0pt;font-family:"Times New Roman","serif"'><o:=
p></o:p></span></p>=0D=0A=0D=0A<p class=3DMsoNormal><a href=3D"http://www.d=
otw.com/"><span style=3D'color:windowtext;=0D=0Atext-decoration:none'><img =
border=3D0 width=3D153 height=3D107 id=3D"Picture_x0020_1"=0D=0Asrc=3D"cid:=
image001.jpg [at] 01C878AC.C420EFA0"=0D=0Aalt=3D"cid:image002.jpg [at] 01C7A7A4.0AC70=
A00"></span></a><o:p></o:p></p>=0D=0A=0D=0A<p class=3DMsoNormal><o:p> =
</o:p></p>=0D=0A=0D=0A</div>=0D=0A=0D=0A<br><br><table bgcolor=3Dwhite styl=
e=3D"color:black"><tr><td><br>DOTW DISCLAIMER:<br>=0D=0A<br>=0D=0AThis=
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<br>=0D=
=0Aany action in reliance of this transmissio=
n and you should notify us as soon =
as possible. If you have received it in&=
nbsp;error, please contact the message sender =
;immediately.<br>=0D=0AThis e-mail and any attachments&=
nbsp;are believed to be free from viruses&nbs=
p;but it is your responsibility to carry =
;out all necessary virus checks and DOTW =
;accepts no liability<br>=0D=0Ain connection therewith.=
<br>=0D=0A<br>=0D=0AThis e-mail and all other&nbs=
p;electronic (including voice) communications from =
;the sender's company are for informational&nb=
sp;purposes only. No such communication is&n=
bsp;intended<br>=0D=0Aby the sender to constitute =
either an electronic record or an electronic&=
nbsp;signature or to constitute any agreement =
;by the sender to conduct a transaction =
by electronic means.<br>=0D=0A</td></tr></table></body>=0D=0A=0D=0A=
</html>=0D=0A
------_=_NextPart_002_01C8788F.317F0FA7--
------_=_NextPart_001_01C8788F.317F0FA7--
