- 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 have dealt with Postgres-XC, a distributed version of PostgreSQL capable of horizontal partitioning and query distribution. The goal of the Postgres-XC project is to have a database solution capable of scaling out writes transparently. It offers a consistent view of the data and offers various options to distribute data inside the cluster.
It is important to know that Postgres-XC is not just a simple add-on to PostgreSQL but a fully compliant code fork.
The next chapter will cover PL/Proxy, a tool to shard PostgreSQL database systems. We will learn how to distribute data to various nodes and shard data to handle large setups.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.