品牌的mysql数据库监控_MySQL数据库监控

待我称王封你为后i 2023-01-11 13:20 143阅读 0赞

MySQL轻量级数据库监控，包含：监听端口、连通性、MySQL复制以及浮动IP(特殊要求)进行监控。

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

\#\#  mysql\_monitor.sh

\#\#

\#\#  \#\#

\#\# Version 1.0  \#\#

\#\#  get\_listener

获取监听端口信息  \#\#

\#\#  get\_connect  测试数据库是否可连接  \#\#

\#\#  get\_cp\_stats

检查Mysql复制信息  \#\#

\#\#  get\_ip  检查浮动IP  \#\#

\#\#  \#\#

\#\# Version 2.0  get\_cp\_stats(Master\_Log\_File、Read\_Master\_Log\_Pos)

\#\#

\#\#  \#\#

\#\# Process:

1.get\_listener(Yes)->get\_connect(Yes)->get\_cp\_stats

\#\#

\#\#  (No)

\->Error  (No )->Error  \#\#

\#\#  2.get\_ip  \#\#

\#\#  \#\#

\#\# Email:mr.zhangnai@gmail.com  \#\#

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

\#!/bin/bash

\#\#sh mysql\_monitor\_v2.sh as mysql

\#\#日志目录

monitor\_log="/tmp/mysql\_monitor.log"

\#当前时间

now=\`date +"%Y-%m-%d %H:%M:%S"\`

\#浮动IP个数

IPCount=2

\#\#获取监听端口信息

get\_listener()\{

PORT=\`netstat -na|grep "LISTEN"|grep "3306"|awk -F\[:" "\]+

'\{print $5\}'\`

if \[ "$PORT" == "3306" \];then

echo "Yes, MYSQL Listener is running

normal.">>$monitor\_log

get\_connect

else

echo "Error! MYSQL Listener is not

running!";>>$monitor\_log

\#\#检测数据库是否可以连接

get\_connect()\{

/usr/bin/mysql -u root -p123456  -e "show

databases;" >/dev/null 2>&1

if \[ $? -eq 0 \]; then

echo "Yes, MYSQL DB is

running normal.">>$monitor\_log

get\_cp\_stats

else echo "Error! MYSQL DB is not

running!">>$monitor\_log

\#\#检查复制状态

get\_cp\_stats()\{

StatFile="slave\_status.tmp"

MasterFile="master\_status.tmp"

echo "show slave status\\G" | mysql -u root -p123456 >

$StatFile

IoStat=\`cat $StatFile | grep Slave\_IO\_Running | awk '\{print

$2\}'\`

SqlStat=\`cat $StatFile | grep Slave\_SQL\_Running | awk '\{ print

$2\}'\`

Master\_Log\_File=\`cat $StatFile | grep " Master\_Log\_File" | awk

'\{print $2\}'\`

Read\_Master\_Log\_Pos=\`cat $StatFile | grep Read\_Master\_Log\_Pos

| awk '\{ print $2\}'\`

if \[ $IoStat == 'No' \]; then

echo "Error! IOSTAT is

No!">>$monitor\_log

else  echo "Yes, IOSTAT is

Yes.">>$monitor\_log

if \[ "$SqlStat" == 'No' \]; then

echo "Error! SQLSTAT is No!">>$monitor\_log

else  echo "Yes, SQLSTAT is

Yes.">>$monitor\_log

\#\#ssh到master服务器

ssh mysql@192.168.204.131 'echo "show master status\\G" | mysql

\-u root -p123456' >$MasterFile

\#获取File和Position信息

File=\`cat $MasterFile | grep File | awk '\{ print $2\}'\`

Position=\`cat $MasterFile | grep Position | awk '\{ print

$2\}'\`

\#\#比较主备的file文件是否一致

if \[ $Master\_Log\_File == $File \]; then

echo "Yes, File is same as

master.">>$monitor\_log

else  echo "Error! File is not same as

master!">>$monitor\_log

\#\#比较Position ID是否一致

if \[ $Read\_Master\_Log\_Pos == $Position \]; then

echo "Yes, Pos is same as

master.">>$monitor\_log

else  echo "Error! Pos is not same as

master!">>$monitor\_log

rm -f $StatFile

rm -f $MasterFile

\#\#获取浮动IP信息

get\_ip()\{

/sbin/ip ad | grep bond0 | awk '\{print $2\}' |cut -d : -f2|grep

\-v '^$'>tmp.log

COUNT=$(cat tmp.log|wc -l)

if \[ $COUNT -lt $IPCount \]; then echo "Error! bond0 ip is not

running!">>$monitor\_log

else echo "Yes, bond0 ip is running

normal.">>$monitor\_log

rm -f tmp.log

echo $now>>$monitor\_log

get\_listener

get\_ip

echo "">>$monitor\_log

脚本输出样例：

2013-07-31 01:41:33

Yes, MYSQL Listener is running

normal.

Yes, MYSQL DB is running

normal.

Yes, IOSTAT is Yes.

Yes, SQLSTAT is Yes.

Yes, File is same as

master.

Yes, Pos is same as master.

Error! bond0 ip is not

running!

2013-07-31 01:47:36

Yes, MYSQL Listener is running

normal.

Yes, MYSQL DB is running

normal.

Yes, IOSTAT is Yes.

Yes, SQLSTAT is Yes.

Yes, File is same as

master.

Yes, Pos is same as master.

Error! bond0 ip is not

running!

2013-07-31 02:00:01

Yes, MYSQL Listener is running

normal.

Yes, MYSQL DB is running

normal.

Yes, IOSTAT is Yes.

Yes, SQLSTAT is Yes.

Yes, File is same as

master.

Yes, Pos is same as master.

Error! bond0 ip is not

running!

品牌的mysql数据库监控_MySQL数据库监控

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Zabbix监控Mysql数据库性能

相关 prometheus+grafana对数据库mysql监控

相关 Mysql数据库数据实时监控之canal

相关 MySQL监控：MySQL监控指标、MySQL监控界面实现、Python监控MySQL

相关品牌的mysql数据库监控_MySQL数据库监控

相关 MySQL数据库可用性监控脚本

相关 zabbix实现mysql数据库的监控

相关 zabbix监控mysql数据库

相关数据库性能监控工具 Spotlight on MySQL

相关【MySQL】数据库监控方案（Nagios）