The new version from Cockroach Labs is coming to make things easier for developers. CockroachDB makes it easy to deploy and manage distributed databases. It provides a new SQL syntax for controlling data latency and availability for multi-region installations that can be input on the command line.
CockroachDB 21.1 is the culmination of CEO Spencer Kimball’s commitment made during a talk about the company’s $160 million E fundraising round. But what is the significance of the promise? With several masters, distributed transaction databases are difficult. Even in the cloud, there are numerous ways for relational transaction databases, although many, like Amazon Aurora and Microsoft Azure SQL Database Hyperscale, rely on a single write master.
What’s getting in the way of global reads and writes? The fact that sustaining ACID necessitates special precautions. Will data be separated into regions with local data intact if a database is spread over two or three areas throughout the world, or will there be duplicate data records from all over the world? Both strategies are valid for different reasons.
If the bulk of write and changes are segmented by region, that data should be sectioned and placed in its region to improve efficiency. Data should be replicated to such global areas if the read and write patterns are global.
Developers may use CockroachDB to create SQL statements that specify which clusters and regions the database should operate in. The developer will then issue another SQL statement, specifying which areas the database should operate in and where the data should be allotted geographically.
The developer will next describe “survivability,” which relates to allocating catastrophe recovery areas and clusters. Developers will not need to learn any special configuration statements as a result of these functionalities. It also facilitates debugging and query optimization by generating EXPLAIN statements from its query optimizer.
Cockroach Labs, the company behind CockroachDB, has been on a fundraising spree for the past several years. The company disclosed a $160 million Series E funding round today, valued at a whopping $2 billion. The funding comes only eight months after the company raised $86.6 million in a Series D investment.
The new capabilities in CockroachDB 21.1 are designed to alleviate developers’ concerns about the complications. While this is only a portion of the process, the long-awaited visual no-code/low-code tools will finish it.