Hello.
I think that the speed of every single update which slave get from the master will grow, and slave could receive updates more frequently. But only practical usage will show the influence of this option in your case. "Andrew Braithwaite" <[EMAIL PROTECTED]> wrote: > Hi, > > I can see how this would help with bandwidth (I don't have a bandwidth > problem as explained below) but how will this help with the latency I > have? > > Cheers, > > Andrew=20 > > -----Original Message----- > From: Gleb Paharenko [mailto:[EMAIL PROTECTED] > Sent: Fri 11 March 2005 14:51 > To: mysql@lists.mysql.com > Subject: Re: Delays in replication and internet latency > > Hello. > > You may use --slave_compressed_protocol=3D1. See: > http://dev.mysql.com/doc/mysql/en/replication-options.html > > > > "Andrew Braithwaite" <[EMAIL PROTECTED]> wrote: >> Hi, >>=20 >> We have replication running here and it has been excellent for a=20 >> number of years. =3D20 >>=20 >> Recently we have been having lag in replication from London to Palo=20 >> Alto (Plenty of bandwidth but a latency of 300ms round trip). =3D20 >>=20 >> The replications binlogs are being written at a rate of about 100MB to > >> 200MB per hour and whilst we have no problems replicating to several=20 >> servers that are reasonable close to the master, the Palo Alto server=20 >> is getting over an hour behind at times. >>=20 >> Does anyone know if there is something I can do to solve this? =3D20 >>=20 >> What experiences have others had in the past? >>=20 >> Perhaps there is some way to increase the packet size or something to=20 >> get over this latency problem... >>=20 >> Or any other ideas? >>=20 >> Cheers, >>=20 >> Andrew >>=20 >> SQL, Query >>=20 >>=20 >>=20 > > > -- > For technical support contracts, goto > https://order.mysql.com/?ref=3Densita > This email is sponsored by Ensita.NET http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > <___/ www.mysql.com > > > > > --=20 > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
