CockroachDB Adds Hash Sharded Indexes
Written by Kay Ewbank   
Thursday, 09 June 2022

Cockroach DB has been updated with what the developers say is a variety of management, performance, security, and compatibility improvements.

CockroachDB is a distributed SQL database that is cloud native and offers horizontal scalability with no single points of failure.

cockroachdb

The first group of improvements are designed to let users start faster and begin prototyping. There's a new command line interface for CockroachDB Dedicated and CockroachDB Serverless, along with updates to CockroachDB Serverless to make it easier to connect to your app and more extensive monitoring. Support has been added for the Prisma Node.js and TypeScript ORM, as well as for Google Pub/Sub.

Optimization improvements start with a new API for CockroachDB Dedicated and CockroachDB Serverless that can be used to automate and programmatically control the provisioning, scaling, and management of your clusters. Query performance has also received attention, with improvements to index recommendations and support for hash-sharded indexes. These distribute sequential traffic uniformly across ranges, which reduces single-range hot spots and improves write performance on sequentially-keyed indexes, though at a small cost to read performance.

Support has been added for Datadog to provide better monitoring, providing data collection and the use of alerts on CockroachDB metrics.

Scaling has also been improved, with new options to keep data in specific geographic regions. The new super regions can be used to define a set of regions on the database such that any REGIONAL BY TABLE table based in the super region or any REGIONAL BY ROW partition in the super region will have all their replicas in regions that are also within the super region.

Another addition aimed at making sure peak demand is handled well is the ability to identify which data requests should be met first if the servers are overloaded and can't service all the requests.

CockroachDB 22.1 is available now.

cockroachdb

More Information

Cockroachlabs

Related Articles

CockroachDB Strengthens Change Data Capture

CockroachDB 20.2 Adds PostGIS Spatial Data Support

CockroachDB 20.1 Improves App Development

Cockroach Creates Pebble

CockroachCloud Enters Beta

CockroachDB Adds GDPR Compliance

CockroachDB Production Ready

CockroachDB Released

 

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.

Banner


Oracle Code Assist Now In Beta
19/09/2024

Oracle Code Assist is now available in beta. The coding assistant was first announced in May, when Oracle said it would be optimized for Java, SQL, and Oracle Cloud Infrastructure-based applicati [ ... ]



TypeScript 5.6 Tightens Truthy And Nullish Checks
16/09/2024

TypeScript 5.6 has been released. The update has better handling of truthy and nullish checks and new iterator helper methods.


More News

kotlin book

 

Comments




or email your comment to: comments@i-programmer.info

Last Updated ( Thursday, 09 June 2022 )