脚本自动安装MySQL主从（mycat）和 redis主从服务

最新推荐文章于 2022-05-19 19:53:07 发布

原创

最新推荐文章于 2022-05-19 19:53:07 发布 · 410 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#bash #linux #数据库

本文档详细介绍了如何使用bash脚本来自动安装并配置MySQL的主从复制，接着讲解了Mycat的部署过程，最后阐述了Redis主从服务的设置，适合Linux环境下对数据库管理和自动化部署感兴趣的读者。

Mysql1

#!/bin/bash

#关闭防火墙及SELinux服务
setenforce 0
systemctl stop firewalld

#主机名修改为mysql1
hostnamectl set-hostname mysql1

#配置hosts文件
echo "10.0.100.203  mysql1" >> /etc/hosts
echo "10.0.100.204  mysql2" >> /etc/hosts

#下载expect 和 数据库
yum -y install expect
yum install -y mariadb mariadb-server
systemctl start mariadb
systemctl enable mariadb
expect -c "
spawn /usr/bin/mysql_secure_installation
expect \"Enter current password for root (enter for none):\"
send \"\r\"
expect \"Set root password?\"
send \"y\r\"
expect \"New password:\"
send \"000000\r\"
expect \"Re-enter new password:\"
send \"000000\r\"
expect \"Remove anonymous users?\"
send \"y\r\"
expect \"Disallow root login remotely?\"
send \"n\r\"
expect \"Remove test database and access to it?\"
send \"y\r\"
expect \"Reload privilege tables now?\"
send \"y\r\"
expect eof
"

#修改配置文件
sed -i  -e '16a\log_bin = mysql-bin' /etc/my.cnf.d/mariadb-server.cnf
sed -i  -e '17a\binlog_ignore_db = mysql' /etc/my.cnf.d/mariadb-server.cnf
sed -i  -e '18a\server_id = 12' /etc/my.cnf.d/mariadb-server.cnf

systemctl restart mariadb

mysql -uroot -p000000 -e "grant all privileges  on *.* to root@'%' identified by '000000';"
mysql -uroot -p000000 -e "grant replication slave on *.* to 'user'@'mysql2' identified by '000000';”