- PostgreSQL Replication
- Table of Contents
- PostgreSQL Replication
- Credits
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Preface
- 1. Understanding Replication Concepts
- The CAP theory and physical limitations
- Different types of replication
- Using sharding and data distribution
- Summary
- 2. Understanding the PostgreSQL Transaction Log
- How PostgreSQL writes data
- The PostgreSQL disk layout
- Looking into the data directory
- PG_VERSION – PostgreSQL version number
- base – the actual data directory
- global – the global data
- pg_clog – the commit log
- pg_hba.conf – host-based network configuration
- pg_ident.conf – ident authentication
- pg_multixact – multi-transaction status data
- pg_notify – LISTEN/NOTIFY data
- pg_serial – information about committed serializable transactions
- pg_snapshot – exported snapshots
- pg_stat_tmp – temporary statistics data
- pg_subtrans – subtransaction data
- pg_tblspc – symbolic links to tablespaces
- pg_twophase – information about prepared statements
- pg_XLOG – the PostgreSQL transaction log (WAL)
- postgresql.conf – the central PostgreSQL configuration file
- Writing one row of data
- Read consistency
- The PostgreSQL disk layout
- The XLOG and replication
- Understanding consistency and data loss
- Tuning checkpoints and the XLOG
- The internal structure of the XLOG
- Summary
- How PostgreSQL writes data
- 3. Understanding Point-In-Time-Recovery
- 4. Setting up Asynchronous Replication
- 5. Setting up Synchronous Replication
- Setting up synchronous replication
- Understanding practical implications and performance
- Redundancy and stopping replication
- Summary
- 6. Monitoring Your Setup
- 7. Understanding Linux High Availability
- 8. Working with pgbouncer
- 9. Working with pgpool
- 10. Configuring Slony
- 11. Using Skytools
- 12. Working with Postgres-XC
- 13. Scaling with PL/Proxy
- Index
In this chapter we learned how to use pgbouncer for highly scalable web applications to reduce the overhead of permanent connection creation. We saw how to configure the system and how we can utilize the virtual management database.
In the next chapter you will be introduced to pgpool, a tool to perform replication and connection pooling. Just like pgbouncer, pgpool is open source and can be used along with PostgreSQL to improve your cluster setups.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.