# 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