Read more: perldoc mymonitor.pl

mysql_port.pl: MySQL port discovery for multiport of MySQL, and generate json format strings.

get_mysql_stats_wrapper.sh: a wrapper for parse MySQL status, runs every 5min.

perl-DBI
perl-DBD-mysql

1. # git clone https://github.com/arstercz/zabbix_mysql.git /usr/local/zabbix_mysql 

2. # bash /usr/local/zabbix_mysql/install.sh eth0

1. import templates/zabbix_mysql_multiport.xml using Zabbix UI(Configuration -> Templates -> Import), and Create/edit hosts by assigning them “MySQL” group and linking the template “MySQL_zabbix” (Templates tab).

    PROCESS, SUPER, REPLICATION SLAVE

    chmod +s /bin/netstat

# perl  mymonitor.pl --host 10.0.0.10 --port 3300 --items hv
hv:36968
# perl  mymonitor.pl --host 10.0.0.10 --port 3300 --items kx
kx:1070879944

# php ss_get_mysql_stats.php --host 10.0.0.10 --port 3300 --items hv
hv:36968
# php ss_get_mysql_stats.php --host 10.0.0.10 --port 3300 --items kx 
kx:1070911408

# zabbix_get -s 10.0.0.10 -p 10050 -k "MySQL.Bytes-received[3300]"
472339244134

item                        throttle
slave_check              report last_error if io_thread or sql_thread is No

item                       throttle
max_duration             if > 100s, then trigger an alarm
waiter_count             if > 10, then trigger an alarm
idle_blocker_duration    if > 200s, then trigger an alarm

zabbix_get -s cz-test2 -p 10050 -k "MySQL.max_duration[3301]"
max_duration:longest transaction active seconds: max time: 18, thread_id: 4838781, user: [email protected]:59980