最新章節
- Index
- Summary
- Adjusting filtering rules
- Using additional configuration options
- Installing walbouncer
- The concepts of walbouncer
品牌：中圖公司
上架時間：2021-07-16 11:10:52
出版社：Packt Publishing
本書數字版權由中圖公司提供，并由其授權上海閱文信息技術有限公司制作發行
- Index 更新時間：2021-07-16 13:34:08
- Summary
- Adjusting filtering rules
- Using additional configuration options
- Installing walbouncer
- The concepts of walbouncer
- Chapter 15. Working with Walbouncer
- Summary
- Controlling replication
- Understanding sets
- Setting up a simple cluster
- Installing BDR
- Understanding BDR replication concepts
- Chapter 14. Scaling with BDR
- Summary
- Extending and handling clusters in a clever way
- Setting up PL/Proxy
- Understanding the basic concepts
- Chapter 13. Scaling with PL/Proxy
- Summary
- Handling failovers and dropping nodes
- Adding nodes
- Creating tables and issuing queries
- Optimizing for performance
- Configuring a simple cluster
- Installing Postgres-XC
- Understanding the Postgres-XC architecture
- Chapter 12. Working with Postgres-XC
- Summary
- A word about walmgr
- Using Londiste to replicate data
- Managing pgq queues
- Dissecting SkyTools
- Installing SkyTools
- Chapter 11. Using SkyTools
- Summary
- Performing failovers
- Adding tables to replication and managing problems
- Deploying DDLs
- Replicating your first database
- Understanding how Slony works
- Installing Slony
- Chapter 10. Configuring Slony
- Summary
- Dealing with failovers and High Availability
- Running pgpool with streaming replication
- Checking the replication
- Setting up replication and load balancing
- Understanding the pgpool architecture
- Understanding the features of pgpool
- Installing pgpool
- Chapter 9. Working with pgpool
- Summary
- Maintaining PgBouncer
- Improving performance
- Configuring your first PgBouncer setup
- Installing PgBouncer
- Understanding the fundamental PgBouncer concepts
- Chapter 8. Working with PgBouncer
- Summary
- Common maintenance tasks
- Setting up a simple HA cluster
- Understanding Linux-HA
- The split-brain syndrome
- Detecting failures
- Durability and availability
- Measuring availability
- Understanding the purpose of High Availability
- Chapter 7. Understanding Linux High Availability
- Summary
- Dealing with monitoring tools
- Checking for replication slots
- Checking for operating system processes
- Checking pg_stat_replication
- Checking your archive
- Chapter 6. Monitoring Your Setup
- Summary
- Redundancy and stopping replication
- Understanding the practical implications and performance
- Synchronous replication setup
- Chapter 5. Setting Up Synchronous Replication
- Summary
- Delayed replicas
- Dealing with timelines
- Conflict management
- Efficient cleanup and the end of recovery
- Making streaming-only replication more robust
- Mixing streaming-based and file-based recovery
- Turning slaves into masters
- Configuring a cascaded replication
- Setting up streaming replication
- Chapter 4. Setting Up Asynchronous Replication
- Summary
- Replaying the transaction log
- Taking base backups
- Archiving the transaction log
- Understanding the purpose of PITR
- Chapter 3. Understanding Point-in-time Recovery
- Summary
- Making use of replication slots
- Experiencing the XLOG in action
- Tuning checkpoints and the XLOG
- Understanding consistency and data loss
- The XLOG and replication
- How PostgreSQL writes data
- Chapter 2. Understanding the PostgreSQL Transaction Log
- Summary
- Using sharding and data distribution
- Different types of replication
- The CAP theorem and physical limitations of replication
- Chapter 1. Understanding the Concepts of Replication
- Preface
- www.PacktPub.com
- About the Reviewers
- About the Author
- Credits
- 版權信息
- 封面
- 封面
- 版權信息
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Preface
- Chapter 1. Understanding the Concepts of Replication
- The CAP theorem and physical limitations of replication
- Different types of replication
- Using sharding and data distribution
- Summary
- Chapter 2. Understanding the PostgreSQL Transaction Log
- How PostgreSQL writes data
- The XLOG and replication
- Understanding consistency and data loss
- Tuning checkpoints and the XLOG
- Experiencing the XLOG in action
- Making use of replication slots
- Summary
- Chapter 3. Understanding Point-in-time Recovery
- Understanding the purpose of PITR
- Archiving the transaction log
- Taking base backups
- Replaying the transaction log
- Summary
- Chapter 4. Setting Up Asynchronous Replication
- Setting up streaming replication
- Configuring a cascaded replication
- Turning slaves into masters
- Mixing streaming-based and file-based recovery
- Making streaming-only replication more robust
- Efficient cleanup and the end of recovery
- Conflict management
- Dealing with timelines
- Delayed replicas
- Summary
- Chapter 5. Setting Up Synchronous Replication
- Synchronous replication setup
- Understanding the practical implications and performance
- Redundancy and stopping replication
- Summary
- Chapter 6. Monitoring Your Setup
- Checking your archive
- Checking pg_stat_replication
- Checking for operating system processes
- Checking for replication slots
- Dealing with monitoring tools
- Summary
- Chapter 7. Understanding Linux High Availability
- Understanding the purpose of High Availability
- Measuring availability
- Durability and availability
- Detecting failures
- The split-brain syndrome
- Understanding Linux-HA
- Setting up a simple HA cluster
- Common maintenance tasks
- Summary
- Chapter 8. Working with PgBouncer
- Understanding the fundamental PgBouncer concepts
- Installing PgBouncer
- Configuring your first PgBouncer setup
- Improving performance
- Maintaining PgBouncer
- Summary
- Chapter 9. Working with pgpool
- Installing pgpool
- Understanding the features of pgpool
- Understanding the pgpool architecture
- Setting up replication and load balancing
- Checking the replication
- Running pgpool with streaming replication
- Dealing with failovers and High Availability
- Summary
- Chapter 10. Configuring Slony
- Installing Slony
- Understanding how Slony works
- Replicating your first database
- Deploying DDLs
- Adding tables to replication and managing problems
- Performing failovers
- Summary
- Chapter 11. Using SkyTools
- Installing SkyTools
- Dissecting SkyTools
- Managing pgq queues
- Using Londiste to replicate data
- A word about walmgr
- Summary
- Chapter 12. Working with Postgres-XC
- Understanding the Postgres-XC architecture
- Installing Postgres-XC
- Configuring a simple cluster
- Optimizing for performance
- Creating tables and issuing queries
- Adding nodes
- Handling failovers and dropping nodes
- Summary
- Chapter 13. Scaling with PL/Proxy
- Understanding the basic concepts
- Setting up PL/Proxy
- Extending and handling clusters in a clever way
- Summary
- Chapter 14. Scaling with BDR
- Understanding BDR replication concepts
- Installing BDR
- Setting up a simple cluster
- Understanding sets
- Controlling replication
- Summary
- Chapter 15. Working with Walbouncer
- The concepts of walbouncer
- Installing walbouncer
- Using additional configuration options
- Adjusting filtering rules
- Summary
- Index 更新時間：2021-07-16 13:34:08
