This article describes how open source PolarDB uses pgpool-II to implement transparent read/write splitting.
The need for more reads and fewer writes places enormous pressure on the database's read capacity. To solve this issue, here comes the R/W splitting.
The article describes the step-by-step procedure of read/write splitting in ApsaraDB RDS for PostgreSQL 12 using the pgpool tool.
This article evaluates how to use a read-only instance in the Three-node Enterprise Edition of RDS for MySQL to process massive volumes of read requests.