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


30 Years of Boston Dynamics
13/11/2022

To mark 30 years since it was founded by Marc Raibert in 1992 Boston Dynamics has posted a video that celebrates its 30 years of innovation, exploration, and collaboration. As well as showcasing today [ ... ]



Google And NORAD Start Countdown to Christmas
01/12/2022

It's December 1st - the day on which both Google and NORAD take the wraps off their Santa Trackers that have been in hibernation since the start of the year. Both have a new mini game for kids each da [ ... ]


More News

picobook

 



 

Comments




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

Last Updated ( Thursday, 09 June 2022 )