mysql的主从配置+shell脚本的检测和邮箱报警(版本centos7)
1.关闭防火墙
systemctl stop firewalld
setenforce 0
2.安装mysql
yum -y install mariadb mariadb-server
3.mysql的主从配置(主)
vim /etc/my.cnf
[mysqld]
server-id=1
log-bin=mysql-bin
systemctl start mariadb
进入mysql中,授权一个从连接主的用户tom
grant all on *.* to tom@'%' identified
原创
2020-06-15 22:51:53 ·
256 阅读 ·
0 评论