docs/content/stable/faq/comparisons/_index.md
| Feature | CockroachDB | TiDB | Vitess | Amazon Aurora | Google Cloud Spanner | YugabyteDB |
|---|---|---|---|---|---|---|
| Horizontal write scalability (with auto-sharding and rebalancing) | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> |
| Automated failover & repair | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> |
| Distributed ACID transactions | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> |
| SQL Foreign Keys | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> |
| SQL Joins | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> |
| Serializable isolation level | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> |
| Global consistency across multi-DC/regions | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-exclamation"></i> | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> |
| Follower reads | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-check"></i> |
| Built-in enterprise features (such as CDC) | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> |
| SQL compatibility | PostgreSQL | MySQL | MySQL | MySQL, PostgreSQL | Proprietary | PostgreSQL |
| Open Source | <i class="fa-solid fa-xmark"></i> | Apache 2.0 | Apache 2.0 | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-xmark"></i> | Apache 2.0 |
| Feature | MongoDB | FoundationDB | Apache Cassandra | Amazon DynamoDB | MS Azure CosmosDB | YugabyteDB |
|---|---|---|---|---|---|---|
| Horizontal write scalability (with auto-sharding and rebalancing) | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> |
| Automated failover & repair | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> |
| Distributed ACID transactions | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-check"></i> |
| Consensus-driven, strongly-consistent replication | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-check"></i> |
| Strongly-consistent secondary indexes | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-check"></i> |
| Multiple read consistency levels | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> | <i class="fa-solid fa-check"></i> |
| High data density | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-check"></i> |
| API | MongoDB QL | Proprietary KV, MongoDB QL | Cassandra QL | Proprietary KV, Document | Cassandra QL, MongoDB QL | Yugabyte Cloud QL w/ native document modeling |
| Open Source | <i class="fa-solid fa-xmark"></i> | Apache 2.0 | Apache 2.0 | <i class="fa-solid fa-xmark"></i> | <i class="fa-solid fa-xmark"></i> | Apache 2.0 |
{{< note title="Note" >}}
The <i class="fa-solid fa-check"></i>, <i class="fa-solid fa-xmark"></i>, or <i class="fa-solid fa-exclamation"></i> with respect to any particular feature of a third-party database is based on our best effort understanding from publicly available information. Readers are always recommended to perform their own independent research to understand the finer details.
{{< /note >}}