文件名称：PostgreSQL 9 Administration Cookbook Second Edition
文件大小：16.41MB
文件格式：PDF
更新时间：2021-10-28 11:46:19
postgresql pgpool pgbouncer
Table of Contents Preface xi Chapter 1: Understanding the Concepts of Replication 1 The CAP theorem and physical limitations of replication 2 Understanding the CAP theorem 2 Understanding the limits of physics 4 Different types of replication 5 Synchronous versus asynchronous replication 6 Considering performance issues 7 Understanding replication and data loss 7 Single-master versus multimaster replication 8 Logical versus physical replication 9 When to use physical replication 10 When to use logical replication 10 Using sharding and data distribution 11 Understanding the purpose of sharding 11 Designing a sharded system 11 Querying different fields 12 Pros and cons of sharding 13 Choosing between sharding and redundancy 14 Increasing and decreasing the size of a cluster 15 Combining sharding and replication 17 Various sharding solutions 18 PostgreSQL-based sharding 19 Summary 19 www.allitebooks.