PostgreSQL replication

Type Book

Rate 0.0 /5

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 replication. If you want to make your databases more robust, more secure, faster, and more scalable, you will find all the information you need in this single book focusing exclusively on PostgreSQL replication. It is assumed tha…

Details

Files

Reviews

Download

Title Statements

Full title :PostgreSQL replication / Zoltan Boszormenyi, Hans-Jurgen Schonig.

Summary

Edition Statements

Publication Date:©2013

Publication Statements

Publisher(s):Packt Publishing
Place of Publication:Birmingham
Language:eng
Publication Date:©2013

Notes

Includes index.

The Physical Object

Description:1 online resource (250 pages) : : illustrations

Edition Identifiers

ISBN:9781849516730, 1849516731
oclc:ocn961537789
LC Classification:QA76.9.D3
Dewey Decimal:005.7565

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 v…