MySQL replication delaying issue
am 26.02.2008 16:49:31 von Lasitha Alawatta------_=_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
=0AHello Everybody,
=0AWe have 6 multi-m=
aster MySql instances within a LAN , that are
replicating is a sequent=
ial manner.
Server Environment : Six identical Linux Enterprise=
version 4 running,
servers with having MySQL version 6.
=0A=
we are using "MySQL multi-master replication" method for database
repl=
ication.
=0AThere is a delay (5-7 minutes) of that d=
ata replication process.
=0AWe notice that it's because of MySQL=
table locking.
=0AYour comments are highly apprecia=
ted.
Many thanks in advance and be=
st regards,
=0ALasitha Alawatta
Applicati=
on Developer
Destinations of the World Holding Establishment
=0D=
=0AP O Box: 19950
Dubai, United Arab Emirates
( Ph +9=
71 4 295 8510 (Board) / 1464 (Ext.)
7 Fax +971 4 295 8910
+=
lasitha.a@dotw.com
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
any 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.
This 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
in connec=
tion therewith.
=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
by 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=
.
=0A
------_=_NextPart_002_01C8788F.317F0FA7
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
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=
microsoft.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
=
link=3Dpurple>
ormal>
Hello Everybody=
,
=0A
We have 6 multi-master MySql instances within a LAN=
, that
are replicating is a sequential manner.
=0A
Server Environment : Six identical Linux Ente=
rprise version
4 running, servers with having MySQL version 6.
we are using “MySQL multi-ma=
ster replication” method
for database replication.
=3DMsoNormal>There is a delay (5-7 minutes) of that data replication proces=
s.
We notice that it&#=
8217;s because of MySQL table locking.
MsoNormal>
Your commen=
ts are highly appreciated.
<=
o:p>
=0A
Many thanks in advance and best regards,
font-family:"Arial","sans-serif"'>
p class=3DMsoNormal> "sans-serif"; color:gray'>Lasitha Alawatta nt-size:12.0pt; font-family:"Times New Roman","serif";color:gray'>
ize:8.0pt;font-family:"Tahoma","sans-serif";
color:gray '>Application D=
eveloper
","sans-serif";color:gray'>
Normal>
=0Acolor:silver'>Destinations of the World Holding Establishment=
:silver'>
yle=3D'font-size:7.0pt;font-family:"Tahoma","sans-serif";=0D =0Acolor:silver=
'>P O Box: 19950
"Tahoma","sans-serif";color:silver'>
ass=3DMsoNormal>
s-serif";
color:silver'>Dubai, United Arab Emirates
yle=3D'font-size:
7.0pt;font-family:"Tahoma","sans-seri f";color:silver=
'>
font-size:7.0pt;font-family:Wingdings;
color:silver'>(
pan style=3D'font-size:7.0pt;font-family:"Tahoma","sans-serif";= 0D=0Acolor:=
e=3D'font-size:7.0pt;font-family:"Tahoma","sans-serif";color :silver'>
silver'> Ph +971 4 295 8510 (Board) / 1464 (Ext.)
/o:p>
e:7.0pt;font-family:"Wingdings 2";
color:silver'>7
style=3D'font-size:7.0pt;font-family:"Tahoma","sans-serif";= 0D=0Acolor:silv=
er'> Fax +971 4 295 8910
t-family:"Tahoma","sans-serif";color:green'>
=3D'font-size:7.0pt;font-family:Wingdings;color:silver'>+
y'>
pan style=3D'color:blue'>lasitha.a@dotw.com
e=3D"color:black">
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 =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. This 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 in connection therewith.= This 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 by 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. |
------_=_NextPart_002_01C8788F.317F0FA7--
------_=_NextPart_001_01C8788F.317F0FA7--