HAProxy : Layer 4 Load Balancing2022/05/19

Configure HAProxy on Layer 4 Mode.
On this example, configure MariaDB backend like the following environment.

-----------+---------------------------+--------------------------+------------
           |                           |                          |
           |10.0.0.30                  |10.0.0.51                 |10.0.0.52
+----------+-----------+   +-----------+----------+   +-----------+----------+
|   [ dlp.srv.world ]  |   | [ node01.srv.world ] |   | [ node02.srv.world ] |
|        HAProxy       |   |   MariaDB Server#1   |   |   MariaDB Server#2   |
+----------------------+   +----------------------+   +----------------------+

[1]	Configure HAProxy.

root@dlp:~#

vi /etc/haproxy/haproxy.cfg

# change [mode] value in [defaults] section

defaults

        log             global
        mode            tcp

# add to the end
# define frontend and backend servers
frontend mysql-in
        bind *:3306
        default_backend backend_dbservers

backend backend_dbservers
        balance         roundrobin
        server          node01 10.0.0.51:3306 check
        server          node02 10.0.0.52:3306 check

root@dlp:~#

systemctl restart haproxy

[2]	Verify working normally to access to the frontend HAproxy Server.

ubuntu@client:~#

mysql -u ubuntu -p -h dlp.srv.world -e "show variables like 'hostname';"

Enter password:

+---------------+------------------+
| Variable_name | Value            |
+---------------+------------------+
| hostname      | node01.srv.world |
+---------------+------------------+

ubuntu@client:~#

mysql -u ubuntu -p -h dlp.srv.world -e "show variables like 'hostname';"

Enter password:

+---------------+------------------+
| Variable_name | Value            |
+---------------+------------------+
| hostname      | node02.srv.world |
+---------------+------------------+

Matched Content