mysql会自动建立主_mysql 一主多从半自动搭建

linux：CentOS Linux release 7.8.2003 (Core)

mysql：Ver 8.0.18 for el7 on x86_64 (MySQL Community Server - GPL)

前提条件：中控机和安装mysql服务器之间都相互配置ssh，防火墙关闭

一、搭建过程

1、中控机上传文件

cd /shell/installmanyhost

hostnameip.txt installmanymysql.sh my.cnf mysqld mysqlinstall.sh mysql.local

2、安装

sh installmanymysql.sh

3、从节点执行

sh mysqlmasterslave.sh 192.168.17.175 192.168.17.176

二、脚本内容

1、cat hostnameip.txt

192.168.17.175 mysql01

192.168.17.176 mysql02

192.168.17.177 mysql03

2、cat mysql.local

/usr/local/mysql/bin/mysql -uroot -pXbl@mysql817

3、cat installmanymysql.sh

#!/bin/bash

echo ' '

echo ' '

echo ************开始执行**************

set -e

cat /shell/installmanyhost/hostnameip.txt|awk 'NR>0 {print $2}'|while read hostname

do

echo *****$hostname*******

yes|scp /soft/mysql-8.0.18-el7-x86_64.tar.gz $hostname:/soft 1>/dev/null 2>/dev/null

if [ $? != 0 ]; then

echo $hostname拷贝mysql失败！

exit

else

echo $hostname拷贝mysql成功！

fi

yes|scp /shell/installmanyhost/my.cnf $hostname:/soft 1>/dev/null 2>/dev/null

if [ $? != 0 ]; then

echo $hostname拷贝my.cnf失败！

exit

else

echo $hostname拷贝my.cnf成功！

fi

yes|scp /shell/installmanyhost/mysqld $hostname:/soft 1>/dev/null 2>/dev/null

if [ $? != 0 ]; then

echo $hostname拷贝mysqld失败！

exit

else

echo $hostname拷贝mysqld成功！

fi

yes|scp /shell/installmanyhost/mysql.local $hostname:/usr/bin 1>/dev/null 2>/dev/null

if [ $? != 0 ]; then

echo $hostname拷贝mysql.local失败！

exit

else

echo $hostname拷贝mysql.local成功！

fi

ssh -tt $hostname < /shell/installmanyhost/mysqlinstall.sh 1>/dev/null 2>/dev/null

if [ $? != 0 ]; then

echo $hostname安装mysql失败！

exit

else

echo $hostname安装mysql成功！

fi

done

echo ************执行结束***************

echo "bye"

echo ' '

echo ' '

4、cat mysqlinstall.sh

#!/bin/bash

cd /soft

tar -zxvf mysql-8.0.18-el7-x86_64.tar.gz

rpm -e --nodeps mariadb-libs-5.5.65-1.el7.x86_64

service mysqld stop

sleep 10

rm -rf /usr/local/mysql 1>/dev/null 2>/dev/null

rm -rf /data 1>/dev/null 2>/dev/null

mkdir /usr/local/mysql -p

mv mysql-8.0.18-el7-x86_64/* /usr/local/mysql

mkdir -p /data/mysql/mysql

mkdir -p /data/mysql/logs

mysql_user=`cat /etc/passwd |grep mysql|wc -l`

if [ 1 -eq $mysql_user ];then

echo "Mysql用户存在"

else

echo -e "Mysql用户不存在，开始添加mysql用户"

useradd mysql

echo -e "添加mysql用户成功！！！"

fi

chown -R mysql:mysql /data/mysql

chown -R mysql:mysql /usr/local/mysql/

/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/mysql/

yes|cp /soft/mysqld /etc/init.d/mysqld

yes|cp /soft/my.cnf /etc/my.cnf

chmod 775 /etc/init.d/mysqld

chkconfig --add mysqld

chkconfig mysqld on

echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile

source /etc/profile

touch /data/mysql/logs/mysql-error.log

chown mysql:mysql /data/mysql/logs/mysql-error.log

#newserverid=ip a | grep ens33| awk '/inet/{ print $2}'|awk -F '/' '{print $1}'|awk -F '.' '{print $NF}'

newserverid=$(ip addr | awk '/^[0-9]+: / {}; /inet.*global/ {print gensub(/(.*)\/(.*)/, "\\1", "g", $2)}' |awk -F '.' '{print $4}')

sed -i 's/server_id=313306/server_id='"$newserverid"'3306/' /etc/my.cnf

service mysqld start

mysql_pass=`cat /data/mysql/logs/mysql-error.log|grep password | awk '/root@localhost:/{print $13}'`

#####修改mysql密码以及授权slave########

mysql -uroot -p$mysql_pass --connect-expired-password <