http://hi.baidu.com/jabber/blog/item/a633a54b87b351f583025c71.html
mysql 在国外facebook,flickr等公司内的使用情况
2008-04-21 23:03
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
|
Facebook |
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/
|