MySQL 在国外facebook,flickr等公司内的使用情况
MySQL conference现场提问的一个资料,网上见过很多版本了,这个表格版本看起来最直观
 | 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
say
|
I can not say
|
5.0.24 |
Python |
SuSE 9 |
- 基本上用MySQL 5.0, 操作系统则是Linux的天下,开发语言用php,python,java,c++,另外facebook还用erlang的
- MySQL对DBA的需求较小,程序员就是dba
- facebook平均每个db server有20个数据库
- 前2个公司没多少参考价值(传统行业),youtube 啥也不愿意说, I can not say...
表格原文在:
http://venublog.com/2008/04/16/notes-from-scaling-mysql-up-or-out/