mysql 脚本 linux_mysql主从脚本

#!/bin/bash

#auto make install mysql AB Replication

#by author ale

#2019-4-29 09:25:44MYSQL_SOFT="mariadb mariadb-devel mariadb-server mariadb-libs"NUM=`rpm -qa|grep -i mariadb|wc -l`

INIT="mariadb.service"CODE=$?#Mysql To Installif [ $NUM -ne 0 -a -f /usr/lib/systemd/system/$INIT ];then

echo-e "\033[32mThis Server Mysql already Install.\033[0m"read-p "Please ensure yum remove Mysql Server,yes or no": INPUTif [ $INPUT == "y" -o $INPUT == "yes"];then

yum remove $MYSQL_SOFT-y;rm -rf /var/lib/mysql /etc/my.cnf

yum install $MYSQL_SOFT-yelseecho

fielseyum remove $MYSQL_SOFT-y;rm -rf /var/lib/mysql /etc/my.cnf

yum install $MYSQL_SOFT-yif [ $CODE -ne 0];then

echo-e "\033[32mThe Mysql Install successfully.\033[0m"

elseecho-e "\033[32mThe Mysql Install Failed.\033[0m"exit1fi

fi

cat>/etc/my.cnf<

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

user=mysql

symbolic-links=0log-bin=mysql-bin

server-id=1auto_increment_offset=1auto_increment_increment=2[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

EOF

chown-R mysql.mysql /var/lib/mysql

mkdir-p /var/run/mysqld

chown-R mysql.mysql /var/run/mysqld

systemctl restart mariadb.service

ps-ef|grep mysql

MYSQL_CONFIG(){

#Master Config Mysql

mysql-e "grant replication slave on *.* to 'tongbu'@'%' identified by '123456';"MASTER_FILE=`mysql -e "show master status;"|tail -1|awk '{print $1}'`

MASTER_POS=`mysql -e "show master status;"|tail -1|awk '{print $2}'`

MASTER_IPADDR=$(ifconfig|grep "broadcast"|cut -d" " -f10)

read-p "Please ensure Input Slave IPaddr:"SLAVE_IPADDR

#Slave Config Mysql

ssh-l root $SLAVE_IPADDR "yum remove $MYSQL_SOFT -y;rm -rf /var/lib/mysql /etc/my.cnf;yum install $MYSQL_SOFT -y"#ssh-l root $SLAVE_IPADDR "$my_cofig"scp-r /etc/my.cnf root@$SLAVE_IPADDR:/etc/ssh-l root $SLAVE_IPADDR "sed -i 's#server-id=1#server-id=2#g' /etc/my.cnf"ssh-l root $SLAVE_IPADDR "sed -i '/log-bin=mysql-bin/d' /etc/my.cnf"ssh-l root $SLAVE_IPADDR "chown -R mysql.mysql /var/lib/mysql"ssh-l root $SLAVE_IPADDR "mkdir -p /var/run/mysqld"ssh-l root $SLAVE_IPADDR "chown -R mysql.mysql /var/run/mysqld"ssh-l root $SLAVE_IPADDR "systemctl restart mariadb.service"ssh-l root $SLAVE_IPADDR "mysql -e \"change master to master_host='$MASTER_IPADDR',master_user='tongbu',master_password='123456',master_log_file='$MASTER_FILE',master_log_pos=$MASTER_POS;\""ssh-l root $SLAVE_IPADDR "mysql -e \"slave start;\""ssh-l root $SLAVE_IPADDR "mysql -e \"show slave status\G;\""}

read-p "Please ensure your Server is Master and you will config mysql Replication? yes or no": INPUTif [ $INPUT == "yes" -o $INPUT == "y"];then

MYSQL_CONFIGelseexit0fi