1+x云计算中级--脚本搭建读写分离
脚本搭建数据库读写分离(3台机器)
今天花费了几个小时写了一个小脚本，内容有点不是很美观，新手脚本，贴出来仅供参考，各路大神如果有什么建议，私聊或评论，谢谢！
使用前准备：
① 配置三台主机的IP
② 上传脚本和Mycat安装包和gpmall-repo包(放置在root目录下)
③ 上传read_write.sh脚本
④ chmod +x read_write.sh
⑤ ./read_write.sh运行脚本等待安装欢迎优化！！！
#!/bin/bash
#Author: willian_1999y@163
#date: 2021-7-17
#version: 1.0
#数据库读写分离集群脚本(三台集群)
#环境变量
#ip变量,使用时请修改IP
NODE1_IP=192.168.17.21
NODE2_IP=192.168.17.22
NODE3_IP=192.168.17.23
HOST_ONE='db1'
HOST_TWO='db2'
HOST_THREE='mycat'
#配置主机名和关闭防火墙、selinux、主机名映射
change_host(){
hostnamectl set-hostname $HOST_ONE
setenforce 0
getenforce
sed -i 's/SELINUX=.*/SELINUX=disabled/g' /etc/selinux/config
systemctl stop firewalld;systemctl disable firewalld &> /dev/null
iptables -F;iptables -X;iptables -Z;iptables-save &>/dev/null;iptables -L &> /root/installlog.log
cat >/etc/hosts<<EOF
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
$NODE1_IP $HOST_ONE
$NODE2_IP $HOST_TWO
$NODE3_IP $HOST_THREE
EOF
ssh root@192.168.17.22 "
hostnamectl set-hostname $HOST_TWO
setenforce 0
getenforce
sed -i 's/SELINUX=.*/SELINUX=disabled/g' /etc/selinux/config
systemctl stop firewalld;systemctl disable firewalld &> /dev/null
iptables -F;iptables -X;iptables -Z;iptables-save &> /root/installlog.log;iptables -L &> /root/installlog.log
mv /etc/yum.repos.d/* /media
"
ssh root@192.168.17.23 "
hostnamectl set-hostname $HOST_THREE
setenforce 0
getenforce
sed -i 's/SELINUX=.*/SELINUX=disabled/g' /etc/selinux/config
systemctl stop firewalld;systemctl disable firewalld &> /dev/null
iptables -F;iptables -X;iptables -Z;iptables-save &> /root/installlog.log;iptables -L &> /root/installlog.log
mv /etc/yum.repos.d/* /media
"
scp /etc/hosts @$NODE2_IP:/etc/hosts &>/dev/null;scp /etc/hosts @$NODE3_IP:/etc/hosts &>/dev/null
}
yum_install(){
mv -f /etc/yum.repos.d/* /media
mkdir -p /mnt/centos
cp -rf /root/gpmall-repo /mnt
mount /dev/sr0 /mnt/centos &> /dev/null
cat >/etc/yum.repos.d/local.repo<<EOF
[base]
name=centos
baseurl=file:///mnt/centos
gpgcheck=0
enabled=1
[gpmall]
name=gpmall
baseurl=file:///mnt/gpmall-repo
gpgcheck=0
enabled=1
EOF
#安装vsftpd，配置ftp源
yum clean all &>/dev/null;yum install -y vsftpd &> /root/installlog.log
echo "anon_root=/mnt" >> /etc/vsftpd/vsftpd.conf
systemctl start vsftpd;systemctl enable vsftpd &> /root/installlog.log
sed -i 's#file:///mnt#ftp://192.168.17.21#g' /etc/yum.repos.d/local.repo
yum clean all &>/dev/null
repolist=`yum repolist | grep repolist | awk '{print $2}'`
if [ $? -eq 0 ];then
echo -e "\033[32m ######### yum仓库完成,总共有安装包:$repolist个 ######### \033[0m"
sleep 2
else
echo -e "\033[31m ######### yum仓库搭建失败，请检查... ######### \033[0m"
exit 1
fi
scp /etc/yum.repos.d/local.repo $NODE2_IP:/etc/yum.repos.d/ &>/dev/null
scp /etc/yum.repos.d/local.repo $NODE3_IP:/etc/yum.repos.d/ &>/dev/null
scp /root/Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz 192.168.17.23:/root/ &>/dev/null
ssh root@$NODE2_IP "
yum clean all &>/dev/null;yum repolist &>/dev/null
"
ssh root@$NODE3_IP '
yum clean all &>/dev/null;yum repolist &>/dev/null
yum install -y MariaDB-client &>/dev/null
yum install -y java-1.8.0-openjdk java-1.8.0-openjdk-devel &>/dev/null
yum install -y net-tools &>/dev/null
echo -e "\033[32m ###########+ 已安装mariadb客户端 +########### \033[0m"
'
}
#主服务器安装数据库
install_mariadb(){
sleep 2
echo -e "\033[034m ######### 正在安装MariaDB服务,请稍等... ######### \033[0m"
sleep 1
yum install -y mariadb-server mariadb &>/dev/null
sleep 1
systemctl start mariadb
cat >>/etc/my.cnf<<EOF
[mysqld]
log_bin = mysql-bin
binlog_ignore_db = mysql
server_id = 21
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
EOF
sleep 1
systemctl restart mariadb;systemctl enable mariadb &>/dev/null
mysqladmin -uroot password '123456'
if [ $? -eq 0 ];then
echo -e "\033[37m ++重启主服务器数据库++++++++++++++++++++++++++\033[0m\033[32mOK \033[0m"
sleep 2
else
echo -e "\033[37m ++重启主服务器数据库++++++++++++++++++++++++++\033[0m\033[31mNO \033[0m"
exit 1
fi
echo -e "\033[35m ######### 正在配置主服务器请稍等.... ######### \033[0m"
sleep 2
mysql -uroot -p123456<<EOF
grant all privileges on *.* to root@'%' identified by "123456";
grant replication slave on *.* to 'user'@'db2' identified by '123456';
FLUSH PRIVILEGES;
CREATE DATABASE IF NOT EXISTS test;
use test;
CREATE TABLE IF NOT EXISTS company(id int not null primary key,name varchar(50),addr varchar(255));
insert into company values(3,"facebook","usa");
exit
EOF
if [ $? -eq 0 ];then
echo -e "\033[32m ######### 主服务器配置成功 ######### \033[0m"
sleep 2
else
echo -e "\033[31m ######### 主服务器配置错误 ######### \033[0m"
exit 1
fi
sleep 3
#配置从服务器数据库
echo -e "\033[35m ######### 正在配置从服务器,请稍等... ######### \033[0m"
sleep 2
ssh root@$NODE2_IP "
yum install mariadb-server mariadb -y &>/dev/null
systemctl start mariadb
mysqladmin -uroot password '123456'
cat >>/etc/my.cnf<<EOF
[mysqld]
server_id = 22
EOF
mysql -uroot -p123456<<EOF
change master to master_host='$NODE1_IP',master_user='user',master_password='123456';
FLUSH PRIVILEGES;
start slave;
show slave status\G;
exit
clear
systemctl restart mariadb;systemctl enable mariadb &>/dev/null
EOF
"
if [ $? -eq 0 ];then
sleep 2
echo -e "\033[32m ######### 从服务器配置完成 ######### \033[0m"
sleep 1
echo -e "\033[33m ######### 查看从服务器中的数据库 ######### \033[0m"
ssh root@$NODE2_IP "mysql -uroot -p123456 -e 'show databases;'"
else
echo -e "\033[31m ######### 从服务器配置错误 ######### \033[0m"
exit 1
fi
}
#安装mycat中间件服务
install_mycat(){
echo -e "\033[33m ######### 正在安装Mycat服务... ######### \033[0m"
sleep 2
#修改Mycat服务配置文件
ssh root@$NODE3_IP "
tar zxf /root/Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz -C /usr/local
chmod -R 777 /usr/local/mycat/
echo export MYCAY_HOME=/usr/local/mycat/ >> /etc/profile
source /etc/profile
cat >/usr/local/mycat/conf/schema.xml<<EOF
<?xml version='1.0'?>
<!DOCTYPE mycat:schema SYSTEM 'schema.dtd'>
<mycat:schema xmlns:mycat='http://io.mycat/'>
<schema name='USERDB' checkSQLschema='true' sqlMaxLimit='100' dataNode='dn1'></schema>
<dataNode name='dn1' dataHost='localhost1' database='test' />
<dataHost name='localhost1' maxCon='1000' minCon='10' balance='3' dbType='mysql' dbDriver='native' writeType='0' switchType='1' slaveThreshold='100'>
<heartbeat>select user()</heartbeat>
<writeHost host='hostM1' url='192.168.17.21:3306' user='root' password='123456'>
<readHost host='hostS1' url='192.168.17.22:3306' user='root' password='123456' />
</writeHost>
</dataHost>
</mycat:schema>
EOF
chown root:root /usr/local/mycat/conf/schema.xml
cat >/usr/local/mycat/conf/server.xml<<EOF
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE mycat:server SYSTEM 'server.dtd'>
<mycat:server xmlns:mycat='http://io.mycat/'>
<system>
<property name='useSqlStat'>0</property>
<property name='useGlobleTableCheck'>0</property>
<property name='sequnceHandlerType'>2</property>
<property name='processorBufferPoolType'>0</property>
<property name='handleDistributedTransactions'>0</property>
<property name='useOffHeapForMerge'>1</property>
<property name='memoryPageSize'>1m</property>
<property name='spillsFileBufferSize'>1k</property>
<property name='useStreamOutput'>0</property>
<property name='systemReserveMemorySize'>384m</property>
<property name='useZKSwitch'>true</property>
</system>
<user name='root'>
<property name='password'>123456</property>
<property name='schemas'>USERDB</property>
</user>
</mycat:server>
EOF
bash /usr/local/mycat/bin/mycat start
bash /usr/local/mycat/bin/mycat status &>/dev/null
clear
netstat -tnlp | grep 9066;netstat -tnlp | grep 8066
"
#验证阶段
sleep 1
echo -e "\033[33m ######### 正在验证Mycat服务是否正常... ######### \033[0m"
sleep 2
ssh root@$NODE3_IP "mysql -h127.0.0.1 -P9066 -uroot -p123456 -e 'show @@datasource;'"
if [ $? -eq 0 ];then
echo -e "\033[32m ######### mycat服务运行正常 ######### \033[0m"
sleep 2
else
echo -e "\033[31m ######### mycat服务运行不正常 ######### \033[0m"
exit 1
fi
}
#主运行程序
echo -e "\033[35m ######### 正在配置数据库读写分离,请稍等....(大概需要3分钟) ######### \033[0m"
sleep 1
change_host
yum_install
install_mariadb
install_mycat
sleep 2
if [ $? -eq 0 ];then
echo -e "\033[32m ######### 读写分离配置完成,请再次检查... ######### \033[0m"
exit 0
else
echo -e "\033[31m ######### 读写分离配置出错哦 ######### \033[0m"
exit 1
fi
B站已上传运行过程视频，请移步观看(看到这里觉得还不错记得三连哦 😃 )
本文来自博客园，作者：knsec，转载请注明原文链接：https://www.cnblogs.com/knsec-cnblogs/p/16582270.html
