The databases of Web enterprises
Almost no one use Oracle, so what is their better solution?
According to Amazon, customers of AWS report cost savings of 90% by migrating from Oracle to AWS. (Source).
|Percolator for the search engine. Successor of BigTable, another software created by Google.
Spanner. Distributed and replicated in real time NewSQL DB, for GMail and others.
|HBase. Derived from BigTable and is part of Hadoop, a set of tools.
MySQL. For common functions. With TAO overlay for the social graph.
Haystack. For images and other media.
Hive. Adds data analysis to Hadoop.
Schema: Infrastructure of Facebook for its databases. (Source Malte Schwarzkopf).
|Cassandra for statistics and geolocation.
MySQL. A fork of the dbms, for users and tweets. The source code is available on GitHub.
FlockDB. A graph database for social connections. The source code is on GitHub.
HBase and Hadoop. Probably to replace MySQL.
|Yahoo||MySQL customized. The company had a time the size record for SQL tables.
PostgreSQL whose query part has been customized.
|eBay||Hadoop with Kylin, a system of search on mass data.
eBay had also used Oracle.
|Digg||DynamoDB, a NoSQL solution provided by AWS, the host.|
|Skype||PostgreSQL. Used with PHP and other scripting languages.|
|Youtube||MySQL + Speed to scale it on the cloud.|
|Uber||Migrated from PostgreSQL to MySQL (Percona) + Schemaless which turns it into NoSQL.
Uses also Cassandra, Hadoop, MongoDB and Redis under Node.js (source).
This is only a sample of the best known companies. A lot of others use PostgreSQL, MariaDB (replacing MySQL), HBase and Hadoop tools.
While Cassandra was abandoned by Facebook which created this software, it is however used by many other companies whose needs are different.
Only Amazon used Oracle, which it gradually replaced with other databases, partly by Aurora, its own solution. They already made the decision as soon as 2014 and announced on October 15, 2019 that the last Oracle database was permanently deleted.
Larry Ellison, CEO of Oracle, Octobre 26, 2018 said:
Amazon runs their entire business on top of Oracle database. They have been unable to migrate to AWS because it is not good enough.
It does take a lot, a lot of time to migrate a database, but it's not because the new is not powerful enough.
We see that for structured data, enterprises use MariaDB (possibly clustered) and PostgreSQL. But they also use them in combination with other tools for network data.
However, other types of software are more suitable for a variety of web applications: NoSQL tables, documents, graphs, key-value, etc ...
See also ...