install_rds_proxy.sh

#!/bin/bash
##
## Script: Installs a HA PROXY server for RDS on Debian Linux
## 
## Run the script as ./install_rds_proxy.sh <DNS NAME OF RDS INSTANCE>
##

SERVER=${1:-usawssdb01.c1jinrprkxs4.us-east-2.rds.amazonaws.com}

apt-get update
apt-get install -y haproxy

echo "ENABLED=1" >>/etc/default/haproxy

cat << 'EOF' >/etc/haproxy/haproxy.cfg
global
        log /dev/log    local0
        log /dev/log    local1 notice
        chroot /var/lib/haproxy
        maxconn 4000
        user haproxy
        group haproxy
        daemon

stats socket /var/lib/haproxy/stats mode 777

listen MSSQL 0.0.0.0:1433
        timeout connect 10s
        timeout client 1m
        timeout server 1m
        mode tcp
EOF

echo "        server singleMSSQL ${SERVER}:1433" >> /etc/haproxy/haproxy.cfg

service haproxy restart