Ask YC: How to perform a Scheduled Maintenance?
I want to perform change to database schema change to an app, and want it to be performed without affecting the user data. So I thought it would be better to perform a scheduled maintenance by taking the site down. Any advices on areas I should be careful and gotchas I should consider when going for such process?
Give yourself enough time that you're confident you'll be able to finish the maintenance within that timeframe. I was bitten more than once by scheduling a maintenance window too small, and then becoming frantic as the maintenance window passed and I still wasn't finished.