mysql.cfg

#  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