How Twitter Stores 250 Million Tweets a Day Using MySQL
Monday, December 19, 2011 at 9:05AM
Todd Hoff in Strategy, Twitter

Jeremy Cole, a DBA Team Lead/Database Architect at Twitter, gave a really good talk at the O'Reilly MySQL conference: Big and Small Data at @Twitter, where the topic was thinking of Twitter from the data perspective.

One of the interesting stories he told was of the transition from Twitter's old way of storing tweets using temporal sharding, to a more distributed approach using a new tweet store called T-bird, which is built on top of Gizzard, which is built using MySQL.

Twitter's original tweet store:

Twitter's new tweet store:

MySQL isn't used for everything:

Some other ideas:

Great job Jeremy!

Related Articles

Article originally appeared on (
See website for complete article licensing information.