PostgreSQL 12 high availability cookbook over 100 recipes to design a highly available server with the advanced features of PostgreSQL 12

Database outages are costly and largely avoidable. That's why it's important to apply time-tested high availability techniques. This book will help you design and build an indestructible PostgreSQL 12 cluster that can remain online even in the direst circumstances. You will learn to monito...

Full description

Bibliographic Details
Main Author: Thomas, Shaun
Format: eBook
Language:English
Published: Birmingham Packt Publishing 2020
Edition:Third edition
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
Description
Summary:Database outages are costly and largely avoidable. That's why it's important to apply time-tested high availability techniques. This book will help you design and build an indestructible PostgreSQL 12 cluster that can remain online even in the direst circumstances. You will learn to monitor and automate your way to reassuring high availability
Item Description:Table of ContentsArchitectural ConsiderationsHardware PlanningMinimizing DowntimeProxy and Pooling ResourcesTroubleshootingMonitoringPostgreSQL ReplicationBackup ManagementHigh Availability with repmgrHigh Availability with PatroniLow-Level Server MirroringHigh Availability via PacemakerHigh Availability with Multi-Master ReplicationData DistributionZero-downtime Upgrades
Physical Description:1 online resource
ISBN:9781838985059
1838985050