CockroachDB 23.2 Enhances Enterprise Architectures with Improved Postgres Compatibility and Built-in Resilience

The new version provides updates to live migrations and new capabilities including stored procedures and read committed

NEW YORK, Jan. 18, 2024 /PRNewswire/ -- Cockroach Labs, the leading provider of cloud-native distributed SQL databases, today announced the release of CockroachDB 23.2. This latest version introduces several key capabilities that elevate the ability to modernize enterprise architectures, including Stored Procedures, MOLT Live Migration Service (LMS), Physical Cluster Replication (PCR), and Read Committed isolation.

The updates made to CockroachDB address industry trends and challenges faced by enterprises in their journey to modernize their infrastructure. As customer expectations rise and competitive pressures increase, the ability to keep mission-critical systems online becomes crucial. According to Uptime's Annual Outage Analysis, when outages do occur, they are

becoming much more expensive. With more than two-thirds of all outages costing more than $100,000, the business case for resiliency is clear or apparent.

23.2 solves key challenges architects and operators encounter by:

Streamlining application migrations with improved SQL compatibility: In this new release, the company has rebuilt stored procedures from the ground up to be significantly more powerful: PL/pgSQL in CockroachDB takes advantage of the distributed execution engine, so users can process large amounts of transactional data in parallel. Additionally, the company is releasing read committed (in preview) which provides support for read committed, the default isolation level provided by Postgres (including Amazon Aurora), Oracle, SQL Server, etc. This compatibility in transactional isolation levels allows developers to migrate high concurrency Postgres applications by reducing the need to add application level retries that are common with higher isolation levels.

Enabling flexible data movement for real-world migrations: Database migrations are notoriously complex, often compared to heart transplants due to their interconnected role in IT infrastructure. CockroachDB 23.2 addresses this challenge by offering the MOLT (migrate off legacy technology) Live Migration Service, providing flexible data movement options tailored to different applications and business requirements. This tooling helps teams navigate the tradeoff between downtime, latency impact, and data integrity, reducing the risk of costly mistakes during migrations. In this release, CockroachDB supports MySQL, Postgres, and CockroachDB (self-hosted, dedicated, or serverless) as sources.

Improving the resilience of existing infrastructures: Architects and operators who design and manage applications in enterprise environments with two locations face unique challenges in ensuring high resilience. While CockroachDB is designed for resilience across three or more regions, many organizations only have two regions in their environment since previous databases were fundamentally built around a legacy failover strategy. Cockroach Labs has now introduced Physical Cluster Replication for organizations that were built around two datacenters, and don't have access to a third on-prem or cloud region. Physical Cluster Replication functionality allows them to survive full cluster failures with RPO (Recovery Point Objective) and RTO (Recovery Time Objective) measured in seconds rather than minutes.

In addition to product updates, Cockroach Labs continues to accelerate its business with the opening of its India office on the back of strong customer growth, and continued global expansion. New customers acquired in 2023 include Riskified: eCommerce fraud and risk intelligence, Symcor: Canada's largest business solutions provider, Landmark Group: retail and hospitality and more. The company was also recently recognized in the 2023 Gartner® Magic Quadrant™ for Cloud Database Management Systems report for the third year in a row. Only 19 vendors made it onto the Magic Quadrant this year and inclusion is based on a variety of factors including market momentum, buyer interest, and user reviews. 

"Our goal at Cockroach Labs is to continue to empower enterprises with extremely reliable and scalable solutions that address the challenges of modernizing infrastructure while operating within budget and headcount constraints," said Nate Stewart, Chief Product Office at Cockroach Labs. "CockroachDB 23.2 is the next step in that journey, and is a powerful distributed SQL database for enabling organizations to stay ahead in today's competitive landscape."

For more information on CockroachDB 23.2 visit: https://www.cockroachlabs.com/whatsnew/

Gartner, Magic Quadrant for Cloud Database Management Systems, By Adam Ronthal, Rick Greenwald, Xingyu Gu, Ramke Ramakrishnan, Aaron Rosenbaum, Henry Cook, Published 18 December, 2023.

GARTNER is a registered trademark and service mark of Gartner, Inc. and/or its affiliates in the U.S. and internationally, and MAGIC QUADRANT is a registered trademark of Gartner, Inc. and/or its affiliates and are used herein with permission. All rights reserved.

Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner's research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.

About Cockroach Labs:
Cockroach Labs is the creator of CockroachDB, the cloud-native, distributed SQL database designed to enable global businesses to build and operate world-changing applications. CockroachDB is trusted to run mission-critical workloads for some of the world's largest enterprises, including Bose, Comcast, Hard Rock Digital, Fortune 50 financial institutions, as well as category leaders in retail and media.

SOURCE Cockroach Labs