Mysql主从

#!/bin/bash

MYSQL_SOFT="mysql mysql-server mysql-devel php-mysql"
NUM=`rpm -qa |grep -i mysql |wc -l`
CODE=$?

#Mysql To Install 2015
if [ $NUM -ne 0 ];then
	echo -e "\033[32mThis Server Mysql already Install.\033[0m"
	read -p "Please ensure yum remove Mysql Server,YES or NO": INPUT
	if [ $INPUT == "y" -o $INPUT == "yes" ];then
	  	yum remove $MYSQL_SOFT -y ;rm -rf /var/lib/mysql /etc/my.cnf
	 	yum install $MYSQL_SOFT -y
	else
		exit 0
	fi
else
	rm -rf /var/lib/mysql;yum install $MYSQL_SOFT -y
	if [ $CODE -eq 0 ];then
		echo -e "\033[32mThe Mysql Install Successfully.\033[0m"
	else
		echo -e "\033[32mThe Mysql Install Failed.\033[0m"
		exit 1
	fi
fi
#Mysql to start and Config
cat >/etc/my.cnf<<EOF
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
log-bin=mysql-bin
server-id = 1
auto_increment_offset=1
auto_increment_increment=2
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
replicate-do-db =all
EOF
/etc/init.d/mysqld restart
ps -ef |grep mysql

function 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 eth0|grep "Bcast"|awk '{print $2}'|cut -d: -f2`
read -p "Please Enter INput Slave IP Address": SLAVE_IPADDR

#Slave Config Mysql
ssh -l root $SLAVE_IPADDR "sed -i 's#server-id = 1#server-id = 2#g' /etc/my.cnf" 
ssh -l root $SLAVE_IPADDR "/etc/init.d/mysqld restart" 
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?yes or no": INPUT
if [ $INPUT == "y" -o $INPUT == "yes" ];then
	MYSQL_CONFIG
else
	exit 0
fi