[LRUG] Sites drop off web

[Andrew Stewart]

Tim,

> I had a similar problem with CentOS. mysqldump was stalling everything for a couple of minutes when it ran.
> 
> Saw some pretty epic query times popping up in NewRelic RPM around that time. The site just stalled for a few minutes.
> 
> Pingdom reported a minute or two of downtime.

Thanks for the information.  I use mysqldump too -- with increasing reluctance because I've been seeing the same behaviour as you.  As a stopgap measure I wrapped it in a timeout[1] but I think the real solution is to move to Postgres and whatever backup mechanism it has.

Cheers,
Andy

[1] https://github.com/airblade/mysql_s3_backup/commit/457d73efeb47dbb26f0ad8782776cbec490d5f05