Proxy and Pooling Resources

Abstraction can protect a database from even the busiest platform and also ensure that applications always contact an online database server. Previous chapters in this book have already emphasized the importance of masquerading the primary database node to enable maintenance and availability. Two tools that are very popular for this purpose are virtual IP addresses and HAProxy software.

Yet there's always more to the story; abstraction isn't merely about indirection.

Modern applications, microarchitectures, and web services often involve hundreds or even thousands of servers and virtual machines (VMs). If we follow a simple and naive development cycle where applications have direct access to the database, each ...

Get PostgreSQL 12 High Availability Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.