Part6 - PostgreSQL16 High Availability Lab Setup -Setting Up HAProxy To Load Balance PostgreSQL
Hi Everyone,
In Part 6 of our PostgreSQL 16 High Availability Lab Setup series, we focus on configuring HAProxy to load balance your PostgreSQL cluster. HAProxy is a powerful tool that ensures your database traffic is efficiently distributed across multiple nodes, enhancing performance and reliability. Follow along as we set up HAProxy to work seamlessly with your PostgreSQL 16 high availability environment.
Chapter:
00:00 Intro.
00:20 What is HAProxy .
01:06 Install HAProxy on 3 Nodes.
01:45 Backup HAProxy Configuration file on 3 Nodes.
02:30 Create HAProxy user in PostgreSQL database.
04:04 Add HAProxy to pg_hba.conf file in 3 Nodes.
06:18 GitHub repo to auto generate the HAProxy configs.
07:02 Go through the configuration file and explain it.
10:16 Configure HAProxy on 3 Nodes.
11:35 Set selinux to permissive.
13:03 Allow HAProxy in Linux Firewall.
13:25 Start the HAProxy systemd service.
14:21 Port Forward the 7000,5000 ports to main host.
Watch video Part6 - PostgreSQL16 High Availability Lab Setup -Setting Up HAProxy To Load Balance PostgreSQL online without registration, duration 16 minute 18 second in high hd quality. This video was added by user ICyb3r 16 August 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 54 once and liked it 1 people.