Previously, we saw how to create a simple and strong fallback architecture through streaming replication in PostgreSQL, but where human intervention is necessary in case things go wrong.
To get around this issue, automation is key. That is why we are now going to see one of the most interesting solutions in the field of HA: the Heimdall data proxy.
The Heimdall proxy is a data access layer for application developers, database administrators, and architects. Whether on-premises or in the cloud, our proxy helps organizations to deliver faster, more reliable, and secure content generation.
Heimdall has the following features:
- Connection pooling
- Automated caching
- Load balancing
- High availability
In particular, we will talk about HA where Heimdall provides a multi-tiered approach to supporting it and supports a wider variety of database vendors and database topologies. We will examine one of the most...