News for hackers. Stuff that matters.
Re:The architecture of Stack Overflow [video] by sklivvz1971 on Tuesday January 14, 2014 @05:43AM (#7056326)
All the schema changes are applied to all site databases at the same time. They need to be backwards compatible so, for example, if you need to rename a column - a worst case scenario - it's a multiple steps process: add a new column, add code which works with both columns, back fill the new column, change code so it works with the new column only, remove the old column.
Re:The architecture of Stack Overflow [video] by avemg on Tuesday January 14, 2014 @01:51PM (#7058893)
Thanks for the reply. We have a similar architecture where I work so this is interesting to me. A couple more questions if you don't mind:

- Do you use any tools for orchestrating the rollout of those schema changes or do you just have some homegrown scripts?

- Do you separate your schema versioning and deployment process from your application versioning and deployment process?

- How do you handle cases where backwards-compatibility is not possible? For example, a new application feature that depends on a brand new table.