- 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
Zoltan Böszörmenyi has over 15 years experience in the software development and IT industry. He started working with PostgreSQL in 1995 and has since been working exclusively developing and implementing solutions using it. Among many other things, he has extended ECPG, the embedded SQL-in-C flavor in PostgreSQL. He has also developed unique solutions for POS hardware. He also occasionally does training on PostgreSQL. He has held senior-level positions but now serves as the CTO of Cybertec Schönig & Schönig GmbH.
I would like to thank my family who have been positive and unconditional supporters. I would also like to thank my wife who is my greatest teacher and encourages me in ways she does not even know to make the impossible possible.
I would also like to thank my clients and past and present colleagues who have provided invaluable opportunities for me to expand my knowledge and shape my career.
Hans-Jürgen Schönig has 15 years of experience with PostgreSQL. He is the CEO of a PostgreSQL consulting and support company called "Cybertec Schönig & Schönig GmbH" (www.postgresql-support.de), which has successfully served countless customers around the globe.
Before founding Cybertec Schönig & Schönig GmbH in the year 2000, he worked as database developer at a private research company focusing on the Austrian labor market where he was primarily focusing on data mining and forecast models.
He has written several books dealing with PostgreSQL already.
This books is dedicated to all members of the Cybertec family, who have supported me over the years and who have proven to be true professionals. Without my fellow technicians here at Cybertec this book would not exist. I especially want to thank Ants Aasma for his technical input, Florian Ziegler for helping out with proof reading and graphical stuff. Last but not least I want to say thank you to one of my best private friends, Zoltan Böszörmenyi, who has been an excellent co-author and who has contributed countless ideas to this book and who has sorted out countless mistakes.
Special thanks also goes to my girl Sonja Städtner, who has given me all the private support. Somehow she managed to make me go to sleep when I was up late at night working on the initial drafts.
-
No Comment