To add to OP, Nick Craver (formerly @Stack Overflow) wrote an insightful series [1] (2016) on Stack Overflow’s architecture.

[1] https://nickcraver.com/blog/2016/02/17/stack-overflow-the-ar...