![](https://img-blog.csdnimg.cn/20190927151053287.png?x-oss-process=image/resize,m_fixed,h_224,w_224)
MySQL
MySQL
实习生2020
这个作者很懒,什么都没留下…
展开
-
prometheus 监控MySQL数据库
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]原创 2021-01-29 16:51:23 · 316 阅读 · 0 评论 -
开源的数据库监控平台
原创 2020-12-31 13:43:43 · 1149 阅读 · 1 评论 -
ProxySQL
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...原创 2020-07-21 15:43:25 · 315 阅读 · 0 评论 -
mysql5.7-centos7-MHA部署
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 ...原创 2020-07-21 10:22:21 · 364 阅读 · 0 评论