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


Introducing Wheelbot
31/07/2022

The Wheelbot is a jumping reaction wheel unicycle that can jump onto its wheels from any initial position. It's fun to watch and has  a GitHub repo detailing how you can to build one using off-th [ ... ]



PyPi Insists On 2FA For Critical Projects
26/07/2022

PyPi, the Python Package Index, which is the official repository of third-party open-source Python projects, has got tough with its requirements for critical projects. The plan is that two-factor auth [ ... ]


More News

pythondata

 



 

Comments




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

Last Updated ( Thursday, 09 June 2022 )