3 ms·
Under the “DBMS-optimized cloud storage” section, won’t replicating the WAL across various different availability zones entail doing an atomic broadcast if you
by IntrnlCmplrErr 3y ago
Under the “DBMS-optimized cloud storage” section, won’t replicating the WAL across various different availability zones entail doing an atomic broadcast if you want any isolation?
It seems to me that you would need to run some sort of consensus algorithm to ensure the replication is consistent but that’s obviously very expensive in latency. Is it actually done this way?
- foota 3y agoThey mention paralleling them, so it's only as expensive as the slowest write.
- franckpachot 3y agoAurora writes each block to 6 replicas, and waits for a quorum of 4 to acknowledge. This has small impact on commit time which you can see as IO:XactSync (https://dev.to/aws-heroes/aws-aurora-io-xactsync-is-not-a-postgresql-wait-event-3gio https://dev.to/aws-heroes/aws-aurora-io-xactsync-is-not-a-po...) but provides good HA