Cargando…
PostgreSQL replication : understand basic replication concepts and efficiently replicate interruptions /
This book has a chapter dedicated to each aspect of replication. The new features of PostgreSQL 9 are introduced and there are lots of practical examples and screenshots.""PostgreSQL Replication"" is ideal for PostgreSQL administrators who want to set up and understand replicatio...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Packt Publishing,
2013.
|
| Colección: | Community experience distilled.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Understanding Replication Concepts; The CAP theory and physical limitations; Understanding the CAP theory; Why the speed of light matters; Long distance transmission; Why latency matters; Different types of replication; Synchronous versus asynchronous replication; Understanding replication and data loss; Considering the performance issues; Single-master versus multi-master replication; Logical versus physical replication; When to use physical replication.
- When to use logical replicationUsing sharding and data distribution; Understanding the purpose of sharding; An example of designing a sharded system; An example of 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; External frameworks/middleware; Summary; Chapter 2: Understanding the PostgreSQL Transaction Log; How PostgreSQL writes data; The PostgreSQL disk layout; Looking into the data directory.
- PG_VERSION
- PostgreSQL version numberbase
- 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; A simple INSERT statement; Read consistency; The purpose of the shared buffer; Mixed reads and writes; The XLOG and replication; Understanding consistency and data loss; All the way to the disk; From memory to memory; From memory to the disk; One word about batteries; Beyond fsync(); PostgreSQL consistency levels; Tuning checkpoints and the XLOG; Understanding the checkpoints; Configuring checkpoints; About segments and timeouts; To write or not to write?
- Tweaking WAL buffersThe internal structure of the XLOG; 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; 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; Modifying pg_hba.conf; Signaling the master server; pg_basebackup
- basic features; Making use of the traditional methods to create base backups; Tablespace issues.