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


Android 15 Developer Preview Updated
25/03/2024

Google has released Android 15 Developer Preview 2 with changes including better handling of automatic language switching and updates for OpenJDK 17.



Couchbase Adds Vector Search
07/03/2024

Couchbase is adding support for vector search across its entire product line including Capella, Enterprise Server, and Mobile. Support has also been added for retrieval-augmented generation (RAG) tech [ ... ]


More News

raspberry pi books

 

Comments




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

Last Updated ( Thursday, 09 June 2022 )