Celebrating a decade of distributed SQL innovations

• Hot spot observability in external data monitoring tools like Datadog help improve workload stability and performance.

• Workload-level index recommendations give high quality index recommendations to holistically optimize performance.

• Finer-grained SQL observability by application and database name for simpler troubleshooting.

Vector indexing. In 24.2 we released pgvector support for the vector datatype, which was a good way for customers to begin experimenting with advanced LLM applications. When we introduced pgvector support, we did so for vectors with thousands of dimensions. Now customers are moving their testing along to where performance is important.

To support performant search and discovery we are now introducing vector indexing [link to docs] into Preview based on a protocol we’re calling Cockroach-SPANN (or C-SPANN). C-SPANN is based on Microsoft’s SPANN and SPFRESH research papers which, along with RaBitQ, deliver an indexing method that is small, fully distributed, and easy to update without degrading index quality. We’re very excited about this release as it directly addresses scalability concerns of vector applications for customers with support for indexing billions of vectors.

Learn more

A CDC message format akin to Debezium goes into Preview and gives customers more flexibility in how data in CockroachDB is shared. With this release migrations to CockroachDB for Debezium customers will be simplified because we will now provide a richer message body to Debezium. Customers that don’t use Debezium will still get access to the richer message body to enhance enterprise integration of CockroachDB with custom applications. At the same time, more capable message headers will enable better message routing and traceability.

Learn more

With row-level security released as GA, customers now have better tenant isolation to protect their customer information within a single table without relying upon application level constraints. In the past we’ve provided robust mechanisms for managing roles and privileges to restrict access to specific tables and now we’re extending that to rows within a table.

Configurable cipher suites are released into GA to allow customers to select a subset of our supported cipher suites when configuring TLS and is a feature that was requested by many customers, especially in financial services.

 New license management features enable self-hosted customers to manage their CockroachDB license keys in the console UI to track keys and better manage license expirations.

Learn more

Logical data replication (LDR), introduced as Preview in 24.3 is now available in GA. 

LDR continuously replicates tables between an active source CockroachDB cluster to an active destination CockroachDB cluster. Both source and destination can receive application reads and writes, and participate in bidirectional LDR replication for eventual consistency in the replicating tables.

The active-active setup between clusters can provide protection against cluster, datacenter, or region failure while still achieving single-region low latency reads and writes in the individual CockroachDB clusters. Each cluster in an LDR job still benefits individually from multi-active availability with CockroachDB's built-in Raft replication providing data consistency across nodes, zones, and regions.

Learn more