#!/bin/bash

sudo apt install -y jq mysql-client-core-5.7
cat > /etc/zabbix/zabbix_agentd.d/userparameter_mysql_template.conf <<'zabbix'
UserParameter=Mysql.Server-Status, mysql --defaults-file=/etc/zabbix/.my.cnf --defaults-group-suffix=_monitoring -N -e  "show global status" |   jq  -c '.  | split("\n")[:-1]  | map (split("\t") | {(.[0]) : .[1]}  ) | add  ' -R -s
zabbix
cp /root/.my.cnf /etc/zabbix/.my.cnf
service zabbix-agent restart