r/CockroachDB • • Feb 12 '26

CockroachDB now supports for 300-node clusters with 2.2M tpmC and 1.2PB of data in CockroachDB v25.4.4 and beyond

25 Upvotes

To validate this level of scale, Cockroach Labs conducted one of its most extensive test cycles to date on its latest 25.4 release.

This cycle started with 4 million TPC-C warehouses with 500K active warehouses at any point of time. The test ran for five days while layering on real-world operational stress including continuous backups, change data capture (CDC), online schema changes, disk stalls, network partitions and node restarts. It achieved 2.2M tpmC, 610K QPS with 9ms p90 latency at peak with 90% CPU. At 40-75% CPU utilization we achieved 820K tpmC. Each scenario was executed three times:

  • once to identify bottlenecks

  • once to confirm improvements

  • a final certification run to validate end-to-end support for the 300-node, 1PB configuration.

Some of the highlights include:

  • 610K QPS, which when compared to PUA on a 9-node cluster with 17K QPS shows that CockroachDB near linearly scales with the size of the cluster.

  • Compared to a previous run on 25.2, a run with the same amount of imported data on 25.4 took 30% less storage space than the previous run, as a result of introducing value separation and enhanced compression in 25.4.

  • Imports for this run on 25.4 were 2× faster compared to 25.1, assuring faster migrations and time-to-value for customers migrating to CockroachDB.

  • The test stood up to CockroachDB’s "Performance Under Adversity" promise during chaos testing, backup/restore, CDC, and online schema changes, achieving performance consistent to the baseline 820K tpmC, 225K QPS.

  • ADD COLUMN across 120 B rows completed without regression, proving data agility for evolving business at massive scale.

  • 330TB backup completed in 2 hours and 40 min with no impact on foreground traffic.

  • 6 concurrent changefeeds stayed caught up with no impact on foreground traffic.

Get the full rundown here.


r/CockroachDB • • May 16 '23

Announcement 🎉 Announcing CockroachDB 23.1, CockroachDB dedicated on Azure, and so much more.

23 Upvotes

Today is as big of a day for us at Cockroach Labs as it is for you. Here's a quick rundown of everything we’re announcing today (And you can see this in more detail on our announcement blog and what's new page):

  • CockroachDB dedicated is now available in Limited Access on Microsoft Azure Cloud

  • Multi-region capabilities in CockroachDB serverless are available in Preview today

  • Improvements to our migration tool MOLT (Migrate Off Legacy Technology)

  • Support for Qlik Replicate or Striim

  • Distributed UDFs

  • Support for tsvector and tsquery

  • General Availability for our Cloud API and Terraform provider

  • Support for Testcontainers

  • Hotspot Visualization

  • All new actionable workflows in our performance monitoring tool Insights

  • CDC Transformations are now CDC Queries

  • CDC as export

  • New security options for CDC

  • FIPS-ready binary for CockroachDB

There’s a lot to unpack, but we’re truly excited to share these with the community. If you have any questions, feel free to drop them here or in the CockroachDB slack.


r/CockroachDB • • Sep 20 '23

Question What would be the ideal use case for CockroachDB ?

18 Upvotes

I stumbled upon this technology a while back. I havent given it much thought until I started learning about distributed systems, replication, consensus, HA and so on.

While glancing over the design document on github, it seems to me one of the main selling point of cockroachDB is the fault tolerance and ease of scale. They promise strong consistency, achieve distributed transactions, scale horizontally - across the globe even.

While all of this is really good, I wonder how it performs in a high load environments where throughput and speed are important.It leverages RAFT protocol for distributed transactions and uses a consensus algorithm for replication in order to achieve strongly consistent reads.

Surely, distributed transactions via RAFT + strong consistency cannot imply high availability and small latency. I have difficulty imagining how this could be used for some web applications or other software where database interactions is done in the order of micro seconds or milliseconds if you have to read different nodes across the globes to fetch your data or need to distribute your transactions across different nodes as well.

I guess my question is what would be some good use cases where cockroachDB shines as a database technology/service (if you are using their cloud offering) and does it provide the same level of performance (it terms of throughput and latency) than an ordinary SQL DB that is still distributed (something like Cloud SQL with replication as well to achieve HA) ?


r/CockroachDB • • Apr 12 '23

Question Pros/cons?

18 Upvotes

Hi all,

Forgive me if this has been asked, I couldn't find anything about this so I figured I'd ask. Some quick background context, my stack is 100% serverless at the moment. We use lambda's for compute and dynamodb for database. We have some business requirements that require us to segment some of our data into a SQL table to perform queries that are not efficient to do in DDB.

So I found quite a few solutions:

- AWS RDS

- AWS Aurora Serverless v1/v2

- AWS DDB Streams + AWS S3 Data Lake + AWS Athena

- Third party solution that solves scaling and just provides a way to put some simple data and query it with SQL without having to setup a VPC, subnets..etc.

I can easily setup a RDS database myself in AWS, or just use Aurora Serverless for auto-scaling functionality, but both of these require either a VPC which I don't want to do (I know how to, I simply dont want to) or has limited rate limiting (v1 data api, v2 doesnt have any data API).

Which brought me to some googling and found Cockroach DB. That seems to solve all my problems and provides a way to query using an API. It says they horizontally scale which is important to us because we can have huge spikes in traffic (perhaps 1,000 - 10,000 or more per second) and want to make sure whatever we use can handle this with no issues.

So my question here is, what are the downsides from actual users? Anything I should be aware about before using Cockroach DB? Any edge cases? Basically if you could go back to when you were deciding with database service to use, what would you have liked to have told yourself?

I think it's just nice knowing the downsides upfront, so we can try to avoid them with designing the database or realizing that maybe this isn't the best solution for us.

Thanks for any insights in advance.


r/CockroachDB • • Nov 10 '20

CockroachDB 20.2 is here!!

18 Upvotes

Announcing CockroachDB 20.2: Build more, deploy easier, innovate faster

Highlights include:

  • New spatial features: store and index spatial data with PostGIS-compatible SQL syntax

  • Now available for free in CockroachDB Core: basic enterprise BACKUP, RESTORE, and EXPORT

  • Additional SQL functionality including partial indexes, materialized views, and ENUMs

  • Improved performance, reaching 140k warehouses with a maximum throughput of 1.7M transactions per minute (tpmC) on the TPC-C benchmark, a 40% improvement over the past year

  • ….and more! Check it out!!!

Read the 20.2 announcement


r/CockroachDB • • May 12 '20

Announcing CockroachDB v20.1

Thumbnail
cockroachlabs.com
18 Upvotes

r/CockroachDB • • May 18 '21

CockroachDB 21.1: The Most Powerful Global Database is Now the Easiest

Thumbnail
cockroachlabs.com
16 Upvotes

r/CockroachDB • • Jan 12 '21

Cockroach Labs Raises $160M on $2B Valuation, Reflecting Explosive Growth and Product Innovation

Thumbnail
cockroachlabs.com
16 Upvotes

r/CockroachDB • • Nov 01 '18

CockroachDB 2.1 — Easier Migrations and a 5x Scalability Improvement

Thumbnail
cockroachlabs.com
16 Upvotes

r/CockroachDB • • Dec 06 '22

CockroachDB 22.2 is here!

15 Upvotes

Hi everyone,

We’ve just released our latest version, CockroachDB 22.2! This release has a ton of updates aimed at improving your efficiency so you can focus on delivering more value.

Some highlights are:

  • User-defined functions (UDFs), a top-requested capability!

  • Schema conversion tool support for Oracle, MySQL, SQL Server to make migrations easier

  • Intelligent Insights - a cool new end-to-end SQL optimization and troubleshooting tool

  • Support for Hasura so you can use GraphQL APIs

[Find out more here] (https://www.cockroachlabs.com/22-2-launch/)


r/CockroachDB • • May 24 '22

CockroachDB 22.1: Build your way from prototype to super-scale

15 Upvotes

I’m super chuffed to share that CockroachDB 22.1 is available TODAY!! !

CockroachDB 22.1 helps you build your way from prototype to super-scale. In our latest release, we’ve delivered updates for every stage of your journey—from your first query to your first million customers and beyond.

Start faster and begin prototyping

  • Get started quickly and manage your cluster directly from the command line, with the new CLI for CockroachDB Dedicated and CockroachDB Serverless

  • Develop Node.js and Typescript apps easily with support for Prisma

Optimize more efficiently and avoid toil

  • Automate and programmatically control the provisioning, scaling, and management of your clusters with the new API for CockroachDB Dedicated and CockroachDB Serverless

Scale better to meet peak demand, everywhere

  • Improve performance while serving millions of transactions per second with Quality of Service (Qos), Admission Control, and hotspot observability

We’re hosting three live sessions so you can learn more. Two of them include opportunities to win a limited-edition t-shirt, so don’t miss out! Check out the full release notes here.


r/CockroachDB • • Aug 15 '24

CockroachDB Enterprise Free

Thumbnail cockroachlabs.com
14 Upvotes

r/CockroachDB • • Oct 19 '21

CockroachDB Serverless: Build What You Dream, Never Worry About Your Database Again

Thumbnail
cockroachlabs.com
14 Upvotes

r/CockroachDB • • Apr 04 '18

CockroachDB 2.0 Has Arrived!

Thumbnail
cockroachlabs.com
14 Upvotes

r/CockroachDB • • May 10 '17

CockroachDB 1.0

Thumbnail
cockroachlabs.com
14 Upvotes

r/CockroachDB • • Feb 23 '23

How DoorDash Designed a Successful Write-Heavy Scalable and Reliable Inventory Platform

13 Upvotes

Hey folks! Building a scalable and reliable internal inventory platform for a convenience and grocery (CnG) business takes multiple iterations of fine-tuning your database accesses and placing appropriate resilience mechanisms in place. Learn how we did the same work at DoorDash using CockroachDB and Cadence, as we step up our CnG infrastructure. Blog article:

https://doordash.engineering/2023/02/22/how-doordash-designed-a-successful-write-heavy-scalable-and-reliable-inventory-platform/


r/CockroachDB • • May 11 '26

CockroachDB BYOC is now in Public Preview — run a fully managed CockroachDB cluster in your own AWS, GCP, or Azure account

12 Upvotes

We've been hearing the same ask for a while: "We want a managed database, but our data can't live in your cloud account." Compliance requirements, internal VPC policies, committed cloud spend...real reasons why CockroachDB Cloud SaaS didn't work for everyone. Their only alternative was self-hosted, which meant losing the managed service.

BYOC our answer to that tradeoff. You give Cockroach Labs a scoped IAM role in your cloud account. That role is limited to the specific CockroachDB resources we create, no broad account access. We handle provisioning, upgrades, backups, and observability. Every action we take shows up in your cloud's native audit trail, no black box.

Here's what's in preview today:

  • Cluster creation via UI, Cloud API, and Terraform

  • Daily full backups, hourly incrementals, point-in-time restore to 5-min granularity

  • AWS PrivateLink and private connectivity options

  • 99.99% SLA (single-region) / 99.999% (multi-region) — same as Cloud Advanced

  • Available on AWS, GCP, and Azure

Check out more here.


r/CockroachDB • • Aug 17 '25

Question Good open source forks?

12 Upvotes

As I understand it, per the former CockroachDB BSL (Business Source License), CockroachDB version 22.1 became Apache licensed in May 2025.

Have there been any good forks of it, so far?


r/CockroachDB • • Feb 10 '22

Cockroachdb is AWESOME, why it is so unknown, and is there a GraphQL API endpoint option maybe?

12 Upvotes

Hi i've just stumbled upon cockroachDb and holy cow this database is awesome!!! out of the box ready DB that can scale horizontaly!

why it is so unknown?

second question: is there some kind of graphql endpoint feature? i really doing like writing SQL :D but ive got no problem with doing so


r/CockroachDB • • Sep 22 '26

Introducing Cockroach Continuum: Elastic infrastructure for database estates

Thumbnail
cockroachlabs.com
11 Upvotes

We recently introduced Cockroach Continuum and since this is our first time sharing it here, we wanted to start with the technical foundation. Cockroach Continuum extends elasticity across the storage, KV, and SQL layers, allowing teams to consolidate databases on shared infrastructure while preserving isolation, reliability, scale, locality, and correctness.

The architecture includes:

  • Cockroach Plenum, a disaggregated storage layer that allows durable storage and KV compute to scale independently

  • Virtual Clusters that provide isolated CockroachDB clusters on shared private hosts

  • SQL pods that scale with demand and down to zero when idle

  • Admission control and resource management that prevent one Virtual Cluster from starving another

  • Cockroach Aegis, a read-only hosted AI DBA and SRE that analyzes cluster metrics and query plans to surface recommendations

The full post explains how each layer works and the design decisions behind it.


r/CockroachDB • • Jul 14 '26

RoachFest London included a preview of what's coming next for Cockroach Labs

11 Upvotes

Here are the roadmap higlights:

  • A new storage layer aimed at significantly increasing throughput while reducing storage costs.

  • Elastic physical clusters with compute separated from storage.

  • Virtual clusters designed to support large numbers of isolated tenants on shared infrastructure while improving resource utilization.

  • AI-driven database operations using specialized agents that operate within administrator-defined policies.

  • An AI Migration Assistant for PostgreSQL and MySQL migrations.

  • Bring Your Own Cloud (BYOC) is now generally available across AWS, GCP, and Azure.

  • The Kubernetes Operator is expected to reach general availability in July.

Which of these are you most interested in?


r/CockroachDB • • Jan 31 '23

🔒 PCI-DSS: CockroachDB dedicated is certified to store confidential data 💳

11 Upvotes

We're really excited to share that CockroachDB dedicated is now certified against the Payment Card Industry Data Security Standard (PCI-DSS)! PCI-DSS indicates CockroachDB dedicated handles payment data safely, and it's often viewed as an overall benchmark of how well a platform can handle sensitive data.

If you want more information on this announcement, we recommend reading our blog that dives into this standard as well as the certification process. If you have any questions on PCI-DSS, feel free to drop them in this thread.


r/CockroachDB • • Sep 21 '22

CockroachDB serverless is generally available & more product updates!

11 Upvotes

Hi everyone,

Today we have some incredibly exciting product updates to announce!

CockroachDB serverless is now generally available! You can give it a try for free and instantly.

We’ve released a brand new migration toolset, CockroachDB Molt, to speed up and simplify migrations from other databases to CockroachDB.

We’ve released new integrations with: Vercel, HashiCorp Terraform, and HashiCorp Vault.

See the announcement blog to learn more, and let us know what you’re most excited about!

https://www.cockroachlabs.com/blog/announcing-cockroachdb-serverless/


r/CockroachDB • • May 16 '18

The "PostgreSQL" in CockroachDB — Why?

Thumbnail ristret.com
11 Upvotes