万维网上最大的网站运行什么数据库？ [英] What databases do the World Wide Web's biggest sites run on?

问题描述

这个问题的目的是作为主要网站使用的数据库及其配置的列表，并且将是任何想要扩展他们的网站到Twitter，Facebook甚至谷歌的大小的参考。 p>

请将您的答案保持在最低限度，并确保引用任何来源。

EDIT：

此外，请粗体网站名称和数据库以便于扫描。

解决方案

Facebook.com

• Hive （Hadoop的数据仓库，支持表和称为hiveQL的SQL变体）。用于简单摘要作业，商业智能和机器学习以及许多其他应用程序


• Cassandra （多维，分布式键值存储）。

目前正在使用Hive数据存储在单个群集中运行610（很快将是1000个）Hadoop节点。 Hive和Cassandra都是由Facebook开源的。

Facebook统计：

• 超过2亿活跃用户


• 超过1亿用户每天至少登录Facebook


• 超过3000万用户更新

：





• http://www.dbms2.com/2009/05/11/facebook-hadoop-and-hive/


• < a href =http://www.facebook.com/note.php?note_id=89508453919 =nofollow noreferrer> http://www.facebook.com/note.php?note_id=89508453919


• http://www.facebook.com /press/info.php?statistics


• http： //hadoop.apache.org/hive/


• http://wiki.apache.org/hadoop/Hive/Design


• http://www.facebook.com/note.php?note_id=24413138919





This question is meant to serve as a list of databases and their configurations that the major web sites use and would be a great reference for anyone thinking of scaling their web site to the size of Twitter, Facebook or even Google.

Please keep your answers to a minimum and be sure to cite any sources used.

EDIT:

Also, please bold both the web-site name and the database for easier scanning.

解决方案

Facebook.com

• Hive (Data warehouse for Hadoop, supports tables and a variant of SQL called hiveQL). Used for "simple summarization jobs, business intelligence and machine learning and many other applications"
• Cassandra (Multi-dimensional, distributed key-value store). Currently used for Facebook's private messaging.

Currently running 610 (soon to be 1000) Hadoop nodes in a single cluster with Hive datastore. Both Hive and Cassandra have been open-sourced by Facebook.

Facebook stats:

• More than 200 million active users
• More than 100 million users log on to Facebook at least once each day
• More than 30 million users update their statuses at least once each day
• Average user has 120 friends on the site

Sources:

• http://www.dbms2.com/2009/05/11/facebook-hadoop-and-hive/
• http://www.facebook.com/note.php?note_id=89508453919
• http://www.facebook.com/press/info.php?statistics
• http://hadoop.apache.org/hive/
• http://wiki.apache.org/hadoop/Hive/Design
• http://www.facebook.com/note.php?note_id=24413138919

这篇关于万维网上最大的网站运行什么数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！