What database actually FACEBOOK uses?

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

LG F60 detailed specifications

GENERAL

Release date	September 2014
Form factor	Touchscreen
Dimensions (mm)	127.50 x 67.90 x 10.60
Battery capacity (mAh)	2100
Removable battery	Yes
Colours	Black, White
SAR value	NA

DISPLAY

Screen size (inches)	4.50
Touchscreen	Yes
Touchscreen type	Capacitive
Resolution	480x800 pixels
Pixels per inch (PPI)	207

HARDWARE

Processor	1.2GHz  quad-core
Processor make	Qualcomm
RAM	1GB
Internal storage	4GB
Expandable storage	Yes
Expandable storage type	microSD

CAMERA

Rear camera	5-megapixel
Flash	Yes
Front camera	1.3-megapixel

SOFTWARE

Operating System	Android 4.4.2
Java support	Yes
Browser supports Flash	No

CONNECTIVITY

Wi-Fi	Yes
Wi-Fi standards supported	NA
GPS	Yes
Bluetooth	Yes
NFC	No
Infrared	No
DLNA	No
Wi-Fi Direct	No
MHL Out	No
HDMI	No
Headphones	3.5mm
FM	Yes
USB	Micro-USB
Charging via Micro-USB	Yes
Proprietary charging connector	No
Proprietary data connector	No
Number of SIMs	1
SIM Type	Regular
GSM/ CDMA	GSM
3G	Yes

SENSORS

Compass/ Magnetometer	No
Proximity sensor	Yes
Accelerometer	Yes
Ambient light sensor	Yes
Gyroscope	Yes
Barometer	No
Temperature sensor	No

Panasonic's 'connected camera' pairs an Android smartphone with a one-inch sensor and f/2.8 lens

Compact, point-and-shoot cameras are dying, simply because people would rather use smartphones and tablets to snap their dinner and instantly share them to Instagram. Unfortunately, that's a segment of the market that Panasonic abandoned (at least in Europe) back in 2013. That left the company without a convincing rival to the Lumia 1020 and Samsung's various phone / camera hybrids. That's why the company has now launched the DMC-CM1, a "connected camera" (i.e. a smartphone with a proper lens) that's capable of taking 20-megapixel stills and record 4K video thanks to a one-inch MOS sensor.

Comparison: Xiaomi RedMi 1S Vs Android One IndiaToday.in New Delhi, September 16, 2014 | UPDATED 12:51 IST The Indian budget smartphone market is heating up day by day with ultra affordable, feature rich smartphones flooding a highly lucrative market. Among devices that have created the most splash are Xiaomi's Mi3 and RedMi 1S, which have been overwhelmingly scarce, and proportionally high in demand. Yesterday, Google announced the first set of Android One devices and the Micromax Canvas A1 was quick to sell out on Amazon India. We're rounding up the two most talked about device ranges and comparing what's on offer. RedMi 1S vs Android One...here we go! Computing power The new Android One devices for now sport a 1.3Ghz quad core Mediatek processor with 1GB RAM while the RedMi 1S comes with a slightly bumped 1.6GHz quad core Qualcomm processor also coupled with 1GB RAM. Both devices are dual-SIM equipped. Operating system Xiaomi provides users with Android 4.3 Jelly Bean with its own MIUI layer on top. Google on the other hand has pushed the latest 4.4 KitKat flavor running on stock to provide a no-frills, high performance experience. Display Micromax, Spice and Karbonn have offered 4.5 inch IPS screens in their devices with a resolution of 480 x 854 pixels with no additional screen protection while Xiaomi's offering comes with 4.7 inch 1280 x720P, scratch resistant Dragontail panel. Camera Android One devices sport a 5MP primary camera, with full HD video recording which is offset by the 8MP Exmor R CMOS shooter on the RedMi 1S. While the RedMi has the edge down back, Android One phones trump the RedMi's 1.6MP front camera with their 2MP shooter. Storage Xiaomi has provided 8GB of inbuilt storage in the RedMi 1S which can be taken to 64GB via microSD. In comparison the Android One devices come with 4GB internal storage and 32GB microSD support. Battery and Pricing The Android One devices we saw yesterday come equipped with a 1700mAh battery and can be purchased in the Rs. 6k-7k range. RedMi 1S packs a 2000mAh battery and can be had (if one manages to) for Rs. 5,999.

Google Offers Early Stage Startups $100,000 In Cloud Platform Credits For 1 Year

If you are an early stage startup, Google wants to give you $100,000 in Cloud Platform credits for one year so you can host your applications on its servers (and not on AWS or Azure). This offer is part of Google’s Cloud Platform for Startups initiative, a new program the company’s senior vice president for its technical infrastructure Urs Hölzle announced at the Google for Entrepreneurs Global Partner Summit today.

To be eligible for this program, startups must be less than five years old and have less than $500,000 in annual revenue. They must also be part of one of 50 accelerator programs, incubators and VC funds around the world that Google has already partnered with (Google plans to add more partners over time and those organizations that aren’t part of this first batch can contact Google to join this program).

Among these partners are the likes of Y Combinator, 500 Startups, SV Angel, Techstars, Code for America, Chicago’s 1871, and (unsurprisingly) Google’s own Google Ventures. Google is also working with Gaza Sky Geeks, the first accelerator program in Gaza, and many other organizations around the world.

“This offer supports our core Google Cloud Platform philosophy: we want developers to focus on code; not worry about managing infrastructure,” writes Google’s Julie Pearl today. “Starting today, startups can take advantage of this offer and begin using the same infrastructure platform we use at Google.”

In addition to the Cloud Platform credits, startups will also be able to schedule office hours for 1:1 technical architecture reviews and they will get access to 24/7 phone support.

Just like its main competitors, Google has always offered a (limited) free tier for startups that wanted to get started on its platform. Since late 2013, AWS has also been offering its “Portfolio Package” to accelerators, incubators and funds through AWS Activate — a program that is quite similar to Google’s new initiative. Amazon offers startups in this program up to $15,000 in AWS credits. WithBizSpark, Microsoft has also long offered a comparable program for early stage startups, though its benefits also often include. Compared to Google, however, the $150 monthly Azure credits startups get through Google’s program looks a bit small.

In some way, though, Google’s $100,000 credit for one year is a bit of a marketing gimmick. Most startups won’t need anywhere close to this many resources to get going unless they either become extremely popular (Google loves to note that Snapchat uses its services) or plan to use Google’s servers for very heavy computations (I assume Google would ban a startup that would use these credits for Bitcoin mining…).

Google is clearly interested in taking some mind share from the likes of AWS, which for most startups is still the go-to cloud service. Chances are, this program will help it to get more of these companies on board and once they are on Google’s servers, they will likely stay there as they grow (and get to the point where they have to start paying their bills).