Re: [GENERAL] Setting up replication slave on remote high latency host

Thank you for that. Back to the drawing board! On Wed, Nov 15, 2017 at 9:30 PM, John R Pierce wrote: > On 11/15/2017 6:02 PM, Rory Falloon wrote: > >> >> Right now I am trying to dump the database, gzip, move across, and import >> into the new slave (which is configured as

Re: [GENERAL] Setting up replication slave on remote high latency host

On 11/15/2017 6:02 PM, Rory Falloon wrote: Right now I am trying to dump the database, gzip, move across, and import into the new slave (which is configured as a master to perform the initial setup). Ideally I do this dump, move and import during a period of inactivity on the master so the

[GENERAL] Setting up replication slave on remote high latency host

Hi, Thoughts and opinions on this please - I have a db (data dir is 90gb) that I am trying to setup on a replication slave. The slave is on a host which maintains latency over 300ms at all times (wan link). Other times I have done this setup, I have simply rsync'ed the data dir to another host,