4 ms·
Is anybody aware of any serious research Yugabyte vs Postgres? Yugabyte appears to an application as essentially Postgres 11.2 with all psql features (even the
by rad_gruchalski 6y ago
Is anybody aware of any serious research Yugabyte vs Postgres?
Yugabyte appears to an application as essentially Postgres 11.2 with all psql features (even the row / column level security mechanisms) but, apparently, handles replication and sharding automagically (is it DHT, similar to Cassandra)?
Are there any serious technical comparisons with some conclusions, without marketing bs?
- zinclozenge 6y agoyugabyte is multi-raft i believe
- manigandham 6y agoYes, Yugabyte has been featured on Jepsen. It's basically in the class of "newsql" natively distributed relational databases. Yugabyte uses actual Postgres code for the query parsing top layer and then translates that into to operates on it's key/value store which handles replication and distributed. CockroachDB is similar but has built everything from scratch in Go. There are similar examples like TiDB and Vitesse for MySQL as well.
- rad_gruchalski 6y agoThe Jepsen tests do not inspire confidence but they're also pretty aged by now. 1.3.1 under test and the most recent appears to be 2.7.0. Cockroach is a no go for me because of the licensing restrictions. For example, password authentication only in the BSL licensed code. Backups in enterprise.
- jordanlewis 6y agoBackups are available without a license in CockroachDB as of 20.2, FWIW. https://www.cockroachlabs.com/blog/distributed-backup-restore/ https://www.cockroachlabs.com/blog/distributed-backup-restor... https://www.cockroachlabs.com/docs/v20.2/backup.html https://www.cockroachlabs.com/docs/v20.2/backup.html