Facebook Mysql

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

Despite being caught by Oracle, the controversy on MySQL never stopped; today, MySQL is still the most popular open source database on the market. Simple, free, extensible, relatively mature and so has always been the attraction of MySQL, but it is like a rabbit in a tortoise and hare race, because of its own advantages, to slacken, slowing down their own pace, so that each competitor Have the opportunity to catch up, these killer features are no longer attractive (or even reduced to the disadvantaged). Although PostgreSQL has always been the direct competitor of MySQL, ...

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

MySQL is an open source relational database management system, the developer for the Swedish MySQL AB company, is now part of sun company. Oracle announced the acquisition of Sun Company in 2009, so MySQL may become Oracle's products. Because of its high performance, low cost and good reliability, MySQL has become the most popular open source database and is widely used in small and medium Web sites on the Internet. As MySQL matures, it is increasingly used for more large-scale ...

June 23 News, no longer questioned: Facebook has become the world's largest open source company. Previously, Facebook had led a trend through data centers, databases and various open-source designs. This week, the company launched two more Open-source projects: The Wedge network switch and the Fboss operating system it uses. 　　This puts Facebook on the top of the open source. But does this also ring the bell of the Open-source company? After all, companies like Facebook, Google (Weibo) and LinkedIn have launched a lot of ...

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

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.

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