haproxy-config 0.4.1

Parse HAProxy configs and easily query it
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

#  vim:ts=4:sts=4:sw=4:et
#
#  Author: Hari Sekhon
#  Date: 2017-12-16 10:56:16 +0000 (Sat, 16 Dec 2017)
#
#  https://github.com/HariSekhon/HAProxy-configs
#
#  License: see accompanying Hari Sekhon LICENSE file
#
#  If you're using my code you're welcome to connect with me on LinkedIn and optionally send me feedback to help steer this or other code I publish
#
#  https://www.linkedin.com/in/HariSekhon
#

# ============================================================================ #
#                          H A P r o x y  -  M y S Q L
# ============================================================================ #

# Tested and works on MariaDB too

frontend mysql
    description "MySQL"
    bind *:3306
    mode tcp
    option tcplog
    default_backend mysql

backend mysql
    description "MySQL"
    #balance leastconn
    balance first
    mode tcp
    acl internal_networks src 192.168.0.0/16 172.16.0.0/12 10.0.0.0/8 127.0.0.1
    tcp-request content reject if ! internal_networks
    option mysql-check # user root
    server mysql mysql:3306 check
    server mariadb mariadb:3306 check
    server docker docker:3306 check backup
    server 192.168.99.100 192.168.99.100:3306 check backup