We are shortly moving to new server infrastructure which will have 2 webservers behind a load balancer that are deployed using Capistrano. The only area of concern I have is how to handle module updates (especially ones that modify the database using setup scripts).
If the two servers are hit at the same time the update scripts will trigger at the same time before sore_resource has been updated potentially causing Magento to crash.
I'm considering setting up an admin site on one server (separate copy of the codebase with it's own vhost) that is deployed to first and an update_modules script run to carry out the modifications of the DB and then deploying out to the live webservers.
Can anyone see any issues with this or have any other suggestions as to the best way to handle DB updates?