Hello everyone….. This is my first blog post and I don’t know how to write it but still I am trying. So fasten your seat belt and get ready for the roller coaster that I will ride with you all with some of the questions which arises sometimes in our mind.
My today’s question is “What database actually Facebook uses?”
A billion of people are using FACEBOOK. Users are expressing themselves and interacting with their peer and friends through wall posts, uploading their photos, passing information’s about events and other meaningful information and for that reason facebook needs a large scalable database.
I could imagine that is why it is a very popular Google search keyword. 🙂
I have searched a lot on this topic and come out at a conclusion that Facebook use several database techniques. The challenge for Facebook’s engineers has been to keep the site up and running smoothly in spite of handling close to billion active users.
This article takes a look at some of the software and techniques they use to accomplish their mission.
MYSQL:
Facebook primarily uses MySQL for structured data storage such as wall posts, user information, timeline etc. This data is replicated between their various data centers.
MEMCACHED :
It is also important to note that Facebook makes heavy use of Memcached,a memory caching system that is used to speed up dynamic database driven websites by caching data and objects in RAM to reduce reading time.Memcached is Facebook’s primary form of caching and greatly reduces the database load. Having a
caching system allows Facebook to be as fast as it is at recalling your data.
If it doesn’t have to go to the database it will just fetch your data from the cache based on your user ID.
HAYSTACK :
The Photos application is one of Facebook’s most popular features. Up to date, users
have uploaded over 15 billion photos which make Facebook the biggest photo sharing website. For each uploaded photo, Facebook generates and stores four images of different sizes, which translates to a total of 60 billion images and 1.5PB of storage. The current growth rate is 220 million new photos per week, which translates to 25TB of additional storage consumed weekly.
Implements a HTTP based photo server which stores photos in a generic object store called Haystack.
CASSANDRA :
The Apache Cassandra database is the right choice when you need scalability and high availability without compromising performance. Facebook uses it for its Inbox search.
SCRIBE :
Scribe is a flexible logging system that Facebook uses for a multitude of purposes
internally. It’s been built to be able to handle logging at the scale of Facebook, and automatically handles new logging categories as they show up.
VARNISH :
Varnish is an HTTP accelerator which can act as a load balancer and also cache content which can then be served lightning-fast. Facebook uses Varnish to serve photos and profile pictures,handling billions of requests every day.
HIPHOP FOR PHP :
HipHop for PHP is a set of PHP execution engines. HipHop was developed by Facebook and was released as open source in early 2010. To date, Facebook has achieved morethan a 6x reduction in CPU utilization for the site using HipHop as compared with Apache and Zend PHP.Facebook is able to move fast and maintain a high number of engineers who are able to work across the entire codebase.
So, while “What database does Facebook use?” seems like a simple question, you can see that FACEBOOK developers have added a variety of other systems to make it truly web scalable over their 500million users.
Hey mates! I just want to share this site.<br /><br />Join here: https://shorte.st/ref/99cd3d8502<br /><br />This one is a URL shortener.<br />Every URL you shorten, you earn.<br /><br />The minimum payout is 5 dollars which is better than any other URL shortener like linkbucks and adfly.<br /><br />So what are you waiting for? Go here, https://shorte.st/ref/99cd3d8502<br /><br />Connect it with
Nice to know about fb databases.. looking forward for more post from you..
Wow a nice solid research Ankita, this surely is very good start to blogging. Didnt know the half of them. Keep blogging
Its clear & Brief about FB Database
great<br />
it was useful….
good job 🙂
thanks man this helped me alot<br />
nicely done..
what about Google?
very helpful. Thanks bro…
Info is cool thanks !!<br /><br />Haystack software when research is different from the mentioned description
great blog post!
very useful, thanks, <br />what about nosql?<br /> what type nosql are they using??
Cassandra
keep uploading like this.. great work man!
Hey mates! I just want to share this site.<br /><br />Join here: https://shorte.st/ref/99cd3d8502<br /><br />This one is a URL shortener.<br />Every URL you shorten, you earn.<br /><br />The minimum payout is 5 dollars which is better than any other URL shortener like linkbucks and adfly.<br /><br />So what are you waiting for? Go here, https://shorte.st/ref/99cd3d8502<br /><br />Connect it with
Very useful :)<br />
That was a brief and crisp explanation…Keep going…
Nice to know about f.b database…..
Gud Work..
Hi,
It really awesome to share your knowledge, keep it up and keep going! 🙂
Thanks