Cargando…
PostgreSQL 9 high availability cookbook : over 100 recipes to desin and implement a highly available server with advanced features of PostgreSQL /
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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, UK :
Packt Pub.,
2014.
|
| Colección: | Quick answers to common problems.
|
| Temas: | |
| Acceso en línea: | Texto completo Texto completo |
Tabla de Contenidos:
- 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