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 -----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=1. See: http://dev.mysql.com/doc/mysql/en/replication-options.html "Andrew Braithwaite" <[EMAIL PROTECTED]> wrote: > Hi, > > We have replication running here and it has been excellent for a > number of years. =20 > > Recently we have been having lag in replication from London to Palo > Alto (Plenty of bandwidth but a latency of 300ms round trip). =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 > servers that are reasonable close to the master, the Palo Alto server > is getting over an hour behind at times. > > Does anyone know if there is something I can do to solve this? =20 > > What experiences have others had in the past? > > Perhaps there is some way to increase the packet size or something to > get over this latency problem... > > Or any other ideas? > > Cheers, > > Andrew > > SQL, Query > > > -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]