I would like to use a combination of an ELB and AutoScaling for a web application. For upgrades to the web application that don't involve changing the database, I can simply rotate all the instances in the AG with an updated image, etc.
However, if we have an upgrade with a database migration, I believe I will need to redirect all traffic to a static page while we are performing the migration.
What is the recommended way to handle these situations? Should I use an additional proxy in front of the ELB and point it to a server with the static page during the ugprade?
As you can tell I don't have a systems background, so forgive my ignorance.