Linked by David Adams on Wed 14th Dec 2011 16:01 UTC, submitted by fran
Internet & Networking PHP's popularity and simplicity made it easy for the company's developers to quickly build new features. But PHP's (lack of) performance makes scaling Facebook's site to handle hundreds of billions of page views a month problematic, so Facebook has made big investments in making it leaner and faster. The latest product of those efforts is the HipHop VM (HHVM), a PHP virtual machine that significantly boosts performance of dynamic pages . And Facebook is sharing it with the world as open-source.
Thread beginning with comment 500131
To view parent comment, click here.
To read all comments associated with this story, please click here.
RE[3]: Database
by lucas_maximus on Wed 14th Dec 2011 23:38 UTC in reply to "RE[2]: Database"
lucas_maximus
Member since:
2009-08-18

There are things like mem-cache and other technologies ... but Facebook is built on MySQL which is alright for running a blog or a small web store ... but once it gets serious you need a proper RDBMS.

Reply Parent Score: 1

RE[4]: Database
by Bill Shooter of Bul on Thu 15th Dec 2011 14:20 in reply to "RE[3]: Database"
Bill Shooter of Bul Member since:
2006-07-14

http://gigaom.com/cloud/facebook-shares-some-secrets-on-making-mysq...

I'm too lazy at the moment to track down all of the reasons why using a "proper RDBMS" is a bad idea for facebook but that gives you some hints anyways: licensing costs, speed of support issue resolution and lack of proof that it could actually handle the load.

proper RDBMS == true scotsman. By the time you got something that worked as well as what they use now, it would be almost exactly what they use now, but cost a but load more and have an "oracle" sticker on it.

Reply Parent Score: 2

RE[5]: Database
by lucas_maximus on Thu 15th Dec 2011 18:20 in reply to "RE[4]: Database"
lucas_maximus Member since:
2009-08-18

Fair enough on the true Scotsman reference, they have what they have now and they done a lot of stuff to fix it.

Mark Zuckerburg even said he wished he built it in something else to begin with.

But MySQL just sucks, Postgres is just as free and is miles better IMO. Postgres has features such as GIS entities built into it, that MSSQL only got in the 2008 version.

http://www.pgcon.org/2010/schedule/attachments/141_PostgreSQL-and-N... (warning PDF).

MySQL and NoSQL databases aren't really much better than running say Postgres with certain options turned off which IMHO is a decent ORDMS and is in the same league as Oracle and MS-SQL and whatever IBM push (DB2?).

TBH I am not a hardcore database guy but I know enough tricks to optimize queries when needed. But when I am using MySQL you just get that feeling it is a bit shitty.

Reply Parent Score: 3