Cockroach Labs is releasing CockroachDB 24.3, improving resilience and performance, while adding enterprise capabilities such as support of Microsoft’s Active Directory and database triggers.According to the company, CockroachDB 24.3 also delivers a solution that enables customers with two data centers to experience the resilience benefits of distributed SQL that were formerly limited to three data center implementations.
This release improves physical cluster replication and introduces two key features for enhancing database resiliency:
- WAL (Write Ahead Log) failover
- Logical data replication (LDR)
WAL failover transparently handles transient disk stalls, common in cloud environments, without disruption in access to data ranges homed on the disk. WAL failover uses a secondary disk to preserve the availability of writes when the primary disk is stalled. WAL failover is Generally Available (GA) for both self-hosted and cloud offerings.
Released as preview for self-hosted implementations of CockroachDB, LDR delivers a solution for two-data-center high availability. Multi-region replication can be used to tolerate a single node, availability zone, or region/data-center outage. LDR meets customers where they are by providing cross-cluster active-active replication. With LDR, clusters are configured in an active-active setup and both can receive reads and writes concurrently, allowing customers to survive a region failure while providing low latency reads and writes.
Physical cluster replication has been enhanced to support workload isolation, which enables read workflows to take advantage of the secondary cluster to scale read performance. As a result, users can SELECT from the secondary cluster for non-critical operations such as analytics queries.
Physical cluster replication is generally available in self-hosted CockroachDB, and will be available as preview on the Advanced cloud plan in January. SELECT from standby is in preview in 24.3.
Microsoft’s Active Directory is quite popular for authentication and authorization to control access to resources. Cockroach Labs customers can now integrate CockroachDB users with existing AD infrastructure to simplify access management. This feature is in preview.
Many applications across key verticals like financial services, retail, and technology rely upon database triggers to enforce business rules and maintain data integrity. Triggers are essential for applications that require real-time responses to data changes, such as updating related tables or logging changes for auditing. The introduction of triggers in CockroachDB enables customers to expand the types of workloads they can migrate to
CockroachDB, helping to simplify their data infrastructure.
For example, now customers can leverage established, complex workflows on their CockroachDB clusters, enabling the migration of legacy applications to CockroachDB without rewriting application logic. Triggers are released in preview.
The Metrics and SQL activity pages are also easier to navigate, and the performance of database pages for larger clusters is improved.
With a new structured log framework for job state changes, you can now emit events for each job state change, capture them in your data observability platform such as Datadog, and use this data for easier debugging.
For more information about this news, visit www.cockroachlabs.com.