[LRUG] Sites drop off web

[Andrew Stewart]

On 8 Aug 2011, at 13:05, Matthew Rudy Jacobs wrote:
> This may be overkill for you, 
> But it may kill two birds with one stone. 
> 
> - set up a replication to a single slave 
> - when you want to dump, stop replication 
> - dump from the slave 
> - restart after the dump
> 
> Thereby you have a hot copy to failover to
> As well as a mechanism for taking consistent database snapshots 
> Without affecting the performance of your service. 

Sounds like a good idea.  In hand-wavy terms, is it much of a hassle to set up MySQL replication?

Cheers,
Andy