Surviving the 2008 Elections
summary
Migrates legacy MySQL schemas to auto‑increment keys, removes a redundant full‑text index that grows to 17GB index on 9GB data, and archives old rows; expands caching with memcache but fixes a five‑minute cache stampede by adding Lua/C memcache support to mod_magnet, serving anonymous pages from Lighty and avoiding mod_perl; consolidates servers (adds quad‑Xeons, octa‑core DB hosts), netboots webheads and scales to nine during election day; site sustains highs (server load ~0.5–1.8, brief ~3) despite an 800 Mbps map feed.
AI-written summary · about
related talks
39mDatabase We Can Believe In: Stories from the Front Lines and Server Rooms of Barack Obama's Online Presidential Campaign
28mSurviving the Grand National
47mFrom Legacy to High-Load: Evolution of a Web Application
18mHigh-Load Systems: Challenges in Social Network Development
36mTesting Encyclopedias in Production
37mNavigating Managed Databases for Over a Decade as a Non-DBA
56mLarge scale websites performance optimisation tricks
20mWhat I Learned From A Dress, an On-Call Nightmare