With new capabilities for spatial data, a CockroachDB for Kubernetes option, and the addition of enterprise Backup and Restore functionality to the free community option, it makes developers more productive and brings mission-critical features to organizations of all sizes.
Spatial data types and the associated libraries have been added to the open-source and freely available version of CockroachDB. This is the first cloud native distributed database to include these capabilities and it will empower net new workloads for IoT, transportation, and environmental applications. The combination of a geo-distributed database with geo-spatial capabilities also opens the door for more innovation. The syntax is compatible with PostGIS and is easy to use.
With this release, the company also introduces CockroachDB on Kubernetes, which packages the cloud-native database with a custom Operator, optimized for orchestrated deployments. It a database architected to deliver on the core distributed principles of Kubernetes. It is a natural fit for Kubernetes because of its distributed, shared-nothing architecture. Simply attach storage however you like and CockroachDB handles scale, resilience and distribution of data. There is no need for additional, complex tasks for management of shards or to deal with the inevitable pod failures. Additionally, the Kubernetes Operator that is included with CockroachDB will simplify deployment configuration and enable no-downtime rolling upgrades in production.
CockroachDB 20.2 also strengthens CockroachDB Core, the freely available, open-source version of the database. Some of the basic distributed Backup and Restore capabilities that had previously been reserved for the enterprise version are available in CockroachDB Core, and all other improvements mentioned are also available in Core. Coming in response to user requests, these updates let community users solidify their DR plans and build performant production applications for free.
Finally, CockroachDB’s performance continues to improve with each release. In 20.2, it has extended its TPC-C Benchmark performance up to 140k warehouses with a maximum throughput of 1.7 million 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 benchmark for OLTP workloads.
“We’re committed to making CockroachDB the database of choice for developers everywhere,” said Spencer Kimball, CEO and co-founder. “We’ve listened to our users, and we’ve made improvements to all areas of the database, including a new package, CockroachDB on Kubernetes, to ease deployments in cloud-native environments. No matter what the use case, we want to equip every developer with the database they need to build and create their business’s next billion-$ idea.“
CockroachDB is a flexible, scalable, and resilient foundation for the modern tech stack and gives all developers the freedom to build breakthrough cloud applications without getting mired in the operational overhead of managing the database.
Hundreds of organizations, including Comcast, Doordash, eBay, Nubank, JPMorganChase, and SpaceX, use CockroachDB as the backbone for transactional applications in the cloud. Architected from the ground up for the cloud, it builds on the developer-friendly standards of traditional relational databases PostgreSQL, and transforms these concepts for the modern age with elastic scale, indestructible resilience, and low-latency distributed performance. The updates in Version 20.2 strengthen CockroachDB’s position as the right general-purpose database for the latest wave of data-intensive applications.
“LaunchDarkly empowers development and business teams to control their software. Our customers depend on our services to be available, fast, and correct from anywhere on the planet,” said Justin Caballero, senior distributed systems engineer, LaunchDarkly. “We chose CockroachDB for our next gen database because of its consistency and flexibility, and the control it affords over our data.“
“Our mission is to transform virtual classrooms into interactive learning experiences — which is now more important than ever before,” said Jordan Thoms, CTO, Kami. “We are using CockroachDB as our system of record and are extremely pleased with its resiliency and performance as we continue to add over one million users per week. We feel confident in our ability to scale with CockroachDB and serve our global audience.“
Additional updates in CockroachDB 20.2 include:
The company built an open-source storage engine from scratch, called Pebble. In 20.2, it has replaced CockroachDB’s previous storage engine, resulting in performance and stability improvements and giving the firm more control over future database enhancements.
CockroachDB’s monitoring UI displays key metrics that are critical for troubleshooting. 20.2 adds 2 new pages to help developers introspect and understand query performance: a SQL transactions page and database sessions page.
Added SQL functionality
CockroachDB speaks standard SQL, letting developers access data in a familiar way. 20.2 introduces more SQL functionality, including Partial Indexes, Materialized Views, Enumerated Types (ENUMs), and User-Defined Schemas.
Stronger support for Java and Ruby
It supports many data access tools, letting developers use their preferred programming language. 20.2 adds support for the Java tools Hibernate, MyBatis, Spring Data JPA, and Spring Data JDBC; and the Ruby tool Active Record.
CockroachDB is already low-touch and requires minimal operations, and 20.2 lets teams save more time with scheduled automated backups, faster data imports, and more options for bulk data imports.
20.2 adds enhanced enterprise-grade security with improvements to logging, Role Based Access Control (RBAC), and certificate management.
About Cockroach Labs
It is the company behind CockroachDB, the cloud-native, distributed SQL database that provides next-level consistency, resilience, data locality, and massive scale to modern cloud applications. Companies like Comcast, Lush, and Bose are building their cloud data architectures on this product. Tne company was founded by a team of engineers dedicated to building cutting edge systems infrastructure, and has investments from Benchmark, G/V, Index Ventures, and Redpoint.