| title | summary | toc | optimizely |
|---|---|---|---|
CockroachDB in Comparison |
Learn how CockroachDB compares to other popular databases. |
false |
true |
This page shows you how key features of CockroachDB stack up against other databases. Hover over features for their intended meanings, and click CockroachDB answers to view related documentation.
| CockroachDB | MySQL | PostgreSQL | Oracle | SQL Server | Cassandra | HBase | MongoDB | DynamoDB | Spanner | |
|---|---|---|---|---|---|---|---|---|---|---|
| Automated Scaling | Yes | No | No | No | No | Yes | Yes | Yes | Yes | Yes |
| Automated Failover | Yes | Optional | Optional | Optional | Optional | Yes | Yes | Yes | Yes | Yes |
| Automated Repair | Yes | No | No | No | No | Yes | Yes | Yes | Yes | Yes |
| Strongly Consistent Replication | Yes | No | No | Optional | Optional | Optional | No | No | Yes | Yes |
| Consensus-Based Replication | Yes | No | No | No | No | Optional | No | No | Yes | Yes |
| Distributed Transactions | Yes | No | No | Yes | Yes | No | No | No | No* | Yes |
| ACID Semantics | Yes | Yes | Yes | Yes | Yes | No | Row-only | Document-only | Row-only* | Yes |
| Eventually Consistent Reads | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SQL | Yes | Yes | Yes | Yes | Yes | No | No | No | No | Read-only |
| Open Source | Yes | Yes | Yes | No | No | Yes | Yes | Yes | No | No |
| Commercial Version | Optional | Optional | No | Yes | Yes | Optional | Optional | Optional | Yes | Yes |
| Support | Full | Full | Full | Full | Full | Full | Full | Full | Full | Full |
* In DynamoDB, distributed transactions and ACID semantics across all data in the database, not just per row, requires an additional transaction library.