27 ms·
You're right. I think in general the quorum commit in Postgres is a bit lower level, in the sense that it is less opinionated and allows you to configure the qu
by elvinyung 10y ago
You're right. I think in general the quorum commit in Postgres is a bit lower level, in the sense that it is less opinionated and allows you to configure the quorum (essentially enabling both semisync and synchronous).
Also, as sibling points out, semisync in MySQL seems to commit on the master first no matter what, while in PG quorum commit, no one commits until the required acks are received.
- morgo 10y agoMySQL 5.7+ will default to wait for the ack before committing locally. This is referred to as "lossless semi-sync".