Skip to main content

Cockroach Labs Live: What’s New in CockroachDB 19.2

The release of CockroachDB 19.2 includes many exciting new features that make CockroachDB faster and easier to work with, including the following: Reduced latency in both multi- and single-region deployments We struggled to find an atomic commit protocol that enabled speedy (and ACID compliant) distributed transactions, so we built our own. It’s called Parallel Commits, and it halves the latency of all distributed transactions by reducing the rounds of consensus required for a transaction from 2 to 1. It brings the speed of distributed transactions that much closer to the theoretical minimum: the sum of all read latencies plus one round of consensus latency. While its primary use case is for speeding up globally distributed, multi-region deployments, it also improves secondary indexes tremendously in single region deployments. 19.2 also enables vectorized execution by default, which improves the performance of some analytical queries by up to 20x. Improved reliability and ease-of-use for distributed clusters In 19.2, you can control the exact locations to which certain records are backed up. This can reduce cloud storage data transfer costs by keeping data within specific cloud regions and can help users comply with data domiciling requirements like GDPR. There are also a number of new features within both the enterprise and OSS versions of the product that ease the complexity of configuring a geo-distributed database. Zone configurations, for example, are now much easier for users to set up. Zone configurations make distributed SQL more accessible by defining where data lives as well as where lease preferences are for any given subset of data (down to the table and row level). We’ve also introduced improvements to partitioning tables, so you can easily view partitions you’ve created on tables, indexes, or even the entire database. To see the complete list of features in this release, you can reference our release notes. We’re also hosting a 19.2 technical demo on November 21 to introduce more features of the release and answer your questions live. And if you have any questions, please join in the conversation over at our new Slack channel. --------------------------------------------------------------------------------------------------------------------------- If you're interested in learning more about Cockroach Labs or if you'd like to work at Cockroach Labs you can find the appropriate link below: Careers: CockroachCloud: CockroachDB: Blog: Docs: Cockroach University: Category --------------------------------------------------------------------------------------------------------------------------- Careers: CockroachCloud: CockroachDB: Blog: Docs: Community Slack: