mha脚本搭建
/搭建*********/
linux版本：CentOS Linux release 7.8.2003 (Core)
mysql版本：Ver 8.0.18 for el7 on x86_64 (MySQL Community Server - GPL)
192.168.17.170 linuxsinglemysql 中控机
192.168.17.177 mysql03 从2
192.168.17.175 mysql01 主
192.168.17.176 mysql02 从1
192.168.17.169 mysqlmanager mha管理机
一、搭建过程
1、配置ssh互信
2、中控机/shell/installmanyhost下文件
hostnameimport.sh hostnameimport.txt hostnameip.txt installmanymysql.sh mha_conf.cnf my.cnf mysqld mysqlinstall.sh mysql.local mysqlmasterslave.sh
3、中控机执行
sh installmanymysql.sh
4、mysql02，mysql03执行
sh mysqlmasterslave.sh 192.168.17.175 192.168.17.176
sh mysqlmasterslave.sh 192.168.17.175 192.168.17.177
/脚本内容*************/
1、cat hostnameimport.sh
!/bash/shell
cat /shell/installmanyhost/hostnameimport.txt|awk '{print $1" "$2}'|while read hostip hostname
cat /shell/installmanyhost/hostnameimport.txt|grep -v ^$ |awk '{print $1, $2}'|while read hostip hostname
cat /shell/installmanyhost/hostnameimport.txt |awk '{print $1, $2}'|while read hostip hostname
do
if [ "$hostip" == "" ]; then
continue
else
hostcount=`cat /etc/hosts|grep $hostip|wc -l`
if [ $hostcount -gt 0 ] ;then
echo exitshost
else
echo $hostip $hostname >> /etc/hosts
fi
fi
done
2、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 /soft/mha4mysql-node-0.58.tar.gz $hostname:/soft 1>/dev/null 2>/dev/null
if [ $? != 0 ]; then
echo $hostname拷贝mha4mysql-node失败！
exit
else
echo $hostname拷贝mha4mysql-node成功！
fi
yes|scp /soft/mha4mysql-manager-0.58.tar.gz $hostname:/soft 1>/dev/null 2>/dev/null
if [ $? != 0 ]; then
echo $hostname拷贝mha4mysql-manager失败！
exit
else
echo $hostname拷贝mha4mysql-manager成功！
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/mha_conf.cnf $hostname:/soft 1>/dev/null 2>/dev/null
if [ $? != 0 ]; then
echo $hostname拷贝mha_conf.cnf失败！
exit
else
echo $hostname拷贝mha_conf.cnf成功！
fi
yes|scp /shell/installmanyhost/hostnameimport.txt $hostname:/soft 1>/dev/null 2>/dev/null
if [ $? != 0 ]; then
echo $hostname拷贝hostnameimport失败！
exit
else
echo $hostname拷贝hostnameimport成功！
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 ' '
3、cat mysqlinstall.sh
!/bin/bash
cd /soft
cat /shell/installmanyhost/hostnameimport.txt|awk '{print $1" "$2}'|while read hostip hostname
cat /shell/installmanyhost/hostnameimport.txt|grep -v ^$ |awk '{print $1, $2}'|while read hostip hostname
cat /soft/hostnameimport.txt |awk '{print $1, $2}'|while read hostip hostname
do
if [ "$hostip" == "" ]; then
continue
else
hostcount=`cat /etc/hosts|grep $hostip|wc -l`
if [ $hostcount -eq 1 ] ;then
echo exitshost
else
echo $hostip $hostname >> /etc/hosts
fi
fi
done
hostnamecheck=hostname
if [ "$hostnamecheck" != 'mysqlmanager' ]; then
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用户"
groupadd mysql && useradd -g mysql mysql
echo "mysql" | passwd --stdin 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
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 '/[1]+: / {}; /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 -uroot -p$mysql_pass --connect-expired-password <<EOF
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Xbl@mysql817' PASSWORD EXPIRE NEVER;
flush privileges;
use mysql;
update user set host='%' where user='root';
flush privileges;
CREATE USER 'slaveuser'@'%' IDENTIFIED WITH mysql_native_password BY 'Xbl@mysql817sync';
grant replication slave on . to 'slaveuser'@'%';
flush privileges;
CREATE USER 'mhauser'@'%' IDENTIFIED WITH mysql_native_password BY 'Xbl@mysql817mha';
grant all privileges on . to mhauser@'%' identified by 'Xbl@mysql817mha';
flush privileges;
quit
EOF
chmod 755 /usr/bin/mysql.local
envivarcount=cat /etc/profile|grep '/usr/local/mysql/bin'|wc -l
if [ $envivarcount -eq 0 ]; then
echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
source /etc/profile
else
echo mysqlenvivarexits
fi
else
echo 不需要安装mysql！
fi
cd /soft
yum install -y perl-ExtUtils-CBuilder perl-ExtUtils-MakeMaker perl-CPAN perl-DBD-MySQL perl-Config-Tiny perl-Log-Dispatch perl-Parallel-ForkManager perl-Time-HiRes
tar -zxf mha4mysql-node-0.58.tar.gz
cd mha4mysql-node-0.58/
perl Makefile.PL
make && make install
if [ "$hostnamecheck" == 'mysqlmanager' ]; then
cd /soft
tar -zxf mha4mysql-manager-0.58.tar.gz
cd mha4mysql-manager-0.58/
yes|perl Makefile.PL
yes|make && make install
mkdir -pv /mha/scripts
chown -R mysql:mysql /mha
chown -R mysql:mysql /mha/scripts/
cd /soft
yes|cp mha_conf.cnf /mha
mkdir -pv /usr/local/mha
chown -R mysql:mysql /usr/local/mha
fi
exit
4、cat mysqlmasterslave.sh
!/bin/bash
set -e
master=$1
slave=$2
if [ "$1" == "" ];then
echo -e "请在脚本后输入主服务器ip地址"
exit 1
fi
if [ "$2" == "" ];then
echo -e "请在脚本后输入从服务器ip地址"
exit 1
fi
bin_log=/usr/local/mysql/bin/mysql -uroot -pXbl@mysql817 -h $master -e "show master status;" | awk '/mysql-bin/{print $1}'
posID=/usr/local/mysql/bin/mysql -uroot -pXbl@mysql817 -h $master -e "show master status;" | awk '/mysql-bin/{print $2}'
if [ "$1" == "" ];then
echo -e "请在脚本后输入主服务器ip地址"
exit 1
fi
if [ "$2" == "" ];then
echo -e "请在脚本后输入从服务器ip地址"
exit 1
fi
同步bin_log######
/usr/local/mysql/bin/mysql -uroot -pXbl@mysql817 --connect-expired-password <<EOF
change master to master_host='$master',master_user='slaveuser',master_password='Xbl@mysql817sync',master_port=3306,master_log_file='$bin_log',master_log_pos=$posID;
start slave;
show slave status\G
EOF
echo -e "Slave机器主从配置成功！！！"
0-9 ↩︎
浙公网安备 33010602011771号