Our production environments typically consists in 4-8 Apache web servers and 2 (My)SQL servers :
Each web server is affiliated to one SQL server SQL servers have a circular replication setup All web servers are load balanced, by Pound for example. Every night a job backups one of the SQL servers, locking the affiliated web servers for about 10-15 minutes.
Is there a way to configure the balancing to avoid reaching those locked servers for a short time?
Is there another way to handle this lock, other than backuping a non-production third server?
PS: We envisage to reload the Pound configuration, just before and after the backup, with an appropriate configuration file, but it feels a bit odd...
The question has already been asked on StackOverflow but closed as 'not development centric' purposed. As a matter of fact, it's more a production and run discussion.