rss
12-10-2012, 11:11 PM
Today I made intermission (https://github.com/37signals/intermission) public. As I mentioned in my post about mysql_role_swap (http://37signals.com/svn/posts/3344-making-database-maintenance-fun-mysqlroleswap) we’ve been working hard to limit / eliminate the impact our operations maintenance tasks have on our customer’s experience.
A few people **ticed the /tmp/hold “leftover” in mysql_role_swap script. intermission is a product of that early exploration with coordinating database maintenance with request pausing in the web application tier. I’ve done a good bit of **n production testing with intermission, but only limited production testing.
Last Friday we used intermission with mysql_role_swap to move Writeboard’s database to a new server. We had a single user facing exception, and we think it was likely caused by something other than the maintenance. For Friday’s maintenance we enabled request pausing via intermission, ran mysql_role_swap, restarted the unicorn (rails) processes, and then unpaused the requests. Total maintenance time was just a few seconds!
http://feeds.feedburner.com/~ff/37signals/beMH?d=yIl2AUoC8zA (http://feeds.feedburner.com/~ff/37signals/beMH?a=qxStJvYlU7k:A69bmVab_Sc:yIl2AUoC8zA) http://feeds.feedburner.com/~ff/37signals/beMH?d=7Q72WNTAKBA (http://feeds.feedburner.com/~ff/37signals/beMH?a=qxStJvYlU7k:A69bmVab_Sc:7Q72WNTAKBA)
http://feeds.feedburner.com/~r/37signals/beMH/~4/qxStJvYlU7k
أكثر... (http://feedproxy.google.com/~r/37signals/beMH/~3/qxStJvYlU7k/3358-making-application-maintenance-fun)
A few people **ticed the /tmp/hold “leftover” in mysql_role_swap script. intermission is a product of that early exploration with coordinating database maintenance with request pausing in the web application tier. I’ve done a good bit of **n production testing with intermission, but only limited production testing.
Last Friday we used intermission with mysql_role_swap to move Writeboard’s database to a new server. We had a single user facing exception, and we think it was likely caused by something other than the maintenance. For Friday’s maintenance we enabled request pausing via intermission, ran mysql_role_swap, restarted the unicorn (rails) processes, and then unpaused the requests. Total maintenance time was just a few seconds!
http://feeds.feedburner.com/~ff/37signals/beMH?d=yIl2AUoC8zA (http://feeds.feedburner.com/~ff/37signals/beMH?a=qxStJvYlU7k:A69bmVab_Sc:yIl2AUoC8zA) http://feeds.feedburner.com/~ff/37signals/beMH?d=7Q72WNTAKBA (http://feeds.feedburner.com/~ff/37signals/beMH?a=qxStJvYlU7k:A69bmVab_Sc:7Q72WNTAKBA)
http://feeds.feedburner.com/~r/37signals/beMH/~4/qxStJvYlU7k
أكثر... (http://feedproxy.google.com/~r/37signals/beMH/~3/qxStJvYlU7k/3358-making-application-maintenance-fun)