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...