PG-RAC: PostgreSQL-based Database with Shared Cache for Multi-write Transaction.
Saved in:
| Title: | PG-RAC: PostgreSQL-based Database with Shared Cache for Multi-write Transaction. |
|---|---|
| Authors: | Yujie Yin, Haoyang Shi, Zihao Fan, Huahui Zhou, Shengchi Liu, Huiqi Hu, Xing Wei, Hedui Chen, Yaofeng Tu, Peng Cai, Xuan Zhou |
| Source: | International Journal of Software & Informatics; 2025, Vol. 15 Issue 1, p43-67, 25p |
| Subject Terms: | DISTRIBUTED databases, CACHE memory, DATABASE management, DISTRIBUTED computing, TRANSACTION systems (Computer systems) |
| Abstract: | Single-master is the mainstream architecture of cloud-native databases. In the cluster, the slave node can share the read-only requests of the master node, and the master node processes the write requests. To meet the demands of large-scale transaction processing, on this basis, some of the cloud databases attempt to further extend multi-write transactions. One way to implement a multi-write extension is to implement a shared cache among compute nodes and support cross-node data access. In database systems based on shared cache, the cost of cross-node remote access is much larger than that of local access, so the design of the cache protocol is the key factor affecting the system’s performance and scalability. In this study, two innovative improvements to the cache protocol are proposed, and PG-RAC, a shared cache database supporting multi-write transaction processing, is implemented based on PostgreSQL. On the one hand, PG-RAC proposes a new distributed chained routing strategy to distribute routing information among compute nodes. The average transaction latency is reduced by about 20% compared to the routing strategy of single-point directory management. On the other hand, the replica invalidation mechanism is improved, and the invalidation operation is separated from the transaction path, reducing the latency of the critical path in transaction processing. On this basis, PG-RAC utilizes the characteristics of multi-version concurrency control (MVCC) to further propose to delay replica invalidation, effectively improving the cache utilization. The results of the TPC-C experiment show that in a cluster with four compute nodes, the throughput rate is nearly twice that of PostgreSQL and 1.5 times that of the distributed database Citus. [ABSTRACT FROM AUTHOR] |
| Copyright of International Journal of Software & Informatics is the property of Institute of Software, Chinese Academy of Sciences and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.) | |
| Database: | Complementary Index |
Nájsť tento článok vo Web of Science Be the first to leave a comment!