PostgreSQL 9 high availability cookbook : over 100 recipes to design and implement a highly available server with the advanced features of PostgreSQL / Shaun M. Thomas.

Format:

Book

Author/Creator:

Thomas, Shaun M., author.

Series:

Quick answers to common problems

Language:

English

Subjects (All):

PostgreSQL.

Database management.

Physical Description:

1 online resource (398 p.)

Edition:

1st edition

Other Title:

Postrege Structured Query Language

Place of Publication:

Birmingham, [England] : Packt Publishing, 2014.

Language Note:

English

System Details:

Mode of access: World Wide Web.

text file

Summary:

A comprehensive series of dependable recipes to design, build, and implement a PostgreSQL server architecture free of common pitfalls that can operate for years to come. Each chapter is packed with instructions and examples to simplify even highly complex database operations. If you are a PostgreSQL DBA working on Linux systems who want a database that never gives up, this book is for you. If you've ever experienced a database outage, restored from a backup, spent hours trying to repair a malfunctioning cluster, or simply want to guarantee system stability, this book is definitely for you.

Contents:

Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Hardware Planning; Introduction; Planning for redundancy; Having enough IOPS; Sizing storage; Investing in a RAID; Picking a processor; Making the most of memory; Exploring nimble networking; Managing motherboards; Selecting a chassis; Saddling up to a SAN; Tallying up; Protecting your eggs; Chapter 2: Handling and Avoiding Downtime; Introduction; Determining acceptable losses; Configuration - getting it right the first time; Configuration - managing scary settings

Identifying important tablesDefusing cache poisoning; Exploring the magic of virtual IPs; Terminating rogue connections; Reducing contention with concurrent indexes; Managing system migrations; Managing software upgrades; Mitigating the impact of hardware failure; Applying bonus kernel tweaks; Chapter 3: Pooling Resources; Introduction; Determining connection costs and limits; Installing PgBouncer; Configuring PgBouncer safely; Connecting to PgBouncer; Listing PgBouncer server connections; Listing PgBouncer client connections; Evaluating PgBouncer pool health; Installing pgpool

Configuring pgpool for master/slave modeTesting a write query on pgpool; Swapping active nodes with pgpool; Combining the power of PgBouncer and pgpool; Chapter 4: Troubleshooting; Introduction; Performing triage; Installing common statistics packages; Evaluating the current disk performance with iostat; Tracking I/O-heavy processes with iotop; Viewing past performance with sar; Correlating performance with dstat; Interpreting /proc/meminfo; Examining /proc/net/bonding/bond0; Checking the pg_stat_activity view; Checking the pg_stat_statements view; Debugging with strace

Logging checkpoints properlyChapter 5: Monitoring; Introduction; Figuring out what to monitor; Installing and configuring Nagios; Configuring Nagios to monitor a database host; Enhancing Nagios with check_mk; Getting to know check_postgres; Installing and configuring collectd; Adding a custom PostgreSQL monitor to collectd; Installing and configuring Graphite; Adding collectd data to Graphite; Building a graph in Graphite; Customizing a Graphite graph; Creating a Graphite dashboard; Chapter 6: Replication; Introduction; Deciding what to copy; Securing the WAL stream; Setting up a hot standby

Upgrading to asynchronous replicationBulletproofing with synchronous replication; Faking replication with pg_receivexlog; Setting up Slony; Copying a few tables with Slony; Setting up Bucardo; Copying a few tables with Bucardo; Setting up Londiste; Copying a few tables with Londiste; Chapter 7: Replication Management Tools; Introduction; Deciding when to use third-party tools; Installing and configuring Barman; Backing up a database with Barman; Restoring a database with Barman; Installing and configuring OmniPITR; Managing WAL files with OmniPITR; Installing and configuring repmgr

Cloning a database with repmgr

Notes:

Includes index.

Includes bibliographical references and index.

Description based on online resource; title from PDF title page (ebrary, viewed July 29, 2014).

ISBN:

9781849516976

1849516979

OCLC:

884549082