Will Facebook, Twitter, LinkedIn Stay With MySQL?
littlekorea writes "The world's largest web-scale users of MySQL have committed to one further upgrade to the Oracle-controlled database — but Facebook and Twitter are also eyeing off more open options from MariaDB and cheaper options from the NoSQL community. Who will pay for MySQL enterprise licenses into the future?"
Maybe Postgres lacks discoverability?
NB: The message above might reflect my opinion right now, but not necessarily tomorrow or next year.
"One does not simply export Facebook!"
Invaders must die
One entire Billy Graham at a time?
are you guys still using MySQL?
Do you even lift?
These aren't the 'roids you're looking for.
BetaMax vs VHS. Blu-ray vs HD-DVD.
Obviously it's because the porn industry chose MySQL.
Its web scale!
Who logs in to gdm? Not I, said the duck.
PostgreSQL's biggest disadvantage over MariaDB is that it's not a drop-in replacement for MySQL.
Postgres has a blackhole engine that loses data in unpredictable ways now. But that only emulates parts of MyISAM.
I switched to MariaDB but my database is the size of a microbe so the few quirks were of no difficulty; but there were quirks. MariaDB was not a plug in replacement. I love it and wouldn't go back but it did take a tiny bit of work. So if I had one zillion servers with crazy databases I would be taking my time on that one. I suspect that what you will see is new development experiments depending on MariaDB and slowly increasing the pressure until they just make the switch.
The other question is how many obscure features of MySQL features are they using? (Including custom code)
Facebook uses a NoSQL database (HBase) for their messaging system, and some related tech for data analysis (Hadoop). They also have custom photo serving software (haystack) for their photo storage. The main data (status updates, friends, likes, etc.) is in MySQL with memcache in front of it. There is also a cache layer (varnish) in front of the web servers. They said NoSQL isn't ready and point to the smaller messaging system needing more staff.