global
        log 127.0.0.1     local0
        log 127.0.0.1     local1 notice
        maxconn           256000
        spread-checks     5
        daemon
        quiet
#        chroot            /var/lib/haproxy
#        user              haproxy
#        group             haproxy

defaults
    log                   global
    option                dontlognull
    option                allbackups
    maxconn               256000
    timeout               connect 5000
    timeout               check 5000
    timeout               client 30000
    timeout               server 30000

# Load balancer stats page access at hostname:8080/haproxy_stats
listen stats
    bind                  *:9876
    mode                  http
    stats                 enable
    stats                 realm Haproxy\ Statistics\ CrDB
    stats                 uri /stats
    stats                 hide-version
#    stats                 auth admin:admin@crdb

backend crdb_pg_n_cr_backend
    balance               leastconn
    mode                  tcp
    option                tcpka
    option                tcplog
    option                srvtcpka
    option                log-health-checks
    option                redispatch
    option                pgsql-check user haproxy
    balance               roundrobin
    timeout               connect 3s
    timeout               server 20s
    server usw2c-756 storage-base-usw2c-756.ops:26257 check
    server usw2b-755 storage-base-usw2b-755.ops:26257 check
    server use1b-754 storage-base-use1b-754.ops:26257 check
    server euw1c-753 storage-base-euw1c-753.ops:26257 check
    server euw1b-752 storage-base-euw1b-752.ops:26257 check
#    server aps2b-751 storage-base-aps2b-751.ops:26257 check
    server aps1b-750 storage-base-aps1b-750.ops:26257 check
    server aps1a-749 storage-base-aps1a-749.ops:26257 check
    server apn1c-748 storage-base-apn1c-748.ops:26257 check
    server apn1a-747 storage-base-apn1a-747.ops:26257 check
    server apn1a-746 storage-base-apn1a-746.ops:26257 check
    server aps1a-745 storage-base-aps1a-745.ops:26257 check
#    server aps2a-744 storage-base-aps2a-744.ops:26257 check
    server euw1a-743 storage-base-euw1a-743.ops:26257 check
#    server usw2a-742 storage-base-usw2a-742.ops:26257 check
    server use1a-740 storage-base-use1a-740.ops:26257 check

frontend crdb_cr_frontend
    bind                  *:26257
    mode                  tcp
    option                tcplog
    option                contstats
    option                tcpka
    default_backend       crdb_pg_n_cr_backend

frontend crdb_pg_frontend
    bind                  *:5432
    mode                  tcp
    option                tcplog
    option                contstats
    option                tcpka
    default_backend       crdb_pg_n_cr_backend

backend crdb_admin_gui_backend
    balance               leastconn
    mode                  tcp
    option                tcpka
    option                tcplog
    option                srvtcpka
    option                log-health-checks
    option                redispatch
    balance               roundrobin
    timeout               connect 3s
    timeout               server 20s
    server usw2c-756 storage-base-usw2c-756.ops:8080 check
    server usw2b-755 storage-base-usw2b-755.ops:8080 check
    server use1b-754 storage-base-use1b-754.ops:8080 check
    server euw1c-753 storage-base-euw1c-753.ops:8080 check
    server euw1b-752 storage-base-euw1b-752.ops:8080 check
#    server aps2b-751 storage-base-aps2b-751.ops:8080 check
    server aps1b-750 storage-base-aps1b-750.ops:8080 check
    server aps1a-749 storage-base-aps1a-749.ops:8080 check
    server apn1c-748 storage-base-apn1c-748.ops:8080 check
    server apn1a-747 storage-base-apn1a-747.ops:8080 check
    server apn1a-746 storage-base-apn1a-746.ops:8080 check
    server aps1a-745 storage-base-aps1a-745.ops:8080 check
#    server aps2a-744 storage-base-aps2a-744.ops:8080 check
    server euw1a-743 storage-base-euw1a-743.ops:8080 check
    server usw2a-742 storage-base-usw2a-742.ops:8080 check
    server use1a-740 storage-base-use1a-740.ops:8080 check

frontend crdb_admin_gui_frontend
    bind                  *:7777
    mode                  tcp
    option                tcplog
    option                contstats
    option                tcpka
    default_backend       crdb_admin_gui_backend