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:
dotScale 2013 MySQL Talk
Comments
7 responses to “dotScale 2013 MySQL Talk”
-
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…
Barry on WordPress 
Leave a comment