In June, I gave a talk at the dotScale conference in Paris about WordPress.com’s MySQL database architecture and infrastructure. The video is now online:
In June, I gave a talk at the dotScale conference in Paris about WordPress.com’s MySQL database architecture and infrastructure. The video is now online:
Cool
Reblogged this on Elmar Klausmeier's Weblog and commented:
Very interesting talk on the scaling challenge at WordPress.com.
Some key points:
500 million database tables
3 data centers in USA
400.000 shards moved per day
storage on SSD
~10% of total infrastructure costs are related to backups
~500 GB / shard
50 million sites
2.200 servers, and 500 database servers
[…] dotScale 2013 MySQL Talk. […]
Is there any documentation on using hyperDB?
I want to start simple 😉
Reblogged this on Elmar Klausmeier’s Weblog and commented:
Very interesting talk on the scaling challenge at WordPress.com.
Some key points:
500 million database tables
3 data centers in USA
400.000 shards moved per day
storage on SSD
~10% of total infrastructure costs are related to backups
~500 GB / shard
50 million sites
2.200 servers, and 500 database servers
Awesome talk, there’s so much we take for granted when it comes to infrastructure and it’s amazing to see the dedication and ingenuity being put into these scaling solutions.
This gives a lot of background and overview about some challenges happening today…
Leave a Reply