2016 年的架構
2016年的硬體：
- 4 Microsoft SQL Servers (new hardware for 2 of them)
- 11 IIS Web Servers (new hardware)
- 2 Redis Servers (new hardware)
- 3 Tag Engine servers (new hardware for 2 of the 3)
- 3 Elasticsearch servers (same)
- 4 HAProxy Load Balancers (added 2 to support CloudFlare)
- 2 Networks (each a Nexus 5596 Core + 2232TM Fabric Extenders, upgraded to 10Gbps everywhere)
- 2 Fortinet 800C Firewalls (replaced Cisco 5525-X ASAs)
- 2 Cisco ASR-1001 Routers (replaced Cisco 3945 Routers)
- 2 Cisco ASR-1001-x Routers (new!)
資料來源：
Stack Overflow: The Architecture - 2016 Edition
下面是 2023 ByteByteGo 介紹 Stack Overflow 的架構影片
以最簡單、"最傳統"的軟硬體技術支撐每月 20億流量
總共只使用 9台Web Server
以及 ElasticSearch + SQL Server (1.5T RAM) + Redis
另外， Stack Overflow 的資料庫 有提供下載：
https://meta.stackexchange.com/questions/224873/all-stack-exchange-data-dumps
XML格式的檔案在這裡
https://archive.org/download/stackexchange_20230614
database schema 相關：
https://meta.stackexchange.com/questions/2677/database-schema-documentation-for-the-public-data-dump-and-sede
https://github.com/StackExchange/StackExchange.DataExplorer
The Schema Visualized
其他參考：
解密 StackOverflow 架构：SO 的硬件配置 (51cto)