Blog

Home / Blog

CockroachDB 20.2 features and benefits

William Tsu
Data Analyst
Experienced data analyst working with data visualization, cloud computing and ETL solutions.
March 29, 2021


CockroachDB 20.2, the latest release of the cloud-native initiates a Kubernetes operator, spatial data, a new storage engine and SQL enhancements. CockroachDB 20.2 also fortify CockroachDB Core, the freely available and open-source version of the database. Pebble is the default storage engine in CockroachDB 20.2, with the option to enable RocksDB if required. In addition to the enterprise Backup and Restore functionality to the free community option, it brings mission-crucial attributes to organizations of all sizes. CockroachDB 20.2 passed TPC-C with 140k warehouses and a maximum throughput of 1.7M transactions per minute (tmpC), representing a 40% performance improvement over the past year.

The updates in Version 20.2 expand CockroachDB's advocate to more workloads and strengthen CockroachDB's position as the right general-purpose database for the latest wave of data-intensive applications providing access to more developers making it even more productive. With this release, the squad extend to improve the security and conduct competence of the database, along with significant upgradations to the overall performance of CockroachDB. In 20.2, CockroachDB has extended its TPCockroachDB 20.2, the latest release of the cloud-native initiates a Kubernetes operator, spatial data, a new storage engine and SQL enhancements. CockroachDB 20.2 also fortify CockroachDB Core, the freely available and open-source version of the database. Pebble is the default storage engine in CockroachDB 20.2, with the option to enable RocksDB if required. In addition to the enterprise Backup and Restore functionality to the free community option, it brings mission-crucial attributes to organizations of all sizes. CockroachDB 20.2 passed TPC-C with 140k warehouses and a maximum throughput of 1.7M transactions per minute (tmpC), representing a 40% performance improvement over the past year. C-C Benchmark performance up to 140k warehouses with a maximum throughput of 1.7M transactions per minute (tpmC). This represents a 40% improvement over the past year. The TPC-C Benchmark simulates an e-commerce or retail environment and is the most mature industry performance benchmark for OLTP workloads. Most of these new capabilities are available in the free version of the database, CockroachDB Core. With this launch, Cockroach Labs also mention CockroachDB on Kubernetes, which packages the cloud-native database with a custom Operator, optimized for orchestrated deployments.

Additional updates in CockroachDB 20.2

Security improvements

CockroachDB 20.2 put in better enterprise-grade protection with upgrades to logging, Role Based Access Control (RBAC), and certificate management.

Added SQL functionality

20.2 raise more SQL performance, adding Partial Indexes, Materialized Views, Enumerated Types (ENUMs), and User-Defined Schemas. CockroachDB suggests standard SQL, allowing initiating access data in an intimate method.

New storage engine

Cockroach Labs developed a modish, open-source storage engine from scratch, called Pebble. In 20.2, Pebble has replaced CockroachDB's former storage engine, ensuing in performance and stability improvements and giving Cockroach Labs more control over future database improvements.

Stronger support for Java and Ruby

CockroachDB assist many current data access tools, helping planners use their preferred programming language. 20.2 gives support for the Java tools Hibernate, MyBatis, Spring Data JPA, and Spring Data JDBC; and the Ruby tool Active Record.

Management improvements

CockroachDB is already low-touch and requires minimal operations, and 20.2 lets teams save even more time with scheduled automated backups, faster data imports, and more options for bulk data imports.

Easier debugging

CockroachDB's monitoring UI displays key metrics that are critical for troubleshooting. 20.2 adds two new pages to assist developers introspect and apprehend query performance: a SQL transactions page and database sessions page.

CockroachDB 20.2 two new pages

CockroachDB 20.2 adds two new pages to help developers introspect and understand query performance:

Sessions Page

The Sessions page of the DB Console provides details of all open sessions in the cluster. See live database sessions, and cancel them easily from the DB Console. For a given session, you can see whether there's a live transaction, which statements are currently running, and how long sessions have been running.

Transactions Page

The transactions page help to identify frequently retried or high latency transactions. See historical SQL transactions and the statements that comprise them, so you can better understand application performance. This is in addition to the existing statements page, which lets you troubleshoot individual statements.

Additional SQL functionality in CockroachDB 20.2

CockroachDB aims standard SQL syntax, so that the database can be used as next generation relational store. It is also wire compatible with PostgreSQL . In 20.2, the SQL is enhanced by adding:

Partial Indexes

The index is only the variant of rows needed for fast reads. Accurate indexing lessen the amount of data stored by indexes and therefore the performance reflect on writes to data that does not need to be indexed.

Materialized Views

Decrease costs for frequently-run queries by caching query results in-memory and only updating when needed.

User-Defined Schemas

This update makes CockroachDB more confidential for developers, more compatible with PostgreSQL applications and tools, and more flexible in its support for different data isolation patterns such as microservices. The composition of data hierarchy with schemas, which are regularly used in relational databases including PostgreSQL.

Improved performance of Foreign Keys

The 20.2 performance improvements in foreign keys will let more customers use them as a crucial component of relational databases. Foreign keys protect data integrity by creating references between two tables to ensure the entry into one table is a valid entry into the other.

Enumerated types (ENUMs)

Inputs can be constricted to an expound set of values like a drop-down list, with this prevalent data type.

Spatial data in a distributed database

This is the first cloud-native SQL database to include spatial data types and associated libraries and build this functionality from the ground up for a distributed environment. The combination of a distributed database with spatial capabilities opens the door for even more innovation and will empower new workloads for Internet of Things (IoT), transportation, and environmental applications.

CockroachDB users can now effortlessly scale spatial data and have the confidence it will survive outages. The data has been locked away in brittle legacy or separate specialized databases, making it difficult for developers to support large datasets in the cloud. With CockroachDB 20.2, Cockroach Labs gives spatial data the same first-class treatment as other data types, making it easier to develop applications that use it

Benefits with CockroachDB 20.2

CockroachDB

CockroachDB 20.2 can store and index spatial data using PostGIS-compatible SQL syntax. It save time and improve security with new and updated management and security features. This work more efficiently with easier debugging, added SQL functionality, and improve support for Java and Ruby. Helps to deploy and manage cloud-native stack with greater ease, using new CockroachDB on Kubernetes offering, which packages CockroachDB with an OperatorUse core Backup and Restore capabilities for free, community option, CockroachDB Core.

Stronger security and compliance in CockroachDB 20.2

CockroachDB's security and assent meet enterprise requirements and data privacy regulations with the launch of CockroachDB 20.2.

Improved database performance in CockroachDB 20.2

TPC-C: CockroachDB passes 140,000 warehouses at 1.7M transactions / minute: TPC-C is the industry standard transactional database benchmark, simulating an e-commerce environment. CockroachDB 20.2 passed TPC-C with a maximum volume of 140k warehouses (previously reported 100K)and a maximum throughput of 1.7M transactions per minute (tmpC), which represents a 40% performance improvement over the past year.

TPC-H: CockroachDB decreased query latencies on 20 of 22 queries, also ran TPC-H, which extends the benchmarking work with complex analytic queries. While CockroachDB is primarily a transaction-oriented database, it can also perform complex joins and aggregations that are best measured through a benchmark like TPC-H. On the TPC-H benchmark, there was a decrease in query latency for 20 out of the 22 queries with query 9 latency improving by 80x.

Better support for Java and Ruby in CockroachDB 20.2

Peculiarly, for 20.2 there was an improved support for Java by adding better compatibility with Hibernate, MyBatis, and Spring Data JDBC; and Ruby by adding compatibility with Active Record. It also has out an adaptor for the Go data access layer upper/db. CockroachDB hold up an assortment of immense data access tools, including ORMs, making it easier to develop in preferred programming language.

Deploy easier with CockroachDB 20.2

20.2 introduces updates to let more seamlessly deploy and manage CockroachDB-both with an Enterprise license and for free. The database is more efficient and will never slow down.

Deploy easier with CockroachDB 20.2

20.2 introduces updates to let more seamlessly deploy and manage CockroachDB-both with an Enterprise license and for free. The database is more efficient and will never slow down.

More granular Role Based Access Control (RBAC)

20.2 propose meaning finer-grained permissions for database users and a list of new privileges and role options for CockroachDB's RBAC.

PII-redacted log files

This helps to maintain clandestine and satisfy more closely with GDPR and other regulations. It protect the sensitive data by redacting PII and other confidential information from logs.

Certificate Revocation

With this update, CockroachDB now pillars Online Certificate Status Protocol (OCSP) before its expiration date, helping improve security in case a certificate is compromised

Innovate Faster with CockroachDB 20.2

CockroachDB 20.2, with the creative update opens up a world of possibilities where the database automatically handles all rote operations, scale, and resilience. It works, and help to focus on energy and output on developing, creating, and innovating. All that means about CockroachDB 20.2 is the database for modern cloud applications which is a very flexible platform.

Conclusion

Thus, CockroachDB, the scale-out SQL Database built for survival rolls out its version 20.2 with these features & benefits we were discussing. Since it is designed as well as developed on top of transactional & consistent key-value store, it comes with a tremendous ability to withstand any datacentre failures. The two new pages sessions & transactions page make CockroachDB more streamlined & easy to work with. An inspiration evoked by a faster innovation forms the crux behind this version: CockroachDB 20.2.