Facebook Mysql Cluster

Naresh Kumar is a software engineer and enthusiastic blogger, passionate and interested in programming and new things. 　　Recently, Naresh wrote a blog, the open source world's two most common database MySQL and PostgreSQL characteristics of the detailed analysis and comparison. If you're going to choose a free, open source database for your project, you may be hesitant between MySQL and PostgreSQL. MySQL and PostgreSQL are free, open source, powerful, and feature-rich databases ...

As the most popular open source database, MySQL is widely used in Web applications and other small and medium-sized projects. However, in many large IT companies, MySQL has gradually deviated from the original open source version after being highly optimized and customized, more like a branch, such as the Webscalesql of Facebook, which was not long ago open source. 　　Recently, Mr. Xiong has published a blog post, from the perspective of large-scale web site architecture development of the changes in MySQL application, here for you to share. This article mainly describes the different and ...

In recent years, with the continuous innovation and development of the Internet industry, batch after group of websites or be eliminated or stand out, for those successful websites, most of them already exist nearly 10 or more than 10 years, in such a long period of development, in addition to the business facing the challenges, Technically, it's also a lot of challenges. The following selected Alexa rankings of the previous site (ranking up to April 21, 2012, by analyzing how they are technically coping with the challenges of business development process, to a deeper understanding of the development of the Internet industry in recent years. ...

Facebook, the world's leading social networking site, has more than 300 million active users, with about 30 million users updating their status at least once a month, with users uploading more than 1 billion photos and 10 million videos a week, and sharing 1 billion weekly content, including logs, links, news, tweets, etc. So the amount of data that Facebook needs to store and process is huge, adding 4TB of compressed data every day, scanning 135TB size data, performing hive tasks on the cluster more than 7,500 times per hour, and 80,000 times a week.

Facebook, a world-renowned social networking site, has more than 300 million active users, of which about 30 million users update their status at least once a day; users upload a total of more than 1 billion photos and 10 million videos a month; Week to share 1 billion content, including journals, links, news, Weibo and so on. Therefore, the amount of data that Facebook needs to store and process is huge. Everyday, 4TB of compressed data is added, 135TB of data is scanned, and more than 7,500 Hive tasks are performed on the cluster.

Based on my current readings and conversations, I understand today's http://www.aliyun.com/zixun/aggregation/1560.html"> The structure of Facebook is as follows: The web front end is written by PHP. Facebook's HipHop will Converting PHP to C ++ and compiling with g ++ will provide high performance for templates and Weblog business layers ... Business logic exists as Service ...

A while ago, Facebook added graph search for post searches. After that, Facebook generated about 1 billion post,post indexes a day, and the amount of data was 700TB. These amazing numbers are no doubt challenging to index and build real-time query systems for these posts. So how does Facebook deal with this challenge? The following is mainly explained: Data collection Facebook's underlying data structure is mainly to meet the needs of fast iterative network services ...

As a software developer or DBA, one of the essential tasks is to deal with databases, such as MS SQL Server, MySQL, Oracle, PostgreSQL, MongoDB, and so on. As we all know, MySQL is currently the most widely used and the best free open source database, in addition, there are some you do not know or useless but excellent open source database, such as PostgreSQL, MongoDB, HBase, Cassandra, Couchba ...

Sometimes the best way to learn about a software product is to see how it is used. It can solve what problems and how these solutions apply to large application architectures that can tell you a lot. Because HBase has a lot of open product deployments, we can do just that. 　　This section describes in detail some of the scenarios in which people successfully use HBase. Note: Do not limit yourself to the belief that hbase can only solve these usage scenarios. It is a nascent technology, and innovation based on the use of the scene is driving the development of the system. If you have new ideas, think you can benefit from HBAs ...

With the rise of internet web2.0 websites, the relational database has become a very hot new field, the development of the non relational database products is very rapid. 　　But the traditional relational database in dealing with web2.0 website, especially the super large-scale and high concurrent SNS type web2.0 pure dynamic website already appeared to be powerless, has exposed many insurmountable problems, for example: 1, high configured--to the database higher concurrent reads and writes the demand WEB2.0 website to be based on user personalized information to generate real-time dynamic ...