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.
For a deeper dive into CockroachDB's capabilities and how it fits into the database landscape, take the free Intro to Distributed SQL and CockroachDB course on Cockroach University.
Why use CockroachDB?
There are many reasons to use CockroachDB, including:
- Strong consistency
- Geo-partioning and multi-region features
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.
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.
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.
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
Pick your deployment
For more information about how to deploy CockroachDB and which option is best for your workload, refer to How to Choose a Deployment Option.