How Quora scaled MySQL

Quora had to scale its MySQL database to handle over 100k queries per second due to rapid user growth. They employed strategies like sharding, optimizing read operations, and optimizing table space. Sharding involved splitting large tables into partitions to balance load and manage high traffic. They further enhanced performance by rewriting complex queries and improving cache efficiency. For better space management, Quora switched from InnoDB to RocksDB to leverage variable page sizes and data compression.