Vadim Yatsenko: Splitting the Read-Only Transaction: Replica Reads Inside an Open Transaction

T2Covered by 1 source · first reported by Planet PostgreSQL at 01 Nov, 08:37 UTC

Read/write splitting is easy for single, autocommit statements. It gets hard the moment a client opens a transaction. Most proxies give up and send every statement inside a transaction to the primary, even the reads. This article is about a middle path we built into Polar Proxy: keep the…

cloud

Sources

• T2Vadim Yatsenko: Splitting the Read-Only Transaction: Replica Reads Inside an Open TransactionPlanet PostgreSQL01 Nov, 08:37