How much power is behind the net’s top sites?
At the recent MySQL Conference & Expo there was a very interesting panel called “Scaling MySQL - Up or Out?” where people from some of the internet’s top sites gave quite a good insight into their setup of MySQL and sometimes also some nice tidbits about their storage and web server setup. Sheeri Cabral made a video that is really worth watching and that I’ve uploaded to Google Video. (The original can be found here.)
The raw numbers are below the fold and courtesy of Keith Murphy, Venu Anuganti and Ronald Bradford.
The sites’ and their Alexa rank (in parentheses):
(1317) Monty Taylor - MySQL
(905) Matt Ingenthron - Sun
(39) John Allspaw - Flickr
(13) Frank mash - Fotolog
(9) Domas Mituzas - Wikipedia
(6) Jeff Rothschild - Facebook
(2) Paul Tuckfield - YouTube
| How many servers | Number of DBAs | How many web servers | Number of caching servers | Version of MySQL | Language, platform | Operating System | |
| MySQL |
1 M, 3 S |
1/10 |
2 |
2 |
5.1.23 |
Perl,php and bash |
Linux fedora |
| Sun |
2 clustered, 2 individual |
1.5 |
160+ |
8 |
5.0.21 |
Lots of stuff (java mostly) |
Open Solaris |
| Flickr |
166 |
At present 0 |
244 |
14 |
5.0.51 |
Php and some Java |
Linux |
| Fotolog |
140 databases on 37 instances |
10 instances a DBA |
70 |
40 ( 2 on each, 80 total) |
4.11 and 4.4 |
Php, 90% Java |
Solaris 10 |
| Wikipedia |
20 |
None, but everybody is kind of a DBA |
70+200 |
40 ( 2 on each, 80 total) |
 |
Php, c++, python |
Fedora / Ubuntu |
|
30000 (1800 db servers) |
2 |
1200 |
805 |
5.0.44 with relay log corruption patch |
Php, python, c++ and enlang |
Fedora / RHEL |
|
| Youtube |
I can’t say |
3 |
I can’t say |
I can’t say |
5.0.24 |
python |
SuSE 9 |
April 21st, 2008 at 3:40 pm
[...] also worth noting the relative Alexa ranks of the reps (thanks to Mike). In this day and age, an Alexa number may not mean too much any more but once upon a time it was [...]