Music catalogue site rebuilt after September crash wiped out its database
A music catalogue site went offline in September when its database stopped responding, and the old server's data could not be recovered. Restarting services offered only brief relief, and the site had no logging of its own, which made diagnosis harder. The root cause was a query that randomly sorted an entire table of around 400,000 rows for every song page view, overwhelming the server. The rebuild fixed the query, added database limits on connections and statement runtime, and kept the existing URLs so search engine rankings were preserved. Caching was added only after the underlying query was repaired.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)
Log in to join the discussion and vote.
Log in