Low-Level Server Mirroring
So far in this book, we've discussed quite an array of functionality and methodology dedicated to keeping PostgreSQL systems online. By now, we have a burgeoning menagerie of replication utilities, system monitoring tools, connection pooling layers, failover and cluster automation frameworks, and even a handful of troubleshooting tips.
We then moved on to combining several of these techniques and a few others to create a software stack that automates and protects a PostgreSQL cluster. However, despite the power demonstrated in these chapters on repmgr and Patroni, they still rely primarily on PostgreSQL replication to safeguard replicated data. If we have an extremely high transaction throughput, even PostgreSQL ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access