MySQL: The Twelve Days of Scaleout
Working to make clear that it is a database for the big boys, MySQL is running a series of posts on their web site called The Twelve Days of Scale Out. Each day features a different customer who has taken MySQL to the moon. Today's feature (Day 5) covers Wikipedia.
The page quotes Redmonk analyst Steven O'Grady:
"The notion persists within many traditional enterprises that once you reach a certain level of application importance, it is necessary to transition to big, expensive boxes running big, expensive databases. However, free-thinking members of their IT staffs are beginning to ask the question: 'What can we learn from Google, Yahoo, and Wikipedia on how to scale for high growth?' "
Here are a few stats from the article. Wikipedia has:
- More than 154 million annual visitors
- More than 5 million articles
- More than 290,000 contributors
- Nearly half a million edits each day
- 25,000 SQL queries/second
- 20 servers, with MySQL replication used to add more as needed
I was actually a bit surprised by the low server count. I would have expected more, given Wikipedia's traffic.
Disclosure: I am on the board of MySQL and O'Reilly produces the MySQL User Conference for MySQL AB.
tags: open source
| comments: 3
| Sphere It
submit:
0 TrackBacks
TrackBack URL for this entry: http://blogs.oreilly.com/cgi-bin/mt/mt-t.cgi/5589
Comments: 3
I assume that's 20 database servers, right?
AFAIK Wikipedia caches the pages ordinary users see and only renders those pages that are edited or customized to minimize database load. That's why they only need 20 servers and it kind of destroys what mySQL wants to demonstrate...
Hi!
Wikipedia is a dual MySQL/Memcached setup. It is very common among sites at this point to use MySQL for persistence, but use Memcached for serving the actual content.
Cheers,
-Brian
Post A Comment:
STAY CONNECTED
RECENT COMMENTS
- Brian Aker on MySQL: The Twelve Days of Scaleout: Hi! Wikipedia is a dua...
- Tobi on MySQL: The Twelve Days of Scaleout: I assume that's 20 data...
- Tobi on MySQL: The Twelve Days of Scaleout: I assume that's 20 data...
Tobi [06.15.07 09:43 AM]
I assume that's 20 database servers, right?
AFAIK Wikipedia caches the pages ordinary users see and only renders those pages that are edited or customized to minimize database load. That's why they only need 20 servers and it kind of destroys what mySQL wants to demonstrate...