Category Archives: SHELL

#show you the code# Linux + Bash Shell，网卡绑定 – CentOS6

By Adamhuan | 2018年6月13日

使用的时候：
auto_bond0.sh IP地址主机名

就可以了。

接下来，直接看代码吧（Show you the code.）

#!/bin/bash

# file_name = CentOS6 Net bond0 - auto config

# variable

# input
input_ip_bond0=$1
input_hostname=$2
#dir
config_dir_network=/etc/sysconfig/network-scripts

#file
config_file_bond0_master=ifcfg-bond0
config_file_bond0_slave_list=$(ip a | grep mtu | grep -v "lo" | cut -d':' -f2)

# function

# 备份文件
function file_backup() {

	# variable - env
	string_date=$(date "+%Y-%m-%d_%H_%M_%S")

	# variable

	#file
	f_file_name_input="$1"
	f_file_name=$(echo $f_file_name_input | rev | cut -d'/' -f1 | rev)
	f_file_directory=$(dirname $f_file_name_input)

	f_file_backup=$f_file_directory"/bak_"$string_date"_"$f_file_name


	# display
	echo "func - file_direcotry is: [$f_file_directory]"
	echo "func - file_name is: [$f_file_name]"
	echo "---------"
	echo "func - file_backup full is: [$f_file_backup]"

	# do backup

	#before
	echo ""
	echo "@@ --> before: backup"
	echo "-----------------------"
	ls -ltr $f_file_directory | grep --color $f_file_name
	echo "-----------------------"
	
	#action
	echo ""
	echo "@@ --> action: backup"
	cp $f_file_name_input $f_file_backup
	
	#after
	echo ""
	echo "@@ --> after: backup"
	echo "-----------------------"
	ls -ltr $f_file_directory | grep --color $f_file_name
	echo "-----------------------"

}

function bond0_master() {

	# variable

	f_ip=$1
	#f_netmask=$2

	f_bond0_file=$config_dir_network"/ifcfg-bond0"

	# do backup
	echo "##--> do backup"
	if [ -f $f_bond0_file ]
		then
		echo "## --> file exists"
		file_backup $f_bond0_file
	fi

	# do
	echo "##--> do config"
	cat > $f_bond0_file <<DATA
DEVICE="bond0"
BOOTPROTO="static"
IPV6INIT="yes"
IPV6_AUTOCONF="yes"
NM_CONTROLLED="yes"
ONBOOT="yes"
TYPE="Ethernet"
UUID="9a89133a-846a-472f-99fc-cc116fc9b586"
 
IPADDR=$f_ip
NETMASK=255.255.255.192
GATEWAY=192.168.253.1
DNS1=208.91.112.53
DNS2=208.91.112.52

DATA

	# after do
	echo "##--> after config"
	echo "################"
	cat $f_bond0_file
	echo "################"

}

function sed_file_by_key(){

	# intro
	echo "@@@@@@@@@@@"
	echo "func sed_file_by_key($key)"

	# variable
	file_name=$1
	key=$2
	purpose_value=$3

	# variable compute
	value_is=$(cat $file_name | grep "$key" | cut -d'=' -f2)

	# display
	echo "#--> current is: [$value_is]"

	# do change
	echo "#--> do change"
	#--------- version 1
	#sed -i "/$key/s/$value_is/$purpose_value/g" $file_name

	#--------- version 2
	if [ "$value_is" == "" ]
		then
		echo "---> The key is not exists."
		echo $key"="$purpose_value >> $file_name
	else
		echo "---> The key is exists."
		sed -i "/$key/s/$value_is/$purpose_value/g" $file_name
	fi

	# after change
	echo "#--> after change"
	value_is=$(cat $file_name | grep "$key" | cut -d'=' -f2)	
	echo "#--> current is: [$value_is]"

}

function bond0_slave_conf_file_change() {

	# variable
	file_name=$1

	# do
	sed_file_by_key $file_name "BOOTPROTO" "static"
	sed_file_by_key $file_name "ONBOOT" "yes"
	sed_file_by_key $file_name "MASTER" "bond0"
	sed_file_by_key $file_name "SLAVE" "yes"

}

function do_bonding() {

	# INTRO
	echo "@@--> do bonding"

	cat > /etc/modprobe.d/bonding.conf <<DATA
alias bond0 bonding
options bonding mode=0 miimon=200
DATA

	modprobe bonding

	# After
	echo "@@--> after bonding"
	echo "---------"
	lsmod | grep bonding
	echo "---------"
	cat /proc/net/bonding/bond0
	echo "---------"
}

# display
echo "========================="
echo "Network Directory is: [$config_dir_network]"
echo "Config file - Master is: [$config_file_bond0_master]"
echo "========================="

# -----------------------------
# bond0 - Slave
echo ""
echo "Config file - bond0 Slave"
echo "******************************"

for slave_item in $config_file_bond0_slave_list
do
	# intro
	echo "%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%"
	echo "Config file - Slave is: [$slave_item]"

	# variable
	f_full_path=$config_dir_network"/ifcfg-"$slave_item

	# display
	echo "Path is: [$f_full_path]"

	# do backup
	echo "### --> do backup()"
	file_backup $f_full_path

	# do config file change
	echo "### --> do config_file_change()"
	bond0_slave_conf_file_change $f_full_path


done

# -----------------------------
# bond0 - Master
echo ""
echo "Config file - bond0 Master"
echo "******************************"

bond0_master $input_ip_bond0

# do

# change hostname
sed_file_by_key "/etc/sysconfig/network" "HOSTNAME" $input_hostname

# bonding
do_bonding

# service: network
service network restart

# done

# finished

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

#!/bin/bash

# file_name = CentOS6 Net bond0 - auto config

# variable

# input

input_ip_bond0=$1

input_hostname=$2

#dir

config_dir_network=/etc/sysconfig/network-scripts

#file

config_file_bond0_master=ifcfg-bond0

config_file_bond0_slave_list=$(ip a | grep mtu | grep -v "lo" | cut -d':' -f2)

# function

# 备份文件

function file_backup() {

# variable - env

string_date=$(date "+%Y-%m-%d_%H_%M_%S")

# variable

#file

f_file_name_input="$1"

f_file_name=$(echo $f_file_name_input | rev | cut -d'/' -f1 | rev)

f_file_directory=$(dirname $f_file_name_input)

f_file_backup=$f_file_directory"/bak_"$string_date"_"$f_file_name

# display

echo "func - file_direcotry is: [$f_file_directory]"

echo "func - file_name is: [$f_file_name]"

echo "---------"

echo "func - file_backup full is: [$f_file_backup]"

# do backup

#before

echo ""

echo "@@ --> before: backup"

echo "-----------------------"

ls -ltr $f_file_directory | grep --color $f_file_name

echo "-----------------------"

#action

echo ""

echo "@@ --> action: backup"

cp $f_file_name_input $f_file_backup

#after

echo ""

echo "@@ --> after: backup"

echo "-----------------------"

ls -ltr $f_file_directory | grep --color $f_file_name

echo "-----------------------"

}

function bond0_master() {

# variable

f_ip=$1

#f_netmask=$2

f_bond0_file=$config_dir_network"/ifcfg-bond0"

# do backup

echo "##--> do backup"

if [ -f $f_bond0_file ]

then

echo "## --> file exists"

file_backup $f_bond0_file

# do

echo "##--> do config"

cat > $f_bond0_file <<DATA

DEVICE="bond0"

BOOTPROTO="static"

IPV6INIT="yes"

IPV6_AUTOCONF="yes"

NM_CONTROLLED="yes"

ONBOOT="yes"

TYPE="Ethernet"

UUID="9a89133a-846a-472f-99fc-cc116fc9b586"

IPADDR=$f_ip

NETMASK=255.255.255.192

GATEWAY=192.168.253.1

DNS1=208.91.112.53

DNS2=208.91.112.52

DATA

# after do

echo "##--> after config"

echo "################"

cat $f_bond0_file

echo "################"

}

function sed_file_by_key(){

# intro

echo "@@@@@@@@@@@"

echo "func sed_file_by_key($key)"

# variable

file_name=$1

key=$2

purpose_value=$3

# variable compute

value_is=$(cat $file_name | grep "$key" | cut -d'=' -f2)

# display

echo "#--> current is: [$value_is]"

# do change

echo "#--> do change"

#--------- version 1

#sed -i "/$key/s/$value_is/$purpose_value/g" $file_name

#--------- version 2

if [ "$value_is" == "" ]

then

echo "---> The key is not exists."

echo $key"="$purpose_value >> $file_name

else

echo "---> The key is exists."

sed -i "/$key/s/$value_is/$purpose_value/g" $file_name

# after change

echo "#--> after change"

value_is=$(cat $file_name | grep "$key" | cut -d'=' -f2)

echo "#--> current is: [$value_is]"

}

function bond0_slave_conf_file_change() {

# variable

file_name=$1

# do

sed_file_by_key $file_name "BOOTPROTO" "static"

sed_file_by_key $file_name "ONBOOT" "yes"

sed_file_by_key $file_name "MASTER" "bond0"

sed_file_by_key $file_name "SLAVE" "yes"

}

function do_bonding() {

# INTRO

echo "@@--> do bonding"

cat > /etc/modprobe.d/bonding.conf <<DATA

alias bond0 bonding

options bonding mode=0 miimon=200

DATA

modprobe bonding

# After

echo "@@--> after bonding"

echo "---------"

lsmod | grep bonding

echo "---------"

cat /proc/net/bonding/bond0

echo "---------"

}

# display

echo "========================="

echo "Network Directory is: [$config_dir_network]"

echo "Config file - Master is: [$config_file_bond0_master]"

echo "========================="

# -----------------------------

# bond0 - Slave

echo ""

echo "Config file - bond0 Slave"

echo "******************************"

for slave_item in $config_file_bond0_slave_list

# intro

echo "%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%"

echo "Config file - Slave is: [$slave_item]"

# variable

f_full_path=$config_dir_network"/ifcfg-"$slave_item

# display

echo "Path is: [$f_full_path]"

# do backup

echo "### --> do backup()"

file_backup $f_full_path

# do config file change

echo "### --> do config_file_change()"

bond0_slave_conf_file_change $f_full_path

done

# -----------------------------

# bond0 - Master

echo ""

echo "Config file - bond0 Master"

echo "******************************"

bond0_master $input_ip_bond0

# do

# change hostname

sed_file_by_key "/etc/sysconfig/network" "HOSTNAME" $input_hostname

# bonding

do_bonding

# service: network

service network restart

# done

# finished

——————————————————
Done。

Shell：CentOS 7，自动配置bond0

By Adamhuan | 2018年6月10日

0 Comment

使用的时候：
auto_bond0_centos7.sh “主机名” “IP地址”

直接看代码：

#!/usr/bin/env bash

# variable - purpose
string_hostname_purpose=$1
string_ip_purpose=$2

# variable
list_net=$(ifconfig | grep mtu | cut -d ':' -f 1 | grep -v "lo")
string_date=$(date "+%Y-%m-%d_%H_%M_%S")

# function

# display
#echo "$list_net"

# do

# for bond0 - SLAVE
for net_item in $list_net
do
  echo "%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%"
  echo "current is: [$net_item]"

  # variable
  net_conf="/etc/sysconfig/network-scripts/ifcfg-$net_item"
  net_conf_backup="/etc/sysconfig/network-scripts/bak_ifcfg-"$net_item"_backup_"$string_date

  echo "config file is: [$net_conf]"
  echo "config file backup is: [$net_conf_backup]"

  # backup: before
  echo "=============="
  echo "Backup - config file: before"
  ls -ltr /etc/sysconfig/network-scripts/ | grep --color "$net_item"

  # backup: doing
  echo "=============="
  echo "Backup - config file: doing"
  cp $net_conf $net_conf_backup

  # backup: after
  echo "=============="
  echo "Backup - config file: after"
  ls -ltr /etc/sysconfig/network-scripts/ | grep --color "$net_item"

  # change config
  echo "#################"
  echo "Change config"

  # -----------------------
  # BOOTPROTO
  echo ""
  echo "****** --> BOOTPROTO"

  string_bootproto=$(cat $net_conf | grep "BOOTPROTO" | cut -d'=' -f2)
  echo "------------"
  echo "BOOTPROTO - old: [$string_bootproto]"

  echo "------------"
  echo "Change - BOOTPROTO --> [static]"
  sed -i "/BOOTPROTO/s/$string_bootproto/static/g" $net_conf

  echo "------------"
  echo "Change - BOOTPROTO - after"
  string_bootproto=$(cat $net_conf | grep "BOOTPROTO" | cut -d'=' -f2)
  echo "BOOTPROTO - current: [$string_bootproto]"

  # -----------------------
  # ONBOOT
  echo ""
  echo "****** --> ONBOOT"

  string_onboot=$(cat $net_conf | grep "ONBOOT" | cut -d'=' -f2)
  echo "------------"
  echo "ONBOOT - old: [$string_onboot]"

  echo "------------"
  echo "Change - ONBOOT --> [yes]"
  sed -i "/ONBOOT/s/$string_onboot/yes/g" $net_conf

  echo "------------"
  echo "Change - ONBOOT - after"
  string_onboot=$(cat $net_conf | grep "ONBOOT" | cut -d'=' -f2)
  echo "ONBOOT - current: [$string_onboot]"

  # -----------------------
  # MASTER & SLAVE
  echo ""
  echo "****** --> MASTER / SLAVE"

  echo "------------"
  echo "Append MASTER / SLAVE to config file"
  echo "MASTER=bond0" >> $net_conf
  echo "SLAVE=yes" >> $net_conf

done

# for bond0 - MASTER
echo "%%%%%%%%%%% BONDING - bond0 - Master"
nmcli con add type bond ifname bond0 mode 0

echo "Change bond0 MASTER - setting"

sed -i '/BOOTPROTO/s/dhcp/static/g' /etc/sysconfig/network-scripts/ifcfg-bond-bond0
sed -i '/ONBOOT/s/no/yes/g' /etc/sysconfig/network-scripts/ifcfg-bond-bond0

echo "DNS1=223.5.5.5" >> /etc/sysconfig/network-scripts/ifcfg-bond-bond0
echo "DNS2=223.6.6.6" >> /etc/sysconfig/network-scripts/ifcfg-bond-bond0
echo "NETMASK=255.255.255.0" >> /etc/sysconfig/network-scripts/ifcfg-bond-bond0
echo "GATEWAY=192.168.253.1" >> /etc/sysconfig/network-scripts/ifcfg-bond-bond0
echo "IPADDR=$string_ip_purpose" >> /etc/sysconfig/network-scripts/ifcfg-bond-bond0

# Hostname settings
echo "%%%%%%%%%%% Linux system - Hostname"

echo "Backup file"
cp /etc/hostname /etc/hostname_backup_$string_date

echo "Setting Hostname"
echo "$string_hostname_purpose" > /etc/hostname

echo "After Setting:"
cat /etc/hostname

# Restart service network
systemctl restart network

# done

# finished

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

#!/usr/bin/env bash

# variable - purpose

string_hostname_purpose=$1

string_ip_purpose=$2

# variable

list_net=$(ifconfig | grep mtu | cut -d ':' -f 1 | grep -v "lo")

string_date=$(date "+%Y-%m-%d_%H_%M_%S")

# function

# display

#echo "$list_net"

# do

# for bond0 - SLAVE

for net_item in $list_net

echo "%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%"

echo "current is: [$net_item]"

# variable

net_conf="/etc/sysconfig/network-scripts/ifcfg-$net_item"

net_conf_backup="/etc/sysconfig/network-scripts/bak_ifcfg-"$net_item"_backup_"$string_date

echo "config file is: [$net_conf]"

echo "config file backup is: [$net_conf_backup]"

# backup: before

echo "=============="

echo "Backup - config file: before"

ls -ltr /etc/sysconfig/network-scripts/ | grep --color "$net_item"

# backup: doing

echo "=============="

echo "Backup - config file: doing"

cp $net_conf $net_conf_backup

# backup: after

echo "=============="

echo "Backup - config file: after"

ls -ltr /etc/sysconfig/network-scripts/ | grep --color "$net_item"

# change config

echo "#################"

echo "Change config"

# -----------------------

# BOOTPROTO

echo ""

echo "****** --> BOOTPROTO"

string_bootproto=$(cat $net_conf | grep "BOOTPROTO" | cut -d'=' -f2)

echo "------------"

echo "BOOTPROTO - old: [$string_bootproto]"

echo "------------"

echo "Change - BOOTPROTO --> [static]"

sed -i "/BOOTPROTO/s/$string_bootproto/static/g" $net_conf

echo "------------"

echo "Change - BOOTPROTO - after"

string_bootproto=$(cat $net_conf | grep "BOOTPROTO" | cut -d'=' -f2)

echo "BOOTPROTO - current: [$string_bootproto]"

# -----------------------

# ONBOOT

echo ""

echo "****** --> ONBOOT"

string_onboot=$(cat $net_conf | grep "ONBOOT" | cut -d'=' -f2)

echo "------------"

echo "ONBOOT - old: [$string_onboot]"

echo "------------"

echo "Change - ONBOOT --> [yes]"

sed -i "/ONBOOT/s/$string_onboot/yes/g" $net_conf

echo "------------"

echo "Change - ONBOOT - after"

string_onboot=$(cat $net_conf | grep "ONBOOT" | cut -d'=' -f2)

echo "ONBOOT - current: [$string_onboot]"

# -----------------------

# MASTER & SLAVE

echo ""

echo "****** --> MASTER / SLAVE"

echo "------------"

echo "Append MASTER / SLAVE to config file"

echo "MASTER=bond0" >> $net_conf

echo "SLAVE=yes" >> $net_conf

done

# for bond0 - MASTER

echo "%%%%%%%%%%% BONDING - bond0 - Master"

nmcli con add type bond ifname bond0 mode 0

echo "Change bond0 MASTER - setting"

sed -i '/BOOTPROTO/s/dhcp/static/g' /etc/sysconfig/network-scripts/ifcfg-bond-bond0

sed -i '/ONBOOT/s/no/yes/g' /etc/sysconfig/network-scripts/ifcfg-bond-bond0

echo "DNS1=223.5.5.5" >> /etc/sysconfig/network-scripts/ifcfg-bond-bond0

echo "DNS2=223.6.6.6" >> /etc/sysconfig/network-scripts/ifcfg-bond-bond0

echo "NETMASK=255.255.255.0" >> /etc/sysconfig/network-scripts/ifcfg-bond-bond0

echo "GATEWAY=192.168.253.1" >> /etc/sysconfig/network-scripts/ifcfg-bond-bond0

echo "IPADDR=$string_ip_purpose" >> /etc/sysconfig/network-scripts/ifcfg-bond-bond0

# Hostname settings

echo "%%%%%%%%%%% Linux system - Hostname"

echo "Backup file"

cp /etc/hostname /etc/hostname_backup_$string_date

echo "Setting Hostname"

echo "$string_hostname_purpose" > /etc/hostname

echo "After Setting:"

cat /etc/hostname

# Restart service network

systemctl restart network

# done

# finished

——————————
Done。

脚本：Cobbler Center – 自动部署【离线】 – Bash Shell版本

By Adamhuan | 2018年6月9日

0 Comment

本文从零开始详细描述一个Cobbler Center的自动部署脚本是如何建立起来的。

手动安装部分参考之前的文档：
http://d-prototype.com/archives/6843

首先，开启服务器的YUM源缓存：

[root@localhost ~]# cat /etc/yum.conf | grep keepcache
keepcache=1
[root@localhost ~]#

[root@localhost ~]# cat /etc/yum.conf | grep keepcache

keepcache=1

[root@localhost ~]#

SHELL：MySQL – 自动创建主从同步

By Adamhuan | 2018年2月28日

0 Comment

脚本：

#!/bin/bash

# file: mysql_ha_master_slave_auto_config.sh
# purpose: 自动配置MySQL主从架构

# 前提：
# 1. 已经安装好了MySQL的两台服务器
# 2. 服务器服务已运行
# 3. 服务器之间的SSH互信

# 默认情况下，该脚本在主库端执行


# =====================
# variable

# ----------
# 服务器相关
ip_master=192.168.174.128
ip_slave=192.168.174.129

# 当前服务器角色：
# 1，主库端
# 2，从库端
current_role=""

os_user='root'
os_password='*************'

# ----------
# 数据库相关

# 用户
mysql_root_user='root'
mysql_root_password='*******'

mysql_repl_user='replme'
mysql_repl_password='*******'

# 配置
mysql_port='33944'

# 文件
file_mysql_cnf='/etc/my.cnf'

# 参数

# server-id
#mysql_parameter_server_id_master=0
#mysql_parameter_server_id_slave=0
#mysql_parameter_server_id_diff=5

# 主从相关信息
mysql_replication_file=""
mysql_replication_pos=0

# ----------

# ----------

# ----------

# =====================
# function

# ------------
function do_sql() {
  # variable
  func_str_ip="$1"
  func_str_sql="$2"

  # ----------------------
  # changed

  func_str_user="$3"
  func_str_password="$4"
  func_str_port="$5"

  # ----------------------

  #echo "func_str_ip --> $func_str_ip"
  #echo "func_str_sql --> $func_str_sql"
  #echo "func_str_user --> $func_str_user"
  #echo "func_str_password --> $func_str_password"
  #echo "func_str_port --> $func_str_port"

  echo

  # action
  # 本场景中不涉及到对MySQL某个库的操作，所以没有选择[db]
  # mysql -u $user -p"$password" $db -N -e "$f_sql_str"
  mysql -h"$func_str_ip" -P$func_str_port -u "$func_str_user" -p"$func_str_password" -N -e "$func_str_sql"
}

# ------------
# 对指定主机执行Linux命令
# 前提：
# 1. IP可达
# 2. SSH等价关系
function do_linux_by_ssh() {
  # variable
  func_str_ip="$1"
  func_str_user="$2"
  func_str_command="$3"

  # action
  ssh -t $func_str_user@$func_str_ip "$func_str_command"
}

# ------------
# 检查当前运行服务器角色
function check_machine_role() {
  f_current_ip=$(ifconfig | grep "inet addr" | head -n 1 | cut -d':' -f2 | cut -d' ' -f1)

  if [ "$f_current_ip" == "$ip_master" ]
  then
    current_role="1"
  elif [ "$f_current_ip" == "$ip_slave" ]
  then
    current_role="2"
  else
    echo "--> Not Match."
  fi

}

# ------------
# 计算和
function calc_sum() {
  #statements
  num1=$1
  num2=$2

  echo $(($num1+$num2))
}

# ------------
# 主库端操作
function mysql_master_config() {

  echo "--> 初步查看"
  do_sql "$ip_master" "show master status;" "$mysql_root_user" "$mysql_root_password" "$mysql_port"
  do_sql "$ip_master" "select user,host from mysql.user;" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

  # 增加Replication用户
  echo "Add user replication"
  do_sql "$ip_master" "create user $mysql_repl_user@'$ip_slave' identified by '$mysql_repl_password';" "$mysql_root_user" "$mysql_root_password" "$mysql_port"
  do_sql "$ip_master" "grant replication slave,replication client on *.* to $mysql_repl_user@'$ip_slave'" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

  # 增加root用户
  do_sql "$ip_master" "create user $mysql_root_user@'$ip_master' identified by '$mysql_repl_password';" "$mysql_root_user" "$mysql_root_password" "$mysql_port"
  do_sql "$ip_master" "grant all privileges on *.* to $mysql_root_user@'$ip_master" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

  do_sql "$ip_master" "create user $mysql_root_user@'$ip_slave' identified by '$mysql_repl_password';" "$mysql_root_user" "$mysql_root_password" "$mysql_port"
  do_sql "$ip_master" "grant all privileges on *.* to $mysql_root_user@'$ip_slave" "$mysql_root_user" "$mysql_root_password" "$mysql_port"


  # 再次查看
  do_sql "$ip_master" "select user,host from mysql.user;" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

  # 获取基本信息
  mysql_replication_file=`do_sql "$ip_master" "show master status;" "$mysql_root_user" "$mysql_root_password" "$mysql_port" | awk '{printf $1}'`
  mysql_replication_pos=`do_sql "$ip_master" "show master status;" "$mysql_root_user" "$mysql_root_password" "$mysql_port" | awk '{printf $2}'`

  # display
  echo "主库端：file - [$mysql_replication_file]; POS - [$mysql_replication_pos]"

}

# ------------
# 从库端操作
function mysql_slave_config() {
  # 初步查看
  do_sql "$ip_slave" "show master status;" "$mysql_root_user" "$mysql_root_password" "$mysql_port"
  do_sql "$ip_slave" "select user,host from mysql.user;" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

  # 增加用户 - root
  # 增加root用户
  echo "Add user"
  do_sql "$ip_slave" "create user $mysql_root_user@'$ip_master' identified by '$mysql_repl_password';" "$mysql_root_user" "$mysql_root_password" "$mysql_port"
  do_sql "$ip_slave" "grant all privileges on *.* to $mysql_root_user@'$ip_master" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

  do_sql "$ip_slave" "create user $mysql_root_user@'$ip_slave' identified by '$mysql_repl_password';" "$mysql_root_user" "$mysql_root_password" "$mysql_port"
  do_sql "$ip_slave" "grant all privileges on *.* to $mysql_root_user@'$ip_slave" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

  # 再次查看

  do_sql "$ip_slave" "select user,host from mysql.user;" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

  # Change master
  echo "Change Master"
  echo "--------------"
  echo "Command is:"
  "change master to master_host='$ip_master',master_port=$mysql_port,master_user='$mysql_repl_user',master_password='$mysql_repl_password',master_log_file='$mysql_replication_file',master_log_pos=$mysql_replication_pos;"
  echo "--------------"
  do_sql "$ip_slave" "change master to master_host='$ip_master',master_port=$mysql_port,master_user='$mysql_repl_user',master_password='$mysql_repl_password',master_log_file='$mysql_replication_file',master_log_pos=$mysql_replication_pos;" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

  # display

  do_sql "$ip_slave" "show slave status\G" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

  # run
  echo "Start slave"
  do_sql "$ip_slave" "start slave" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

}

# =====================
# display

# =====================
# begin

# 判定当前服务器角色
check_machine_role
echo "当前脚本执行服务器角色：$current_role"

# 配置主库端
echo ""
echo "主库"
echo "==============="
mysql_master_config

# 配置从库端
echo ""
echo "从库"
echo "==============="
mysql_slave_config

# =====================
# end

# =====================
# Finished

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

#!/bin/bash

# file: mysql_ha_master_slave_auto_config.sh

# purpose: 自动配置MySQL主从架构

# 前提：

# 1. 已经安装好了MySQL的两台服务器

# 2. 服务器服务已运行

# 3. 服务器之间的SSH互信

# 默认情况下，该脚本在主库端执行

# =====================

# variable

# ----------

# 服务器相关

ip_master=192.168.174.128

ip_slave=192.168.174.129

# 当前服务器角色：

# 1，主库端

# 2，从库端

current_role=""

os_user='root'

os_password='*************'

# ----------

# 数据库相关

# 用户

mysql_root_user='root'

mysql_root_password='*******'

mysql_repl_user='replme'

mysql_repl_password='*******'

# 配置

mysql_port='33944'

# 文件

file_mysql_cnf='/etc/my.cnf'

# 参数

# server-id

#mysql_parameter_server_id_master=0

#mysql_parameter_server_id_slave=0

#mysql_parameter_server_id_diff=5

# 主从相关信息

mysql_replication_file=""

mysql_replication_pos=0

# ----------

# =====================

# function

# ------------

function do_sql() {

# variable

func_str_ip="$1"

func_str_sql="$2"

# ----------------------

# changed

func_str_user="$3"

func_str_password="$4"

func_str_port="$5"

# ----------------------

#echo "func_str_ip --> $func_str_ip"

#echo "func_str_sql --> $func_str_sql"

#echo "func_str_user --> $func_str_user"

#echo "func_str_password --> $func_str_password"

#echo "func_str_port --> $func_str_port"

echo

# action

# 本场景中不涉及到对MySQL某个库的操作，所以没有选择[db]

# mysql -u $user -p"$password" $db -N -e "$f_sql_str"

mysql -h"$func_str_ip" -P$func_str_port -u "$func_str_user" -p"$func_str_password" -N -e "$func_str_sql"

}

# ------------

# 对指定主机执行Linux命令

# 前提：

# 1. IP可达

# 2. SSH等价关系

function do_linux_by_ssh() {

# variable

func_str_ip="$1"

func_str_user="$2"

func_str_command="$3"

# action

ssh -t $func_str_user@$func_str_ip "$func_str_command"

}

# ------------

# 检查当前运行服务器角色

function check_machine_role() {

f_current_ip=$(ifconfig | grep "inet addr" | head -n 1 | cut -d':' -f2 | cut -d' ' -f1)

if [ "$f_current_ip" == "$ip_master" ]

then

current_role="1"

elif [ "$f_current_ip" == "$ip_slave" ]

then

current_role="2"

else

echo "--> Not Match."

}

# ------------

# 计算和

function calc_sum() {

#statements

num1=$1

num2=$2

echo $(($num1+$num2))

}

# ------------

# 主库端操作

function mysql_master_config() {

echo "--> 初步查看"

do_sql "$ip_master" "show master status;" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

do_sql "$ip_master" "select user,host from mysql.user;" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

# 增加Replication用户

echo "Add user replication"

do_sql "$ip_master" "create user $mysql_repl_user@'$ip_slave' identified by '$mysql_repl_password';" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

do_sql "$ip_master" "grant replication slave,replication client on *.* to $mysql_repl_user@'$ip_slave'" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

# 增加root用户

do_sql "$ip_master" "create user $mysql_root_user@'$ip_master' identified by '$mysql_repl_password';" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

do_sql "$ip_master" "grant all privileges on *.* to $mysql_root_user@'$ip_master" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

do_sql "$ip_master" "create user $mysql_root_user@'$ip_slave' identified by '$mysql_repl_password';" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

do_sql "$ip_master" "grant all privileges on *.* to $mysql_root_user@'$ip_slave" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

# 再次查看

do_sql "$ip_master" "select user,host from mysql.user;" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

# 获取基本信息

mysql_replication_file=`do_sql "$ip_master" "show master status;" "$mysql_root_user" "$mysql_root_password" "$mysql_port" | awk '{printf $1}'`

mysql_replication_pos=`do_sql "$ip_master" "show master status;" "$mysql_root_user" "$mysql_root_password" "$mysql_port" | awk '{printf $2}'`

# display

echo "主库端：file - [$mysql_replication_file]; POS - [$mysql_replication_pos]"

}

# ------------

# 从库端操作

function mysql_slave_config() {

# 初步查看

do_sql "$ip_slave" "show master status;" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

do_sql "$ip_slave" "select user,host from mysql.user;" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

# 增加用户 - root

# 增加root用户

echo "Add user"

do_sql "$ip_slave" "create user $mysql_root_user@'$ip_master' identified by '$mysql_repl_password';" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

do_sql "$ip_slave" "grant all privileges on *.* to $mysql_root_user@'$ip_master" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

do_sql "$ip_slave" "create user $mysql_root_user@'$ip_slave' identified by '$mysql_repl_password';" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

do_sql "$ip_slave" "grant all privileges on *.* to $mysql_root_user@'$ip_slave" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

# 再次查看

do_sql "$ip_slave" "select user,host from mysql.user;" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

# Change master

echo "Change Master"

echo "--------------"

echo "Command is:"

"change master to master_host='$ip_master',master_port=$mysql_port,master_user='$mysql_repl_user',master_password='$mysql_repl_password',master_log_file='$mysql_replication_file',master_log_pos=$mysql_replication_pos;"

echo "--------------"

do_sql "$ip_slave" "change master to master_host='$ip_master',master_port=$mysql_port,master_user='$mysql_repl_user',master_password='$mysql_repl_password',master_log_file='$mysql_replication_file',master_log_pos=$mysql_replication_pos;" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

# display

do_sql "$ip_slave" "show slave status\G" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

# run

echo "Start slave"

do_sql "$ip_slave" "start slave" "$mysql_root_user" "$mysql_root_password" "$mysql_port"

}

# =====================

# display

# =====================

# begin

# 判定当前服务器角色

check_machine_role

echo "当前脚本执行服务器角色：$current_role"

# 配置主库端

echo ""

echo "主库"

echo "==============="

mysql_master_config

# 配置从库端

echo ""

echo "从库"

echo "==============="

mysql_slave_config

# =====================

# end

# =====================

# Finished

——————————————————
Done。

SHELL：清理MySQL指定用户的会话

By Adamhuan | 2018年1月11日

0 Comment

执行效果是这样的：

[root@mariadb-cluster-1 ~]# sh 1.sh "fengtimo lenka"
User will be killed: fengtimo lenka
-------------------------
Current User is: fengtimo
-------------------------
Current User is: lenka
-------------------------

-------------------------
Result is:

kill 21;
kill 19;
kill 22;
[root@mariadb-cluster-1 ~]# 
[root@mariadb-cluster-1 ~]# cat mysql_kill_session.output 

kill 21;
kill 19;
kill 22;
[root@mariadb-cluster-1 ~]#

[root@mariadb-cluster-1 ~]# sh 1.sh "fengtimo lenka"

User will be killed: fengtimo lenka

-------------------------

Current User is: fengtimo

-------------------------

Current User is: lenka

-------------------------

Result is:

kill 21;

kill 19;

kill 22;

[root@mariadb-cluster-1 ~]#

[root@mariadb-cluster-1 ~]# cat mysql_kill_session.output

kill 21;

kill 19;

kill 22;

[root@mariadb-cluster-1 ~]#

代码如下：

[root@mariadb-cluster-1 ~]# cat 1.sh 
#!/bin/bash

# name: mysql_kill_session

# variable
list_kill_user=$1
file_output_sql=mysql_kill_session.output

mysql_user="root"
mysql_password="****"

# display
echo "User will be killed: $list_kill_user"

echo "-------------------------"

# begin
echo "" > $file_output_sql

for item_user in $list_kill_user
do
    echo "Current User is: $item_user"

    #echo "-------------------------"

    #mysql -u"$mysql_user" -p"$mysql_password" -e 'show processlist;'

    echo "-------------------------"

    mysql -u"$mysql_user" -p"$mysql_password" -N -e "select concat('kill ',id,';') from information_schema.processlist where user in ('$item_user');" >> $file_output_sql

done
echo ""

# Result:

echo "-------------------------"
echo "Result is:"
cat $file_output_sql
 
# finished
[root@mariadb-cluster-1 ~]#

[root@mariadb-cluster-1 ~]# cat 1.sh

#!/bin/bash

# name: mysql_kill_session

# variable

list_kill_user=$1

file_output_sql=mysql_kill_session.output

mysql_user="root"

mysql_password="****"

# display

echo "User will be killed: $list_kill_user"

echo "-------------------------"

# begin

echo "" > $file_output_sql

for item_user in $list_kill_user

echo "Current User is: $item_user"

#echo "-------------------------"

#mysql -u"$mysql_user" -p"$mysql_password" -e 'show processlist;'

echo "-------------------------"

mysql -u"$mysql_user" -p"$mysql_password" -N -e "select concat('kill ',id,';') from information_schema.processlist where user in ('$item_user');" >> $file_output_sql

done

echo ""

# Result:

echo "-------------------------"

echo "Result is:"

cat $file_output_sql

# finished

[root@mariadb-cluster-1 ~]#

——————————————————
Done。