| Description |
1 online resource (1 volume) : illustrations |
| Series |
Quick answers to common problems |
|
Quick answers to common problems.
|
| Note |
Includes index. |
| 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 |
| Subject |
PostgreSQL.
|
|
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 |
Postrege Structured Query Language |
| Other Form: |
Print version: Thomas, Shaun M. PostgreSQL 9 high availability cookbook : over 100 recipes to design and implement a highly available server with the advanced features of PostgreSQL. Birmingham, [England] : Packt Publishing, ©2014 iv, 384 pages Quick answers to common problems 9781849516969 |
| ISBN |
9781849516976 |
|
1849516979 |
|
1849516960 |
|
9781849516969 |
|
1306974933 |
|
9781306974936 |
|
More Resources