News for hackers. Stuff that matters.
Re:Rails migrations with no downtime by mceachen on Sunday February 12, 2012 @11:56PM (#3584273)
Absolutely! The author was very thorough with the change process, which is great, but downtime during ALTER should absolutely be broached as well.

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).

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_...