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:
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
Is there any documentation on using hyperDB?
I want to start simple ;)
[…] dotScale 2013 MySQL Talk. […]
Fill in your details below or click an icon to log in:
You are commenting using your WordPress.com account. ( Log Out / Change )
You are commenting using your Twitter account. ( Log Out / Change )
You are commenting using your Facebook account. ( Log Out / Change )
You are commenting using your Google+ account. ( Log Out / Change )
Connecting to %s
Notify me of follow-up comments via email.
Notify me of new posts via email.
Enter your email address to follow this blog and receive notifications of new posts by email.
Join 851 other followers
Get every new post delivered to your Inbox.