- 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
Authors
Zoltan Böszörmenyi
Hans-Jürgen Schönig
Reviewers
Jeff Lawson
Tomas Vondra
Acquisition Editor
Joanne Fitzpatrick
Commissioning Editor
Llewellyn F. Rozario
Lead Technical Editor
Dayan Hyames
Technical Editors
Vrinda Nitesh Bhosale
Aniruddha Vanage
Project Coordinator
Leena Purkait
Proofreader
Chris Smith
Indexer
Monica Ajmera Mehta
Priya Subramani
Graphics
Disha Haria
Production Coordinator
Nilesh R. Mohite
Cover Work
Nilesh R. Mohite
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.