I've been using CRDB 2.0 for a toy project for a few weeks now, today I notice 2.1 was available so I started playing with some of their new features, I ran a SQL query with correlated sub-queries and then the server crashed. It's the first time I see a crash, so I rushed to the GitHub report to report the bug and to my surprise a GitHub issue was already created for the crash[0], it included the stack trace and an anonymized version of my SQL query that caused the crash.<p>This really demonstrates they really care about the stability of their product, one more reason to keep recommending CockroachDB.<p>[0] <a href="https://github.com/cockroachdb/cockroach/issues/32048" rel="nofollow">https://github.com/cockroachdb/cockroach/issues/32048</a>
So what's the price? For Spanner, which is perhaps their closest competitor, it takes a few seconds to find at least the list price, before discounts and such.
CockroachDB is looking more and more like a viable replacement for MySQL (now that they have importing mysqldump in beta)<p>However key management in clusters is an absolute nightmare. They need to look at Docker Swarm for how to build a usable "join" mechanism. Until then, the majority of folks just use --insecure in production.
I'm never sure what is better - a service that is 99% reliable and you're used to failing over to a backup system because it happens a few times a year. Or a system that is 99.99% reliable and you're <i></i><i></i>ed when it goes down.<p>Is there a name for that dilemma and a preferred option?<p>I like the idea of super reilable services, but I'm also comforted by old fashioned databases I know, and have dealt with lots of live problems.
I asked previously when a CockroachDB post was on here, but didn't really get an answer to it.<p>Is anyone running this in prod at a significant scale and able to comment on reliability and performance?<p>I absolutely love CockroachDB in my toy projects, but am not yet feeling comfortable to commit to using it in prod.
<i>"available at launch on both AWS and GCP"</i><p>Curious if there was some technical barrier on Azure, or if it's perhaps coming later.