| Description |
1 online resource (1 volume) : illustrations |
| Series |
Community experience distilled |
|
Community experience distilled.
|
| Note |
Includes index. |
| Contents |
Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Understanding Concepts of Replication; The CAP theorem and physical limitations of replication; Understanding the CAP theorem; Understanding the limits of physics; Different types of replication; Synchronous versus asynchronous replication; Considering performance issues; Understanding replication and data loss; Single-master versus multimaster replication; Logical versus physical replication; When to use physical replication; When to use logical replication. |
|
Using sharding and data distributionUnderstanding the purpose of sharding; Designing a sharded system; Querying different fields; Pros and cons of sharding; Choosing between sharding and redundancy; Increasing and decreasing the size of a cluster; Combining sharding and replication; Various sharding solutions; PostgreSQL-based sharding; Summary; Chapter 2: Understanding the PostgreSQL Transaction Log; How PostgreSQL writes data; The PostgreSQL disk layout; Looking into the data directory; PG_VERSION -- the PostgreSQL version number; base -- the actual data directory; global -- the global data. |
|
Pg_clog -- the commit logpg_dynshmem -- shared memory; pg_hba.conf -- host-based network configuration; pg_ident.conf -- ident authentication; pg_logical -- logical decoding; pg_multixact -- multitransaction status data; pg_notify -- LISTEN/NOTIFY data; pg_replslot -- replication slots; pg_serial -- information about committed serializable transactions; pg_snapshot -- exported snapshots; pg_stat -- permanent statistics; 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; A simple INSERT statement; Read consistency; The purpose of the shared buffer; Mixed reads and writes; The format of the XLOG; The XLOG and replication; Understanding consistency and data loss; All the way to the disk; From memory to memory; From the memory to the disk; A word about batteries; Beyond the fsync function; PostgreSQL consistency levels; Tuning checkpoints and the XLOG; Understanding the checkpoints; Configuring checkpoints. |
|
About segments and timeoutsTo write or not to write?; Tweaking WAL buffers; Experiencing XLOG in action; Understanding the XLOG records; Making the XLOG deterministic; Making the XLOG reliable; LSNs and shared buffer interaction; Debugging the XLOG and putting it all together; Making use of replication slots; Physical replication slots; Logical replication slots; Configuring replication identities; Summary; Chapter 3: Understanding Point-in-time Recovery; Understanding the purpose of PITR; Moving to the bigger picture; Archiving the transaction log; Taking base backups; Using pg_basebackup. |
| Summary |
This book is ideal for PostgreSQL administrators who want to set up and understand replication. By the end of the book, you will be able to make your databases more robust and secure by getting to grips with PostgreSQL replication. |
| Subject |
PostgreSQL.
|
|
PostgreSQL |
|
Database management.
|
|
SQL (Computer program language)
|
|
Bases de données -- Gestion. |
|
SQL (Langage de programmation) |
|
Database management |
|
SQL (Computer program language) |
| Added Title |
Postgre SQL replication |
|
Postgre structured query language replication |
|
Leverage the power of PostgreSQL replication to make your databases more robust, secure, scalable, and fast |
|
Leverage the power of Postgre SQL replication to make your databases more robust, secure, scalable, and fast |
|
Leverage the power of Postgre structured query language replication to make your databases more robust, secure, scalable, and fast |
| Other Form: |
Print version: Schönig, Hans-Jürgen. PostgreSQL Replication. Birmingham : Packt Publishing, ©2015 9781783550609 |
| ISBN |
9781783988549 |
|
1783988541 |
|
1783550600 |
|
9781783550609 |
|
More Resources