记录基于docker+mysql8.0的资源监控工具

之前的资源监控工具是基于本地的mysql，本地部署相对麻烦，于是尝试基于docker的mysql，调试监控工具，记录一下。

拉取镜像，设置挂载配置

# 拉取镜像
docker pull mysql:8.0.26

# 在宿主机上创建对应的文件夹用于容器挂载，易于管理MySQL配置文件等,创建mysql目录并进入创建conf，data两个目录
cd /home
mkdir -p mysql && cd $_ && mkdir {conf,data}

#在conf 目录创建my.cnf
cd /home/mysql/conf
vim my.cnf

my.cnf文件

# Copyright (c) 2017, Oracle and/or its affiliates. All rights reserved.
 
#
 
# This program is free software; you can redistribute it and/or modify
 
# it under the terms of the GNU General Public License as published by
 
# the Free Software Foundation; version 2 of the License.
 
#
 
# This program is distributed in the hope that it will be useful,
 
# but WITHOUT ANY WARRANTY; without even the implied warranty of
 
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 
# GNU General Public License for more details.
 
#
 
# You should have received a copy of the GNU General Public License
 
# along with this program; if not, write to the Free Software
 
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
 
#
 
# The MySQL Server configuration file.
 
#
 
# For explanations see
 
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
 
[mysqld]
 
pid-file = /var/run/mysqld/mysqld.pid
 
socket = /var/run/mysqld/mysqld.sock
 
datadir = /var/lib/mysql
 
secure-file-priv= NULL
 
# Disabling symbolic-links is recommended to prevent assorted security risks
 
symbolic-links=0
 
# Custom config should go here
 
!includedir /etc/mysql/conf.d/
 
max_connections=1000
wait_timeout=120
interactive_timeout=300
 
lower_case_table_names=1

创建容器

# --restart=unless-stopped 表示容器退出时总是重启，但是不考虑docker守护进程运行时就已经停止的容器
# -d 后台运行
# --name 命名
# -p 端口映射 宿主机:容器
# -v 绑定一个数据卷
# -e 指定容器内的环境变量 MYSQL_ROOT_PASSWORD mysql密码

docker run --restart=unless-stopped -d --name mysql -p 3307:3306 -v /home/mysql/conf/my.cnf:/etc/mysql/my.cnf -v /home/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=root mysql:8.0.26

进入容器

docker exec -it mysql /bin/bash

mysql -uroot -p
# 密码是创建容器时，-e MYSQL_ROOT_PASSWORD=root 
root

use mysql

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
FLUSH PRIVILEGES;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '新密码';

重写了一版简单版的服务器资源监控的脚本，上传到gitee了
https://gitee.com/witp/Resources_Monitoring

定时任务

crontab -e

# 每天凌晨3点执行
# centos7默认安装了python2需要安装配置好python3环境
0 0 3 * * ? /usr/local/bin/python3 -u  脚本路径.py