Case Study: TweetMeme (serving Twitter users) achieves real-time scalability — indexing 50,000+ links/hour and 600M retweet buttons/month with MySQL Enterprise

TweetMeme Manages Explosive Growth with MySQL Enterprise

TweetMeme, launched by Nick Halstead’s fav.or.it, provides real-time ranking and deep-link search of popular links shared on Twitter and a widely used “retweet” button for publishers. Rapid user growth in 2009 created an explosive increase in traffic and real-time indexing demands, forcing TweetMeme to solve major scalability, availability and performance challenges without letting operational costs spiral.

TweetMeme upgraded from MySQL Community Server to a MySQL Enterprise subscription on Sun Fire x86 hardware, using replication, memcached and MySQL Proxy plus MySQL Enterprise Monitor and Query Analyzer to optimize performance and manage traffic. The new stack enabled them to index 50,000+ links per hour and serve more than 600 million retweet buttons per month, giving the team the capacity and confidence to handle continued growth while reducing time and costs.

Twitter