Re:Rails migrations with no downtime
by glenngillen on Monday February 13, 2012 @01:27AM
(#3584485)
If you're using postgres on Heroku you can get a fork of your production db to test things like these:
http://devcenter.heroku.com/articles/heroku-postgresql#fork_...
A staging system with a db server provisioned similarly to production lets you "smoke test" the migrations and deploy before you take down prod -- but especially with MySQL, that happily blocks all reads during an ALTER, you should really watch out for any table ~> 1M rows (or if they're wide, even fewer than that).