> With roughly 2.85 billion monthly active users as of the first quarter of 2021
> 1.8 billion of Facebook users (66%) use the app on a daily basis
Say 1 database could store the data + handle the reads/writes for 100,000 users (literally just guessing)
2.85 billion monthly active users / 100k users per server = 28,500 servers/"instances" for MySQL
That's not even counting Kubernetes pods (if they use that) running Docker containers (if they use that) for their API / content serving.
I wonder what their average transactions per second looks like.
For Twitter:
> Every second, on average, around 6,000 tweets are tweeted on Twitter, which corresponds to over 350,000 tweets sent per minute, 500 million tweets per day and around 200 billion tweets per year.
> As of the first quarter of 2019, Twitter averaged 330 million monthly active users
Twitter has 11.5% the MAU of Facebook (330m of 2.85b)? I don't know if 1 tweet can be extrapolated to 1 Facebook like/comment/share/post but if it did, 6k tweets per sec * 8.7x the user base = 52.2k writes per second?
Found this:
> Facebook now has about 30,000 servers supporting its operations, hosts 80 billion photos, and serves up more than 600,000 photos to its users every second.
https://engineering.fb.com/2019/06/06/data-center-engineerin...
Also, that "30,000 servers" number is off by... a lot. No comment on by how many orders of magnitude. :-)
Facebook has purchased 6GW of renewable energy to power its datacenters [1]. Its datacenters have a PUE of about 1.06 last they published (they unfortunately seem to have taken their dashboards down) so that's about 5.6GW of electricity actually powering real load. Some of that will power the networking fabric so we could conservatively estimate 5GW of compute load. The OCP Yosemite v3 platform power budget is a max of 1.5kW [2]. Also conservatively, let's assume a real average 1kW load. I'll leave the division as an exercise for the reader to estimate the number of servers they operate.
1 https://www.google.com/amp/s/www.euronews.com/green/amp/2021...
2 https://www.opencompute.org/documents/ocp-yosemite-v3-platfo...
5000000 kilowatts / 1kW per machine = 5,000,000 machines internationally?
I have to imagine they use other databases as well, right? We're much smaller than Facebook and we have some Mongo and some Postgres and a mix of Go/Rust/Scala/node.js.
I wonder how many boxes they have dedicated to be being MySQL machines. I wonder how big their tables are and how many writes per second they see during the day.