Why does Wikipedia use MySQL as a data store rather than a NoSQL database since it scales and will be economic?

6 years ago
ian $I9xuH7PGU4

https://www.quora.com/Why-does-Wikipedia-use-MySQL-as-a-data-store-rather-than-a-NoSQL-database-since-it-scales-and-will-be-economic/answer/Domas-Mituzas

Billions of views hit the cache layer, not the application - application generates only about 50000 queries a second.

Now, there are two kinds of databases serving the wikis - 'core' - which has all the metadata, and text storage.

There're six shards for core database, split by language (so requests don't really have to hit multiple shards) - and they're all under 500G, and active dataset for each shard fits into 64GB (on some into 32GB) systems and doesn't thrash disks much.

Why does Wikipedia use MySQL as a data store rather than a NoSQL database since it scales and will be economic?

May 23, 2018, 4:43am UTC
https://www.quora.com/Why-does-Wikipedia-use-MySQL-as-a-data-store-rather-than-a-NoSQL-database-since-it-scales-and-will-be-economic/answer/Domas-Mituzas >Billions of views hit the cache layer, not the application - application generates only about 50000 queries a second. >Now, there are two kinds of databases serving the wikis - 'core' - which has all the metadata, and text storage. >There're six shards for core database, split by language (so requests don't really have to hit multiple shards) - and they're all under 500G, and active dataset for each shard fits into 64GB (on some into 32GB) systems and doesn't thrash disks much.