shell脚本实战：快速设置静态IP和mysql一主一从脚本快速部署

1，快速设置静态IP

#!/usr/bin/bash
read -p "请输入你要指定的网关： "  gw
read -p "请输入你要制定的IP ：  "  my_ip
echo "正在配置网络......."
cp /etc/sysconfig/network-scripts/ifcfg-ens33  /etc/sysconfig/network-scripts/ifcfg-ens33.bak
cat >/etc/sysconfig/network-scripts/ifcfg-ens33<<-EOF
TYPE="Ethernet"
BOOTPROTO="none"
DEVICE="ens33"
ONBOOT="yes"
IPADDR=$my_ip
PREFIX=24
GATEWAY=$gw
DNS1=114.114.114.114
EOF
systemctl stop NetworkManager &>/dev/null
systemctl restart network &>/dev/null
if [ $? -eq 0 ]
then
  echo "网络配置完成！"
else
  echo "配置错误！....请检查环境后在进行配置！"
fi

2，mysql一主一从脚本快速部署

#!/bin/bash
systemctl stop mysqld mariadb &>/dev/null
yum -y remove `rpm -qa |grep mariadb` 2>/dev/null
yum -y remove `rpm -qa |grep myaql` 2>/dev/null
rm -rf /etc/my.cnf  /var/lib/mysql  /var/log/mysql*
userdel -r mysql &>/dev/null
ping -c1 www.baidu.com &>/dev/null
if [ $? -eq 0 ];then
	echo "network is successful"
	yum -y install wget &>/dev/null
	if [ $? -eq 0 ];then
		wget https://dev.mysql.com/get/mysql80-community-release-el7-6.noarch.rpm
		rpm -ivh /root/mysql80-community-release-el7-6.noarch.rpm
		yum clean all
		yum makecache fast
	else
		echo "wget下载失败,请检查网络！！！"
		exit
	fi
else
	echo "network is failed"
	exit
fi

yum -y install yum-utils
yum-config-manager  --enable mysql57-community
yum-config-manager  --disable mysql80-community
sed -ri 's/gpgcheck=1/gpgcheck=0/' /etc/yum.repos.d/mysql-community.repo
yum -y install mysql mysql-server
systemctl start mysqld
ss -lntp |grep 3306
if [ $? -eq 0 ];then
	echo "mysql启动成功"
else
	echo "mysql启动失败"
fi
read -p "请输入您的初始化密码：" pass
a=`cat /var/log/mysqld.log |grep root@localhost |awk '{print $NF}'`
mysqladmin -uroot -p$a password  $pass
mysql -uroot -pQianfeng@123 -e 'show databases' >/dev/null
if [ $? -eq 0 ];then
	echo "mysql新密码设置成功"
else
	echo "mysql新密码设置失败"
fi
m=/etc/my.cnf
cat >> $m <<eof
log-bin
server-id=1
gtid_mode = ON
enforce_gtid_consistency=1
eof
read -p "请出入授权用户名：" name
mysql -uroot -pQianfeng@123 -e 'grant all on *.* to $name@"%" identified by "Qianfeng@123"' >/dev/null
if [ $? -eq 0 ];then
	echo "$name用户授权已经创建"
else
	echo "$name用户授权创建失败！！！"

#从服务器部署
b=/etc/my.cnf
cat >> $b << eof
log-bin
server-id=1
gtid_mode = on
enforce_gtid_consistency=1
relay_log_recovery        = on
master-info-repository=TABLE
relay-log-info-repository=TABLE
eof
systemctl restart mysqld
read -p "请输入主服务器的IP地址：" ipaddr
read -p "请输入授权的用户名称：" name1
read -p "请输入授权的密码：" mima
c="change master to  master_host='$ipaddr',master_user='$name1',master_password='$mima',master_auto_position=1;"
mysql -uroot -pQianfeng@123 -e '$c'
mysql -uroot -pQianfeng@123 -e 'start $name1'
mysql -uroot -pQianfeng@123 -e 'show $name1 status\G'