Generic HA Architecture - App servers + PostgreSQL Patroni cluster

Published on Author admin

Generic HA Architecture - App servers + PostgreSQL Patroni cluster Keepalived + HAproxy used as Load Balancers   Key components: HAproxy - TCP/HTTP Load Balancer Keepalived - Virtual IP for HAproxy Patroni - HA template for PostgreSQL database (cluster with streaming replication) etcd - Distributed Configuration Store for Patroni   Architecture diagram:

Port forwarding using HAproxy

Published on Author admin

HAproxy can be used not only for complex load-balancing scenarios, but also for simple port forwarding. Useful for forwarding packets originating from both local and external hosts. listen postgresql 0.0.0.0:5432     mode tcp     stats enable     balance roundrobin     server postgresql-db 192.168.0.1:5432 check