文件名称：应用场景-泥鳅 cpgc2013 pgpool-ii 简介
文件大小：1.85MB
文件格式：PPT
更新时间：2024-05-15 15:14:28
gp
应用场景 Replication PostgreSQL PostgreSQL PostgreSQL pgpool-II PostgreSQL Client Write A Read B Write A Read C Write A Read B Write A PostgreSQL Client Read C Pros 1、Synchronous replication: no need to worry about “eventually consistent” problem. No transaction loss 2、Automatic failover: no phone calls from angry customers while you are in bed 3、Connection pooling and load balancing: boost performance 4、Online recovery. Without stopping pgpool-II, you can repair or add a DB node 5、Easy to configure Cons 1、Write performance is not good(about 30% overhead) 2、Some queries confuse pgpool-II: random(), sequences, functions those have a side effect(write to the database) *