What database does Twitter use?

Question

Twitter started with MySQL as the primary data store, from a single instance the persistence layer grew to a large number of clusters. Twitter has one of the biggest deployments of MySQL right from its inception. It has MySQL clusters with thousands of nodes serving millions of queries per second.

Which database is used by Instagram?

Instagram mainly uses two backend database systems: PostgreSQL and Cassandra. Both PostgreSQL and Cassandra have mature replication frameworks that work well as a globally consistent data store.

Does Twitter use a graph database?

Twitter stores many graphs of relationships between people: who you're following, who's following you, who you receive phone notifications from, and so on. Some of the features of these graphs have been challenging to store in scalable ways as we've grown.

How does Twitter work database?

When you tweet it's stored in an internal system called T-bird, which is built on top of Gizzard. Secondary indexes are stored in a separate system called T-flock, which is also Gizzard based. Unique IDs for each tweet are generated by Snowflake, which can be more evenly sharded across a cluster.

Does Twitter use Cassandra?

We're using Cassandra in production for a bunch of things at Twitter. A few examples: Our geo team uses it to store and query their database of places of interest. The research team uses it to store the results of data mining done over our entire user base.

Expert · Answer