PostgreSQL high availability cookbook master over 100 recipes to design and implement a highly available server with the advanced features of PostgreSQL
Master over 100 recipes to design and implement a highly available server with the advanced features of PostgreSQL About This Book Create a PostgreSQL cluster that stays online even when disaster strikes Avoid costly downtime and data loss that can ruin your business Updated to include the newest fe...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Birmingham, [England] ; Mumbai, [India] :
Packt Publishing
2017.
|
| Edición: | Second edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630116106719 |
Tabla de Contenidos:
- Cover
- Copyright
- Credits
- About the Author
- About the Reviewer
- www.Packtpub.com
- Customer Feedback
- Table of Contents
- Preface
- Chapter 1: Hardware Planning
- Introduction
- Planning for redundancy
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Having enough IOPS
- Getting ready
- How to do it…
- How it works…
- There's more…
- A working example
- Making concessions
- Sizing storage
- Getting ready
- How to do it…
- How it works…
- There's more…
- Real-world example
- Adjusting the numbers
- Incorporating the spreadsheet
- Investing in a RAID
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Picking a processor
- Getting ready
- How to do it…
- How it works…
- There's more…
- Hyperthreading
- Turbo Boost
- Power usage
- See also
- Making the most of memory
- Getting ready
- How to do it…
- How it works…
- There's more…
- Exploring nimble networking
- Getting ready
- How to do it…
- How it works…
- There's more…
- A networking example
- Remembering redundancy
- Saving the research
- See also
- Managing motherboards
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Selecting a chassis
- Getting ready
- How to do it…
- How it works…
- There's more…
- Saddling up to a SAN
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Tallying up
- Getting ready
- How to do it…
- How it works…
- There's more…
- Protecting your eggs
- Getting ready
- How to do it…
- How it works…
- There's more…
- Chapter 2: Handling and Avoiding Downtime
- Introduction
- Determining acceptable losses
- Getting ready
- How to do it…
- How it works…
- Configuration - getting it right the first time
- Getting ready
- How to do it…
- How it works…
- There's more….
- See also
- Configuration - managing scary settings
- Getting ready
- How to do it…
- How it works…
- There's more…
- Distinct settings
- More information
- See also
- Identifying important tables
- Getting ready
- How to do it…
- How it works…
- There's more…
- Reset stats
- Using pgstattuple
- See also
- Defusing cache poisoning
- Getting ready
- How to do it…
- How it works…
- See also
- Exploring the magic of virtual IPs
- Getting ready
- How to do it…
- How it works…
- There's more…
- Terminating rogue connections
- Getting ready
- How to do it…
- How it works…
- There's more…
- Reducing contention with concurrent indexes
- Getting ready
- How to do it…
- How it works…
- There's more…
- No transactions
- One at a time
- Danger with OLTP use
- See also
- Managing system migrations
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Managing software upgrades
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Mitigating the impact of hardware failure
- Getting ready
- How to do it…
- How it works…
- There's more…
- Copying WAL files more easily
- Adding compression
- Secondary delay
- See also
- Applying bonus kernel tweaks
- Getting ready
- How to do it…
- How it works…
- There's more…
- Chapter 3: Pooling Resources
- Introduction
- Determining connection costs and limits
- Getting ready
- How to do it…
- How it works…
- There's more…
- Installing PgBouncer
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Configuring PgBouncer safely
- Getting ready
- How to do it…
- How it works…
- There's more…
- What about pool_mode?
- Problems with prepared statements
- See also
- Connecting to PgBouncer
- Getting ready
- How to do it…
- How it works…
- See also.
- Listing PgBouncer server connections
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Listing PgBouncer client connections
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Evaluating PgBouncer pool health
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Installing pgpool
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Configuring pgpool for master/slave mode
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Testing a write query on pgpool
- Getting ready
- How to do it…
- How it works…
- There's more…
- Swapping active nodes with pgpool
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Combining the power of PgBouncer and pgpool
- Getting ready
- How to do it…
- How it works…
- There's more…
- Chapter 4: Troubleshooting
- Introduction
- Performing triage
- Getting ready
- How to do it…
- How it works…
- There's more…
- Installing common statistics packages
- How to do it…
- How it works…
- Evaluating the current disk performance with iostat
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Tracking I/O-heavy processes with iotop
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Viewing past performance with sar
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Correlating performance with dstat
- Getting ready
- How to do it…
- How it works…
- See also
- Interpreting /proc/meminfo
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Examining /proc/net/bonding/bond0
- Getting ready
- How to do it…
- How it works…
- See also
- Checking the pg_stat_activity view
- Getting ready
- How to do it….
- How it works…
- There's more…
- See also
- Checking the pg_stat_statements view
- Getting ready
- How to do it…
- How it works…
- There's more…
- Resetting the stats
- Catching more queries
- See also
- Deciphering database locks
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Debugging with strace
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Logging checkpoints properly
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Chapter 5: Monitoring
- Introduction
- Figuring out what to monitor
- Getting ready
- How to do it…
- How it works…
- There's more…
- Installing and configuring Nagios
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Configuring Nagios to monitor a database host
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Enhancing Nagios with check_mk
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Getting to know check_postgres
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Installing and configuring collectd
- Getting ready
- How to do it…
- How it works…
- See also
- Adding a custom PostgreSQL monitor to collectd
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Installing and configuring Graphite
- Getting ready
- How to do it…
- How it works…
- See also
- Adding collectd data to Graphite
- Getting ready
- How to do it…
- How it works…
- See also
- Building a graph in Graphite
- Getting ready
- How to do it…
- How it works…
- There's more…
- Customizing a Graphite graph
- Getting ready
- How to do it…
- How it works…
- Creating a Graphite dashboard
- Getting ready
- How to do it…
- How it works…
- There's more….
- Chapter 6: Replication
- Introduction
- Deciding what to copy
- Getting ready
- How to do it…
- How it works…
- Securing the WAL stream
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Setting up a hot standby
- Getting ready
- How to do it…
- How it works…
- See also
- Upgrading to asynchronous replication
- Getting ready
- How to do it…
- How it works…
- There's more…
- Cascading replication
- Using replication slots
- Viewing replication status on a replica
- See also
- Bulletproofing with synchronous replication
- Getting ready
- How to do it…
- How it works…
- There's more…
- Being less strict
- Being more strict
- Enabling extreme durability
- See also
- Faking replication with pg_receivexlog
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Setting up Slony
- Getting ready
- How to do it…
- How it works…
- See also
- Copying a few tables with Slony
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Setting up Bucardo
- Getting ready
- How to do it…
- How it works…
- See also
- Copying a few tables with Bucardo
- Getting ready
- How to do it…
- How it works…
- See also
- Setting up Londiste
- Getting ready
- How to do it…
- How it works…
- See also
- Copying a few tables with Londiste
- Getting ready
- How to do it…
- How it works…
- See also
- Setting up pglogical
- Getting ready
- How to do it…
- How it works…
- See also
- Copying a few tables with pglogical
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Chapter 7: Replication Management Tools
- Introduction
- Deciding when to use third-party tools
- Getting ready
- How to do it…
- How it works…
- There's more…
- Installing and configuring Barman
- Getting ready
- How to do it….
- How it works….
