监控Mysql
数据库授权用户
GRANT PROCESS,SUPER,REPLICATION CLIENT ON *.* TO user@'127.0.0.1' IDENTIFIED BY 'xxxx';
FLUSH PRIVILEGES;
mysql.sh
#!/bin/bash
# 用户名
MYSQL_USER=''
# 密码
MYSQL_PWD=''
# 主机地址/IP
MYSQL_HOST=''
# 端口
MYSQL_PORT='3306'
# 数据连接
MYSQL_CONN="/usr/bin/mysqladmin -u${MYSQL_USER} -p${MYSQL_PWD} -h${MYSQL_HOST} -P${MYSQL_PORT}"
# 参数是否正确
if [ $# -ne "1" ];then
echo "arg error!"
fi
# 获取数据
case $1 in
Uptime)
result=`${MYSQL_CONN} status|cut -f2 -d":"|cut -f1 -d"T"`
echo $result
;;
Com_update)
result=`${MYSQL_CONN} extended-status |grep -w "Com_update"|cut -d"|" -f3`
echo $result
;;
Slow_queries)
result=`${MYSQL_CONN} status |cut -f5 -d":"|cut -f1 -d"O"`
echo $result
;;
Com_select)
result=`${MYSQL_CONN} extended-status |grep -w "Com_select"|cut -d"|" -f3`
echo $result
;;
Com_rollback)
result=`${MYSQL_CONN} extended-status |grep -w "Com_rollback"|cut -d"|" -f3`
echo $result
;;
Questions)
result=`${MYSQL_CONN} status|cut -f4 -d":"|cut -f1 -d"S"`
echo $result
;;
Com_insert)
result=`${MYSQL_CONN} extended-status |grep -w "Com_insert"|cut -d"|" -f3`
echo $result
;;
Com_delete)
result=`${MYSQL_CONN} extended-status |grep -w "Com_delete"|cut -d"|" -f3`
echo $result
;;
Com_commit)
result=`${MYSQL_CONN} extended-status |grep -w "Com_commit"|cut -d"|" -f3`
echo $result
;;
Bytes_sent)
result=`${MYSQL_CONN} extended-status |grep -w "Bytes_sent" |cut -d"|" -f3`
echo $result
;;
Bytes_received)
result=`${MYSQL_CONN} extended-status |grep -w "Bytes_received" |cut -d"|" -f3`
echo $result
;;
Com_begin)
result=`${MYSQL_CONN} extended-status |grep -w "Com_begin"|cut -d"|" -f3`
echo $result
;;
*)
echo "Usage:$0(Uptime|Com_update|Slow_queries|Com_select|Com_rollback|Questions|Com_insert|Com_delete|Com_commit|Bytes_sent|Bytes_received|Com_begin)"
;;
esac
[root@localhost~]#chmod x mysql.sh
[root@localhost~]#chown -R zabbix.zabbix mysql.sh
userparameter_mysql.conf
UserParameter=mysql.status[*],/opt/zabbix/etc/zabbix_agentd.conf.d/mysql.sh $1
UserParameter=mysql.ping,mysqladmin -uxxx -pxxx -P3306 -h127.0.0.1 ping | grep -c alive
zabbix服务端取值
[root@zabbix-server ~]#zabbix_get -s 客户端ip -k mysql.status[Questions]
2003514
添加监控项
image.png
监控Redis
redis.sh
#!/bin/bash
REDISPATH="/opt/redis/src/redis-cli"
HOST="127.0.0.1"
PORT="6379"
PASS="xxxxx"
if [[ $# == 1 ]];then
case $1 in
cluster)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep cluster|awk -F":" '{print $NF}'`
echo $result
;;
uptime_in_seconds)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep uptime_in_seconds|awk -F":" '{print $NF}'`
echo $result
;;
connected_clients)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep connected_clients|awk -F":" '{print $NF}'`
echo $result
;;
client_longest_output_list)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep client_longest_output_list|awk -F":" '{print $NF}'`
echo $result
;;
client_biggest_input_buf)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep client_biggest_input_buf|awk -F":" '{print $NF}'`
echo $result
;;
blocked_clients)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep blocked_clients|awk -F":" '{print $NF}'`
echo $result
;;
#内存
used_memory)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null |/bin/grep used_memory|awk -F":" '{print $NF}'|awk 'NR==1'`
echo $result
;;
used_memory_human)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep used_memory_human|awk -F":" '{print $NF}'|awk -F'K' '{print $1}'`
echo $result
;;
used_memory_rss)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep used_memory_rss|awk -F":" '{print $NF}'`
echo $result
;;
used_memory_peak)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep used_memory_peak|awk -F":" '{print $NF}'|awk 'NR==1'`
echo $result
;;
used_memory_peak_human)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep used_memory_peak_human|awk -F":" '{print $NF}'|awk -F'K' '{print $1}'`
echo $result
;;
used_memory_lua)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep used_memory_lua|awk -F":" '{print $NF}'`
echo $result
;;
mem_fragmentation_ratio)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep mem_fragmentation_ratio|awk -F":" '{print $NF}'`
echo $result
;;
#rdb
rdb_changes_since_last_save)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep rdb_changes_since_last_save|awk -F":" '{print $NF}'`
echo $result
;;
rdb_bgsave_in_progress)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep rdb_bgsave_in_progress|awk -F":" '{print $NF}'`
echo $result
;;
rdb_last_save_time)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep rdb_last_save_time|awk -F":" '{print $NF}'`
echo $result
;;
rdb_last_bgsave_status)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "rdb_last_bgsave_status" | awk -F':' '{print $2}' | /bin/grep -c ok`
echo $result
;;
rdb_current_bgsave_time_sec)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "rdb_current_bgsave_time_sec" | awk -F':' '{print $2}'`
echo $result
;;
#rdbinfo
aof_enabled)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "aof_enabled" | awk -F':' '{print $2}'`
echo $result
;;
aof_rewrite_scheduled)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "aof_rewrite_scheduled" | awk -F':' '{print $2}'`
echo $result
;;
aof_last_rewrite_time_sec)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "aof_last_rewrite_time_sec" | awk -F':' '{print $2}'`
echo $result
;;
aof_current_rewrite_time_sec)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "aof_current_rewrite_time_sec" | awk -F':' '{print $2}'`
echo $result
;;
aof_last_bgrewrite_status)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "aof_last_bgrewrite_status" | awk -F':' '{print $2}' | /bin/grep -c ok`
echo $result
;;
#aofinfo
aof_current_size)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "aof_current_size" | awk -F':' '{print $2}'`
echo $result
;;
aof_base_size)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "aof_base_size" | awk -F':' '{print $2}'`
echo $result
;;
aof_pending_rewrite)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "aof_pending_rewrite" | awk -F':' '{print $2}'`
echo $result
;;
aof_buffer_length)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "aof_buffer_length" | awk -F':' '{print $2}'`
echo $result
;;
aof_rewrite_buffer_length)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "aof_rewrite_buffer_length" | awk -F':' '{print $2}'`
echo $result
;;
aof_pending_bio_fsync)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "aof_pending_bio_fsync" | awk -F':' '{print $2}'`
echo $result
;;
aof_delayed_fsync)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "aof_delayed_fsync" | awk -F':' '{print $2}'`
echo $result
;;
#stats
total_connections_received)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "total_connections_received" | awk -F':' '{print $2}'`
echo $result
;;
total_commands_processed)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "total_commands_processed" | awk -F':' '{print $2}'`
echo $result
;;
instantaneous_ops_per_sec)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "instantaneous_ops_per_sec" | awk -F':' '{print $2}'`
echo $result
;;
rejected_connections)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "rejected_connections" | awk -F':' '{print $2}'`
echo $result
;;
expired_keys)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "expired_keys" | awk -F':' '{print $2}'`
echo $result
;;
evicted_keys)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "evicted_keys" | awk -F':' '{print $2}'`
echo $result
;;
keyspace_hits)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "keyspace_hits" | awk -F':' '{print $2}'`
echo $result
;;
keyspace_misses)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "keyspace_misses" | awk -F':' '{print $2}'`
echo $result
;;
pubsub_channels)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "pubsub_channels" | awk -F':' '{print $2}'`
echo $result
;;
pubsub_channels)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "pubsub_channels" | awk -F':' '{print $2}'`
echo $result
;;
pubsub_patterns)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "pubsub_patterns" | awk -F':' '{print $2}'`
echo $result
;;
latest_fork_usec)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "latest_fork_usec" | awk -F':' '{print $2}'`
echo $result
;;
connected_slaves)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "connected_slaves" | awk -F':' '{print $2}'`
echo $result
;;
master_link_status)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "master_link_status"|awk -F':' '{print $2}'|/bin/grep -c up`
echo $result
;;
master_last_io_seconds_ago)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "master_last_io_seconds_ago"|awk -F':' '{print $2}'`
echo $result
;;
master_sync_in_progress)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "master_sync_in_progress"|awk -F':' '{print $2}'`
echo $result
;;
slave_priority)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "slave_priority"|awk -F':' '{print $2}'`
echo $result
;;
#cpu
used_cpu_sys)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "used_cpu_sys"|awk -F':' '{print $2}'`
echo $result
;;
used_cpu_user)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "used_cpu_user"|awk -F':' '{print $2}'`
echo $result
;;
used_cpu_sys_children)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "used_cpu_sys_children"|awk -F':' '{print $2}'`
echo $result
;;
used_cpu_user_children)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "used_cpu_user_children"|awk -F':' '{print $2}'`
echo $result
;;
*)
echo "argu error"
;;
esac
#db0:key
elif [[ $# == 2 ]];then
case $2 in
keys)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null| /bin/grep -w "$1" | /bin/grep -w "keys" | awk -F'=|,' '{print $2}'`
echo $result
;;
expires)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null| /bin/grep -w "$1" | /bin/grep -w "expires" | awk -F'=|,' '{print $4}'`
echo $result
;;
avg_ttl)
result=`$REDISPATH -p $PORT -a $PASS info 2>/dev/null|/bin/grep -w "$1"| /bin/grep -w "$1" | /bin/grep -w "avg_ttl" | awk -F'=|,' '{print $6}'`
echo $result
;;
*)
echo "argu error" ;;
esac
fi
userparameter_redis.conf
UserParameter=redis_status[*],/opt/zabbix/zabbix_agent/scripts/redis.sh $1 $2
添加监控项
image.png
网友评论