Dealing with failovers and High Availability
Some obvious issues, which can be addressed with pgpool, are of High Availability and failover. In general, there are various approaches available to handle those topics with or without pgpool.
Using PostgreSQL streaming and Linux HA
The easiest approach to High Availability with pgpool is to use PostgreSQL onboard tools along with Linux HA. In this case, in our world, the best approach is to run pgpool without statement-level replication and use PostgreSQL streaming replication to sync the data.
The pgpool tool can be configured to do load balancing and automatically send write requests to the first and read requests to the second node.
What happens in case of failover? Let us assume that the master will ...
Get PostgreSQL Replication - Second Edition 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.
