3 ms·

> fully managed HA cluster This is where Suspension of Disbelief stops for me — I've been taught by years of Jepsen analyses that "HA" really doesn't exist, es

by jwr 1y ago

> fully managed HA cluster This is where Suspension of Disbelief stops for me — I've been taught by years of Jepsen analyses that "HA" really doesn't exist, especially in the SQL database world, and especially if there is a big company behind with lots of big complicated buzzwords. What you usually get is single master replication, and you get to pick up the pieces if the master dies.

mike_hearn 1y ago
Jepsen doesn't work through databases in any kind of order as far as I can tell, and they haven't done an analysis of Oracle or many other popular databases. So I wouldn't take that as a representative sample. RAC clusters are multi-write-master and HA. The drivers know how to fail over between nodes, can continue sessions across a failover and this can work even across major version upgrades. The tech has existed for a long time already. If you're curious you can read about it more in the docs. "Application continuity" i.e. continuing a connection if a node dies without the application noticing: https://docs.oracle.com/en/database/oracle/oracle-database/23/racad/ensuring-application-continuity.html#GUID-C1EF6BDA-5F90-448F-A1E2-DC15AD5CFE75 https://docs.oracle.com/en/database/oracle/oracle-database/2... Fast failover and load balancing for cluster clients (here in the context of Java but it works for other languages too): https://docs.oracle.com/en/database/oracle/oracle-database/23/jjucp/overview-Oracle-RAC-features.html https://docs.oracle.com/en/database/oracle/oracle-database/2... I mean, I understand the skepticism because HN never covers this stuff. It's "enterprise" and not "startup" for whatever reason, unless Google do it. But Oracle has been selling databases into nearly every big company on earth for decades. Do you really think nobody has built an HA and horizontally scalable SQL based database? They have and people have been using it to run 24/7 businesses at scale for a long time.
- jen20 1y ago
  I wonder if the clause in the Oracle license that prohibits publishing benchmarks and other studies could be to blame for Jepsen having not investigated..?

by jwr 1y ago

mike_hearn 1y ago

Jepsen doesn't work through databases in any kind of order as far as I can tell, and they haven't done an analysis of Oracle or many other popular databases. So I wouldn't take that as a representative sample. RAC clusters are multi-write-master and HA. The drivers know how to fail over between nodes, can continue sessions across a failover and this can work even across major version upgrades. The tech has existed for a long time already. If you're curious you can read about it more in the docs. "Application continuity" i.e. continuing a connection if a node dies without the application noticing: https://docs.oracle.com/en/database/oracle/oracle-database/23/racad/ensuring-application-continuity.html#GUID-C1EF6BDA-5F90-448F-A1E2-DC15AD5CFE75 https://docs.oracle.com/en/database/oracle/oracle-database/2... Fast failover and load balancing for cluster clients (here in the context of Java but it works for other languages too): https://docs.oracle.com/en/database/oracle/oracle-database/23/jjucp/overview-Oracle-RAC-features.html https://docs.oracle.com/en/database/oracle/oracle-database/2... I mean, I understand the skepticism because HN never covers this stuff. It's "enterprise" and not "startup" for whatever reason, unless Google do it. But Oracle has been selling databases into nearly every big company on earth for decades. Do you really think nobody has built an HA and horizontally scalable SQL based database? They have and people have been using it to run 24/7 businesses at scale for a long time.

jen20 1y ago
I wonder if the clause in the Oracle license that prohibits publishing benchmarks and other studies could be to blame for Jepsen having not investigated..?