CockroachDB in Comparison

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.

	MySQL PostgreSQL Oracle Cassandra MongoDB Spanner Yugabyte	MySQL PostgreSQL Oracle Cassandra MongoDB Spanner Yugabyte	CockroachDB
Database Horizontal Scale	Manual Sharding Add On Configuration Node based, Automated read scale, limited write Node based, Automated for both reads and writes	Manual Sharding Add On Configuration Node based, Automated read scale, limited write Node based, Automated for both reads and writes	Node based, Automated for both reads and writes
Database Load Balancing (internal)	Manual - not part of database None and Full copies across regions Even distribution to optimize storage	Manual - not part of database None and Full copies across regions Even distribution to optimize storage	Detailed options to optimize storage, compute and latency
Failover	Manual - not part of database Automated for reads, limited for writes to one region Automated for reads, limited guarantees for writes Fully automated for both reads and writes	Manual - not part of database Automated for reads, limited for writes to one region Automated for reads, limited guarantees for writes Fully automated for both reads and writes	Fully automated for both reads and writes
Automated Repair and RPO	Manual Repair RPO ~1-60 mins Automated RPO ~1 -5 mins Manual & Automated Repair RPO <1 min "Automated Repair RPO <10 sec"	Manual Repair RPO ~1-60 mins Automated RPO ~1 -5 mins Manual & Automated Repair RPO <1 min "Automated Repair RPO <10 sec"	Automated Repair RPO <10 sec
Distributed Reads	Manual - Asynchronous Yes	Manual - Asynchronous Yes	Yes
Distributed Transactions	No Lightweight Transations only Yes	No Lightweight Transations only Yes	Yes
Database Isolation Levels	Single Region Consistent Default: Snapshot Highest: Serializable Eventual Consistent Default: Read Uncommited Highest: Snapshot Read Eventual Consistent, No Transaction Isolation Guarantees Default: Snapshot Highest: Serializable	Single Region Consistent Default: Snapshot Highest: Serializable Eventual Consistent Default: Read Uncommited Highest: Snapshot Read Eventual Consistent, No Transaction Isolation Guarantees Default: Snapshot Highest: Serializable	Guaranteed Consistent Default: Serializable Highest: Serializable
Potential data issues (default)	Phantom Reads, Non-repeatable reads, Wite skew Dirty Reads, Phantom Reads, Non-repeatable reads, write skew Dirty Reads, Phantom Reads, Non-repeatable reads, write conflicts None Phantom Reads, Non-repeatable reads	Phantom Reads, Non-repeatable reads, Wite skew Dirty Reads, Phantom Reads, Non-repeatable reads, write skew Dirty Reads, Phantom Reads, Non-repeatable reads, write conflicts None Phantom Reads, Non-repeatable reads	None
SQL	Yes No Yes - with limitations	Yes No Yes - with limitations	Yes - wire compatible with PostgreSQL
Database Schema Change	Yes Offline Online, Active, Dynamic	Yes Offline Online, Active, Dynamic	Online, Active, Dynamic
Cost Based Optimization	Yes No ? No	Yes No ? No	Yes
Data Geo-partitoning	No Yes, Object Level Yes No	No Yes, Object Level Yes No	Yes, Row level
Upgrade Method	Offline Online, Rolling	Offline Online, Rolling	Online, Rolling
Multi-region	Yes - Manual Yes, but not for writes Yes, for reads and writes	Yes - Manual Yes, but not for writes Yes, for reads and writes	Yes for both reads and writes
Multi-cloud	No Yes	No Yes	Yes