| 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.
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.
More InformationRelated ArticlesCockroachDB Strengthens Change Data Capture CockroachDB 20.2 Adds PostGIS Spatial Data Support CockroachDB 20.1 Improves App Development CockroachDB Adds GDPR Compliance
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. 
Comments
or email your comment to: comments@i-programmer.info |
|||
| Last Updated ( Thursday, 09 June 2022 ) |
