Why CockroachDB?

CockroachDB is a distributed SQL database built on a transactional and strongly-consistent key-value store. It scales horizontally; survives disk, machine, rack, and even datacenter failures with minimal latency disruption and no manual intervention; supports strongly-consistent ACID transactions; and provides a familiar SQL API for structuring, manipulating, and querying data.

CockroachDB is inspired by Google's Spanner and F1 technologies, and the source code is freely available.

Why use CockroachDB?

There are many reasons to use CockroachDB, including:

• Resiliency
• Scalability
• Strong consistency
• Geo-partioning and multi-region features
• PostgreSQL-compatibility

Resiliency

One of the key attributes of CockroachDB is its inherent distributed nature. Data is automatically replicated across multiple nodes for high availability and failover protection, ensuring your data is always accessible. Even during instances of hardware failure or maintenance, the system remains resilient and operational.

For more information, refer to Fault Tolerance & Recovery.

Scalability

CockroachDB supports seamless and efficient horizontal scalability. As your data and transaction volumes increase, you can add more nodes to the cluster to manage this growth, all without a decline in system performance.

For more information, refer to Replication & Rebalancing.

Strong consistency

CockroachDB supports ACID transactions. This means that every copy of data across all nodes accurately reflects the same state, thereby ensuring data integrity throughout your system.

For more information, refer to Transactions.

Geo-partitioning and multi-region features

CockroachDB's geo-partitioning functionality lets you tie data to specific geographical locations, which is beneficial for many reasons, including:

• Reduced Latency: By tying data to a specific location closer to where it is accessed from, latency can be significantly reduced, leading to improved application performance.
• Regulatory Compliance: Geo-partitioning aids in meeting data sovereignty requirements, as it allows storing and processing of data within defined geographic boundaries.
• Surviving Outages: Geo-partitioning ensures that your database can survive availability zone or regional outages, providing an additional layer of data safety.

For more information, refer to Multi-Region Capabilities Overview.

PostgreSQL compatibility

CockroachDB supports the PostgreSQL wire protocol and the majority of PostgreSQL syntax. This means that existing applications built on PostgreSQL can often be migrated to CockroachDB without changing application code.

For more information, refer to PostgreSQL Compatibility