来源:http://venublog.com/2008/04/16/notes-from-scaling-mysql-up-or-out/
Here is the list of questions and answers from panelists:
 | 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 databases, 1800 db servers |
2 |
1200 |
805 |
5.0.44 with relay log corruption patch |
Php, python, c++ and erlang |
Fedora / RHEL |
|
Youtube |
I can not say |
3 |
I can not say
|
I can not say
|
5.0.24 |
Python |
SuSE 9 |
No Responses (yet)
Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.