High Availability Procedures and Implementing a Pooler
- 47 Downloads
In the last chapter, we talked about some basic things about MVCC in PostgreSQL, and what is bloat in the database and how it can be removed. We explained how autovacuum helps in removing bloat and improving performance. We also covered the best practices to execute maintenance activities like vacuum, reindex in detail. In this chapter, we will talk about the importance of High Availability (HA), and what information we need to build an HA solution and the procedures to implement it in PostgreSQL. We will cover some open source and enterprise tools to implement HA. We will also cover the importance of a pooler, and available poolers on the market and their implementation.