xiaoenxiaoen的专栏

1、MySQL数据库安装exporter安装mysqld_exporter由于mysqld_exporter需要连接到MySQL，创建用户并赋予所需的权限GRANT REPLICATION CLIENT,PROCESS ON *.* TO 'mysql_monitor'@'localhost' identified by 'mysql_monitor';GRANT SELECT ON *.* TO 'mysql_monitor'@'localhost';修改配置文件[client]

wget https://github.com/sysown/proxysql/releases/download/v2.0.13/proxysql-2.0.13-1-centos7.x86_64.rpm[root@mysqldb2 ~]# rpm -ivh proxysql-2.0.13-1-centos7.x86_64.rpm warning: proxysql-2.0.13-1-centos7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key...

1、实验环境介绍OS：CentOS Linux release 7.6.1810 (Core)db:5.7.30 MySQL Community Server (GPL)ip hostname 172.168.1.178 mysqldb1 master Node 172.168.1.179 mysqldb2 slave1 Node 172.168.1.180 mysqldb3 slave2 ...