Re:Why CockroachDB and PostgreSQL Are Compatible
by single-node on Thursday December 17, 2020 @11:29AM
(#25457065)
I wonder if it's better in a non sharded use of something like Cockroach to push the replication and HA outside the database, let the control plane(e.g. kubernetes) handle failure and restarts on different nodes, and let something like Ceph with it's efficient write path and replication handle data durability.
[ Parent
| on HN ]
Re:Why CockroachDB and PostgreSQL Are Compatible
by knz42 on Thursday December 17, 2020 @11:31AM
(#25457090)
You need to integrate transaction coordination with replication to ensure that the replication respects transaction atomicity (so that cross-shard queries get all their reads and writes isolated from each other, and rolled back atomically when a txn is aborted).
So separating the layers like you do is only possible if there is an XA protocol between the layers. Neither K8s nor Ceph support that.