Shell编程实战-服务的监控

约定不等于承诺〃 2023-07-06 06:11 24阅读 0赞

# 监控web和数据库 #

监测mysql数据库异常：  
安装数据库并启动：

yum install mariadb* -y
    systemctl start mariadb

# 一、 首先采用端口监控的方式： #

## 1.1在服务器**本地监控**端口的命令有：`netstat` `ss` `lsof` ##

1.`netstat`：

[root@localhost ~]# netstat -antlupe | grep 3306
    tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN      27         151465     7676/mysqld
    [root@localhost ~]# netstat -antlupe | grep 3306 | wc -l
    1
    [root@localhost ~]# netstat -antlupe | grep 3306 | awk -F "[ :]+" '{print $5}'
    3306

2.`ss`:

[root@localhost ~]# ss -antlupe | grep mysql
    tcp    LISTEN     0      50                     *:3306                  *:*      users:(("mysqld",7676,14)) uid:27 ino:151465 sk:ffff880024ab8780 <->
    [root@localhost ~]# ss -antlupe | grep mysql | wc -l
    1

3.`lsof`:

使用此命令时若报错需要先安装：

[root@localhost ~]# yum install lsof-4.87-4.el7.x86_64 -y

使用此命令监控：

[root@localhost ~]# lsof -i tcp:3306
    COMMAND  PID  USER   FD   TYPE DEVICE SIZE/OFF NODE NAME
    mysqld  7676 mysql   14u  IPv4 151465      0t0  TCP *:mysql (LISTEN)
    [root@localhost ~]# lsof -i tcp:3306 | wc -l
    2

## 1.2 远程监控： ##

**nmap**远程监控命令：  
若提示没有该命令需要安装：

yum install nmap-6.40-7.el7.x86_64 -y

监控：

[root@localhost ~]# nmap 172.25.254.63 -p 80
    
    Starting Nmap 6.40 ( http://nmap.org ) at 2020-02-16 11:36 EST
    Nmap scan report for 172.25.254.63
    Host is up (0.00013s latency).
    PORT   STATE SERVICE
    80/tcp open  http
    MAC Address: A8:1E:84:18:2A:23 (Unknown)
    
    Nmap done: 1 IP address (1 host up) scanned in 13.43 seconds
    [root@localhost ~]# nmap 172.25.254.63 -p 80 | grep open			#过滤open关键字
    80/tcp open  http
    [root@localhost ~]# nmap 172.25.254.63 -p 80 | grep open |wc -l
    1

**telnet**远程监控命令：  
若提示没有该命令需要安装：

yum install telnet-0.17-60.el7.x86_64 -y

监控：

[root@localhost ~]# telnet 172.25.254.116 3306
    Trying 172.25.254.116...
    Connected to 172.25.254.116.
    Escape character is '^]'.
    IHost '172.25.254.116' is not allowed to connect to this MariaDB serverConnection closed by foreign host.
    [root@localhost ~]# telnet 172.25.254.116 3306 | grep Connected
    Connected to 172.25.254.116.
    Connection closed by foreign host.
    [root@localhost ~]# telnet 172.25.254.116 3306 | grep Connected | wc -l
    Connection closed by foreign host.
    1

# 二、采用进程监控的方式 #

对服务器进程或者进程数进行监控（适合本地服务器）

[root@localhost ~]# ps -ef | grep mysql
    mysql     8105     1  0 11:34 ?        00:00:00 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
    mysql     8263  8105  0 11:34 ?        00:00:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock
    root      8437  2285  0 11:46 pts/1    00:00:00 grep --color=auto mysql
    [root@localhost ~]# ps -ef | grep mysql |wc -l
    3
    [root@localhost ~]# ps -ef | grep mysql |grep -v grep|wc -l					#将grep的进程过滤掉
    2

# 三、开发监控Mysql数据库的脚本 #

编写脚本：

[root@localhost mnt]# cat check_mysql.sh 
    #!/bin/bash
    if [ "`netstat -antlupe | grep 3306 | awk -F "[ :]+" '{print $5}'`" = "3306" ];then
    	echo "MySQL is running."
    else
    	echo "MySQL is stopping"
    	/etc/init.d/mysqld start
    fi

测试：

[root@localhost mnt]# systemctl start mariadb
    [root@localhost mnt]# sh check_mysql.sh 
    MySQL is running.
    [root@localhost mnt]# systemctl stop mariadb
    [root@localhost mnt]# sh check_mysql.sh 
    MySQL is stopping

也可使用该校本与其他命令相结合