[root@VM_0_5_centos shell]# cat mysql-master.sh
#!/bin/bash
yum -y install mariadb mariadb-server
sed -i '10i\server-id=1' /etc/my.cnf
sed -i '11i\log-bin=mysql-bin' /etc/my.cnf
sed -i '12i\binlog-ignore-db=information_schema' /etc/my.cnf
sed -i '13i\binlog-ignore-db=performance_schema' /etc/my.cnf
sed -i '14i\binlog-ignore=mysql' /etc/my.cnf
systemctl start mariadb
mysql -e "grant all on *.* to slave@10.0.0.46 identified by '123';"
mysql -e "flush privileges;"
shell-mysql-master
最新推荐文章于 2023-11-24 09:28:04 发布