[AWS] Simple MySQL connection monitoring for CloudWatch

cw_mysq_stat.sh

#!/bin/sh

MYSQL="mysql"
 
max_connections=$(mysql -e "show variables like 'max_connections'" 2>/dev/null | grep -i "max_connections" | awk '{print $2}')
threads_connected=$(mysqladmin extended-status | grep -i 'threads_connected' | awk '{ print $4}')
cdate=$(date -u +%Y-%m-%dT%H:%M:00.000Z)
instanceid="${INSTANCE_ID}"

aws cloudwatch put-metric-data --metric-name MySQLMaxConnections --namespace "CustomMySQLMetrics" --dimensions="InstanceId=$instanceid" --value $max_connections --timestamp $cdate
aws cloudwatch put-metric-data --metric-name MySQLThreadsConnected --namespace "CustomMySQLMetrics" --dimensions="InstanceId=$instanceid" --value $threads_connected --timestamp $cdate