CockroachDB

CockroachDB is a source-available distributed SQL database management system developed by Cockroach Labs.

The relational functionality is built on top of a distributed, transactional, consistent key-value store that can survive a variety of different underlying infrastructure failures, and is wire-compatible with PostgreSQL which means users can take advantage of a wide range of drivers and tools from the extensive PostgreSQL ecosystem. A CockroachDB cluster consists of a number of nodes that can be spread across failure domains such as data centres or public cloud regions. A cluster can be scaled both horizontally (by adding nodes) and vertically (by increasing the resources allocated to the existing nodes). It can provide high levels of resilience and availability and can be run in a variety of environments such as bare metal, VMs, containers and Kubernetes, both in private data centers and in the cloud. CockroachDB gets its name from cockroaches, as they are known for being disaster-resistant.

History

Cockroach Labs was founded in 2015 by ex-Google employees Spencer Kimball, Peter Mattis, and Ben Darnell. Kimball and Mattis had been key members of the Google File System team, while Darnell was a key member of the Google Reader team.

While at Google, all three had used Google-owned DBMS’s Bigtable and its successor, Spanner. After leaving Google, they wanted to design and build something similar. Spencer Kimball wrote the first iteration of the design in January 2014, and began the open-source project on GitHub in February 2014, allowing outside access and contributions.

Development on GitHub attracted substantial contributions, which earned the project the ''Open Source Rookie of the Year'' award by Black Duck Software.

The co-founders supported the project with conferences, networking, meet-ups, and fund-raising financial rounds.

In June 2019, Cockroach Labs announced that CockroachDB would change its license from the free software license Apache License 2.0 to its source-available license, known as the Business Source License (BuSL), which forbids “offer nga commercial version of CockroachDB as a service without buying a license,” while remaining free of charge for community use.

Features

CockroachDB stores copies of data in multiple locations to deliver quick access.

It is described as a scalable, consistently-replicated, transactional data store. A single instance can scale from a single laptop to thousands of servers.

CockroachDB is designed to run in the cloud and has a high fault tolerance. According to popular news outlets, it is described as “almost impossible” to take down.

CockroachDB has a consistency model that is designed to match as closely as possible to the capabilities of Google Spanner, but without a dependence on specialized hardware for time synchronization. "No stale reads" is the simplest way to describe this consistency model which has deliberately made the trade-off of having non-linearizable transaction histories. Transactions containing overlapping keys are guaranteed to have external consistency. And so, in practice, systems relying on CockroachDB are very unlikely to reproduce consistency issues because nodes with high variations in clock skew can be removed from clusters, applications can rely on external consistency provided by overlapping keys and writing to the same range, and writes propagate changes to followers' timestamp caches.

See also

* Comparison of relational database management systems
* List of tech companies in the New York metropolitan area
* YugabyteDB
* TiDB

References

External links

* {{Official website, https://www.cockroachlabs.com/

Cloud databases
Distributed computing
NewSQL
Distributed data stores
Software using the Business Source License