"getting foolproof HA straight out of the box"
This is a minimal requirement for any modern database.
No, HA straight out of the box is a minimal requirement. Foolproof HA is not a requirement, since neither MySQL or Postgres offer "easy" HA setup.
Galera cluster works "out of the box", that might be the closest SQL competitor in that regard.
What is HA?
High Availability
Here we see a cornerstone of HA: redundancy
Re:CockroachDB 1.0
by jackweirdy on Wednesday May 10, 2017 @12:42PM
(#14309579)
High Availability
Re:CockroachDB 1.0
by sixdimensional on Wednesday May 10, 2017 @12:44PM
(#14309600)
High availability :)
Note that I haven't actually ran CockroachDB yet, so I can't confirm if it really delivers on that promise, but I'm hopeful.