Tag Archives: Shell

SHELL：统计CPU使用率大于XX时，CPU/内存/虚拟内存，高耗进程以及资源使用情况

By Adamhuan | 2018年7月16日

运行时：

[root@bigdata1 shell]# pwd
/script/shell
[root@bigdata1 shell]# ls -ltr
total 12
-rw-r--r-- 1 root root 5012 Jul 16 13:48 calc_resource.sh
drwxr-xr-x 2 root root 4096 Jul 16 13:51 2018-07-16_13:48:36
[root@bigdata1 shell]# 
[root@bigdata1 shell]# sh calc_resource.sh 

=====================
Memory status
=====================

Memory used - [65.00]%
Memory free - [34.00]%

=====================
Swap status
=====================

Swap used - [0]%
Swap free - [0]%

=====================
CPU status
=====================

CPU Usage - Busy - [9.5]%
CPU Usage - idle - [90.5]%

=====================
If : CPU busy is larger enough
Then : do
=====================

CPU usage is [BUSY]
-----------
Current Path = [/script/shell]
Top 10 - CPU = file [/script/shell/2018-07-16_13:53:15/process_top10_cpu_2018-07-16_13:53:15]
Top 10 - Memory = file [/script/shell/2018-07-16_13:53:15/process_top10_memory_2018-07-16_13:53:15]
Top 10 - Virutal Memory = file [/script/shell/2018-07-16_13:53:15/process_top10_v_mem_2018-07-16_13:53:15]
Top status = file[/script/shell/2018-07-16_13:53:15/top_status_2018-07-16_13:53:15]
----> do: TOP
----> do: CPU
----> do: Memory
----> do: Virtual Memory
[root@bigdata1 shell]# 
[root@bigdata1 shell]# ls -ltr
total 16
-rw-r--r-- 1 root root 5012 Jul 16 13:48 calc_resource.sh
drwxr-xr-x 2 root root 4096 Jul 16 13:51 2018-07-16_13:48:36
drwxr-xr-x 2 root root 4096 Jul 16 13:53 2018-07-16_13:53:15
[root@bigdata1 shell]# 
[root@bigdata1 shell]# ls -ltr 2018-07-16_13\:48\:36/
total 164
-rw-r--r-- 1 root root 47808 Jul 16 13:48 top_status_2018-07-16_13:48:36
-rw-r--r-- 1 root root 35455 Jul 16 13:48 process_top10_cpu_2018-07-16_13:48:36
-rw-r--r-- 1 root root 37007 Jul 16 13:48 process_top10_memory_2018-07-16_13:48:36
-rw-r--r-- 1 root root 36961 Jul 16 13:48 process_top10_v_mem_2018-07-16_13:48:36
[root@bigdata1 shell]# 
[root@bigdata1 shell]# ls -ltr 2018-07-16_13\:53\:15/
total 164
-rw-r--r-- 1 root root 47808 Jul 16 13:53 top_status_2018-07-16_13:53:15
-rw-r--r-- 1 root root 35455 Jul 16 13:53 process_top10_cpu_2018-07-16_13:53:15
-rw-r--r-- 1 root root 37007 Jul 16 13:53 process_top10_memory_2018-07-16_13:53:15
-rw-r--r-- 1 root root 36961 Jul 16 13:53 process_top10_v_mem_2018-07-16_13:53:15
[root@bigdata1 shell]#

[root@bigdata1 shell]# pwd

/script/shell

[root@bigdata1 shell]# ls -ltr

total 12

-rw-r--r-- 1 root root 5012 Jul 16 13:48 calc_resource.sh

drwxr-xr-x 2 root root 4096 Jul 16 13:51 2018-07-16_13:48:36

[root@bigdata1 shell]#

[root@bigdata1 shell]# sh calc_resource.sh

=====================

Memory status

=====================

Memory used - [65.00]%

Memory free - [34.00]%

=====================

Swap status

=====================

Swap used - [0]%

Swap free - [0]%

=====================

CPU status

=====================

CPU Usage - Busy - [9.5]%

CPU Usage - idle - [90.5]%

=====================

If : CPU busy is larger enough

Then : do

=====================

CPU usage is [BUSY]

-----------

Current Path = [/script/shell]

Top 10 - CPU = file [/script/shell/2018-07-16_13:53:15/process_top10_cpu_2018-07-16_13:53:15]

Top 10 - Memory = file [/script/shell/2018-07-16_13:53:15/process_top10_memory_2018-07-16_13:53:15]

Top 10 - Virutal Memory = file [/script/shell/2018-07-16_13:53:15/process_top10_v_mem_2018-07-16_13:53:15]

Top status = file[/script/shell/2018-07-16_13:53:15/top_status_2018-07-16_13:53:15]

----> do: TOP

----> do: CPU

----> do: Memory

----> do: Virtual Memory

[root@bigdata1 shell]#

[root@bigdata1 shell]# ls -ltr

total 16

-rw-r--r-- 1 root root 5012 Jul 16 13:48 calc_resource.sh

drwxr-xr-x 2 root root 4096 Jul 16 13:51 2018-07-16_13:48:36

drwxr-xr-x 2 root root 4096 Jul 16 13:53 2018-07-16_13:53:15

[root@bigdata1 shell]#

[root@bigdata1 shell]# ls -ltr 2018-07-16_13\:48\:36/

total 164

-rw-r--r-- 1 root root 47808 Jul 16 13:48 top_status_2018-07-16_13:48:36

-rw-r--r-- 1 root root 35455 Jul 16 13:48 process_top10_cpu_2018-07-16_13:48:36

-rw-r--r-- 1 root root 37007 Jul 16 13:48 process_top10_memory_2018-07-16_13:48:36

-rw-r--r-- 1 root root 36961 Jul 16 13:48 process_top10_v_mem_2018-07-16_13:48:36

[root@bigdata1 shell]#

[root@bigdata1 shell]# ls -ltr 2018-07-16_13\:53\:15/

total 164

-rw-r--r-- 1 root root 47808 Jul 16 13:53 top_status_2018-07-16_13:53:15

-rw-r--r-- 1 root root 35455 Jul 16 13:53 process_top10_cpu_2018-07-16_13:53:15

-rw-r--r-- 1 root root 37007 Jul 16 13:53 process_top10_memory_2018-07-16_13:53:15

-rw-r--r-- 1 root root 36961 Jul 16 13:53 process_top10_v_mem_2018-07-16_13:53:15

[root@bigdata1 shell]#

脚本代码：

# file_name: calc_cpu_memory_processes
# Detect CPU or Memory is high, whitch processes is majorn problem.

# variable

# Meta info
string_date=$(date "+%Y-%m-%d_%H:%M:%S")
string_path_current=$(cd $(dirname $0); pwd)
file_script_log=$string_path_current/$string_date/script_log_$string_date

# Memory
# free -m
memory_used=$(free -m | grep "buffers/cache" | awk '{print $3}')
memory_free=$(free -m | grep "buffers/cache" | awk '{print $4}')
memory_total=$(free -m | grep "Mem" | awk '{print $2}')

f_memory_percent_used=0
f_memory_percent_free=0

# Swap
swap_used=$(free -m | grep "Swap" | awk '{print $3}')
swap_free=$(free -m | grep "Swap" | awk '{print $4}')
swap_total=$(free -m | grep "Swap" | awk '{print $2}')

f_swap_percent_used=0
f_swap_percent_free=0

# CPU

cpu_processes_list=$(cat /proc/cpuinfo | grep processor)
cpu_percent_topview_idle=$(top -b -d 1 -n 1 | grep "Cpu" | awk '{print $5}' | cut -d'%' -f1)

f_cpu_topview_percent_busy=0

cpu_busy_percent_edge=9

# function

func_if_cpu_busy_larger_then_do(){

  # init
  echo ""
  echo "====================="
  echo "If : CPU busy is larger enough"
  echo "Then : do"
  echo "-------"
  echo "Current : busy percent: [$f_cpu_topview_percent_busy]%" >> $file_script_log
  echo "Edge : busy percent: [$cpu_busy_percent_edge]%" >> $file_script_log
  echo "=====================" >> $file_script_log
  echo ""

  # variable

  # current
  #input_cpu_current="$1"
  #input_cpu_edge="$2"

  #if [ "$f_cpu_topview_percent_busy" -gt "$cpu_busy_percent_edge" ]
  if [  `echo "$f_cpu_topview_percent_busy > $cpu_busy_percent_edge" | bc` -eq 1 ]
  then
    echo "CPU usage is [BUSY]"
    echo "-----------"
    echo "Current Path = [$string_path_current]"

    # do mkdir
    #mkdir $string_path_current/$string_date

    # variable
    file_process_top10_cpu=$string_path_current/$string_date/process_top10_cpu_$string_date
    file_process_top10_memory=$string_path_current/$string_date/process_top10_memory_$string_date
    file_process_top10_v_mem=$string_path_current/$string_date/process_top10_v_mem_$string_date
    file_top_status=$string_path_current/$string_date/top_status_$string_date

    # display
    echo "Top 10 - CPU = file [$file_process_top10_cpu]"
    echo "Top 10 - Memory = file [$file_process_top10_memory]"
    echo "Top 10 - Virutal Memory = file [$file_process_top10_v_mem]"

    echo "Top status = file[$file_top_status]"

    # do

    # Top status
    echo "----> do: TOP"

    echo "Top status" > $file_top_status
    echo "=========================================" >> $file_top_status
    top -b -d 1 -n 1 >> $file_top_status

    # top10 - cpu
    echo "----> do: CPU"

    echo "Top10 - CPU" > $file_process_top10_cpu
    ps auxw|head -1 >> $file_process_top10_cpu
    echo "=========================================" >> $file_process_top10_cpu
    ps auxw|sort -rn -k3|head -10 >> $file_process_top10_cpu

    # top10 - memory
    echo "----> do: Memory"

    echo "Top10 - Memory" > $file_process_top10_memory
    ps auxw|head -1 >> $file_process_top10_memory
    echo "=========================================" >> $file_process_top10_memory
    ps auxw|sort -rn -k4|head -10 >> $file_process_top10_memory

    # top10 - virtual memory
    echo "----> do: Virtual Memory"

    echo "Top10 - Virtual Memory" > $file_process_top10_v_mem
    ps auxw|head -1 >> $file_process_top10_v_mem
    echo "=========================================" >> $file_process_top10_v_mem
    ps auxw|sort -rn -k5|head -10 >> $file_process_top10_v_mem

  fi

}

func_cpu_percent_single(){

  # variable
  # 需要过滤的【mpstat】的标记
  f_input_signal="$1"

  # 依赖命令：mpstat
  # 该命令不是每个Linux都有的

  # 该函数没有写完，后面补全

}

func_cpu_usage(){

  # init
  echo "" >> $file_script_log
  echo "=====================" >> $file_script_log
  echo "CPU status" >> $file_script_log
  echo "=====================" >> $file_script_log
  echo "" >> $file_script_log

  # 依赖命令：top
  # Command:
  # top -b -d 1 -n 1

  f_cpu_topview_percent_busy=$(echo "scale=2;100-$cpu_percent_topview_idle" | bc)

  # display
  echo "CPU Usage - Busy - [$f_cpu_topview_percent_busy]%" >> $file_script_log
  echo "CPU Usage - idle - [$cpu_percent_topview_idle]%" >> $file_script_log

}

func_swap_percent_and_display() {

  # init
  echo "" >> $file_script_log
  echo "=====================" >> $file_script_log
  echo "Swap status" >> $file_script_log
  echo "=====================" >> $file_script_log
  echo "" >> $file_script_log

  # calc
  if [ $swap_total != "0" ]
  then
    f_swap_percent_used=$(echo "scale=2;($swap_used/$swap_total)*100" | bc)
    f_swap_percent_free=$(echo "scale=2;($swap_free/$swap_total)*100" | bc)
  fi

  # display
  echo "Swap used - [$f_swap_percent_used]%" >> $file_script_log
  echo "Swap free - [$f_swap_percent_free]%" >> $file_script_log

}

func_memory_percent_and_display() {

  # init
  echo "" >> $file_script_log
  echo "=====================" >> $file_script_log
  echo "Memory status" >> $file_script_log
  echo "=====================" >> $file_script_log
  echo "" >> $file_script_log

  # calc
  if [ $memory_total != "0" ]
  then
    f_memory_percent_used=$(echo "scale=2;($memory_used/$memory_total)*100" | bc)
    f_memory_percent_free=$(echo "scale=2;($memory_free/$memory_total)*100" | bc)
  fi

  # display
  echo "Memory used - [$f_memory_percent_used]%" >> $file_script_log
  echo "Memory free - [$f_memory_percent_free]%" >> $file_script_log

}

# do

# mkdir
# do mkdir
mkdir $string_path_current/$string_date

# Memory
func_memory_percent_and_display

# Swap
func_swap_percent_and_display

# CPU
func_cpu_usage

# if CPU busy is larger, then
func_if_cpu_busy_larger_then_do

# 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

# file_name: calc_cpu_memory_processes

# Detect CPU or Memory is high, whitch processes is majorn problem.

# variable

# Meta info

string_date=$(date "+%Y-%m-%d_%H:%M:%S")

string_path_current=$(cd $(dirname $0); pwd)

file_script_log=$string_path_current/$string_date/script_log_$string_date

# Memory

# free -m

memory_used=$(free -m | grep "buffers/cache" | awk '{print $3}')

memory_free=$(free -m | grep "buffers/cache" | awk '{print $4}')

memory_total=$(free -m | grep "Mem" | awk '{print $2}')

f_memory_percent_used=0

f_memory_percent_free=0

# Swap

swap_used=$(free -m | grep "Swap" | awk '{print $3}')

swap_free=$(free -m | grep "Swap" | awk '{print $4}')

swap_total=$(free -m | grep "Swap" | awk '{print $2}')

f_swap_percent_used=0

f_swap_percent_free=0

# CPU

cpu_processes_list=$(cat /proc/cpuinfo | grep processor)

cpu_percent_topview_idle=$(top -b -d 1 -n 1 | grep "Cpu" | awk '{print $5}' | cut -d'%' -f1)

f_cpu_topview_percent_busy=0

cpu_busy_percent_edge=9

# function

func_if_cpu_busy_larger_then_do(){

# init

echo ""

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

echo "If : CPU busy is larger enough"

echo "Then : do"

echo "-------"

echo "Current : busy percent: [$f_cpu_topview_percent_busy]%" >> $file_script_log

echo "Edge : busy percent: [$cpu_busy_percent_edge]%" >> $file_script_log

echo "=====================" >> $file_script_log

echo ""

# variable

# current

#input_cpu_current="$1"

#input_cpu_edge="$2"

#if [ "$f_cpu_topview_percent_busy" -gt "$cpu_busy_percent_edge" ]

if [ `echo "$f_cpu_topview_percent_busy > $cpu_busy_percent_edge" | bc` -eq 1 ]

then

echo "CPU usage is [BUSY]"

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

echo "Current Path = [$string_path_current]"

# do mkdir

#mkdir $string_path_current/$string_date

# variable

file_process_top10_cpu=$string_path_current/$string_date/process_top10_cpu_$string_date

file_process_top10_memory=$string_path_current/$string_date/process_top10_memory_$string_date

file_process_top10_v_mem=$string_path_current/$string_date/process_top10_v_mem_$string_date

file_top_status=$string_path_current/$string_date/top_status_$string_date

# display

echo "Top 10 - CPU = file [$file_process_top10_cpu]"

echo "Top 10 - Memory = file [$file_process_top10_memory]"

echo "Top 10 - Virutal Memory = file [$file_process_top10_v_mem]"

echo "Top status = file[$file_top_status]"

# do

# Top status

echo "----> do: TOP"

echo "Top status" > $file_top_status

echo "=========================================" >> $file_top_status

top -b -d 1 -n 1 >> $file_top_status

# top10 - cpu

echo "----> do: CPU"

echo "Top10 - CPU" > $file_process_top10_cpu

ps auxw|head -1 >> $file_process_top10_cpu

echo "=========================================" >> $file_process_top10_cpu

ps auxw|sort -rn -k3|head -10 >> $file_process_top10_cpu

# top10 - memory

echo "----> do: Memory"

echo "Top10 - Memory" > $file_process_top10_memory

ps auxw|head -1 >> $file_process_top10_memory

echo "=========================================" >> $file_process_top10_memory

ps auxw|sort -rn -k4|head -10 >> $file_process_top10_memory

# top10 - virtual memory

echo "----> do: Virtual Memory"

echo "Top10 - Virtual Memory" > $file_process_top10_v_mem

ps auxw|head -1 >> $file_process_top10_v_mem

echo "=========================================" >> $file_process_top10_v_mem

ps auxw|sort -rn -k5|head -10 >> $file_process_top10_v_mem

}

func_cpu_percent_single(){

# variable

# 需要过滤的【mpstat】的标记

f_input_signal="$1"

# 依赖命令：mpstat

# 该命令不是每个Linux都有的

# 该函数没有写完，后面补全

}

func_cpu_usage(){

# init

echo "" >> $file_script_log

echo "=====================" >> $file_script_log

echo "CPU status" >> $file_script_log

echo "=====================" >> $file_script_log

echo "" >> $file_script_log

# 依赖命令：top

# Command:

# top -b -d 1 -n 1

f_cpu_topview_percent_busy=$(echo "scale=2;100-$cpu_percent_topview_idle" | bc)

# display

echo "CPU Usage - Busy - [$f_cpu_topview_percent_busy]%" >> $file_script_log

echo "CPU Usage - idle - [$cpu_percent_topview_idle]%" >> $file_script_log

}

func_swap_percent_and_display() {

# init

echo "" >> $file_script_log

echo "=====================" >> $file_script_log

echo "Swap status" >> $file_script_log

echo "=====================" >> $file_script_log

echo "" >> $file_script_log

# calc

if [ $swap_total != "0" ]

then

f_swap_percent_used=$(echo "scale=2;($swap_used/$swap_total)*100" | bc)

f_swap_percent_free=$(echo "scale=2;($swap_free/$swap_total)*100" | bc)

# display

echo "Swap used - [$f_swap_percent_used]%" >> $file_script_log

echo "Swap free - [$f_swap_percent_free]%" >> $file_script_log

}

func_memory_percent_and_display() {

# init

echo "" >> $file_script_log

echo "=====================" >> $file_script_log

echo "Memory status" >> $file_script_log

echo "=====================" >> $file_script_log

echo "" >> $file_script_log

# calc

if [ $memory_total != "0" ]

then

f_memory_percent_used=$(echo "scale=2;($memory_used/$memory_total)*100" | bc)

f_memory_percent_free=$(echo "scale=2;($memory_free/$memory_total)*100" | bc)

# display

echo "Memory used - [$f_memory_percent_used]%" >> $file_script_log

echo "Memory free - [$f_memory_percent_free]%" >> $file_script_log

}

# do

# mkdir

# do mkdir

mkdir $string_path_current/$string_date

# Memory

func_memory_percent_and_display

# Swap

func_swap_percent_and_display

# CPU

func_cpu_usage

# if CPU busy is larger, then

func_if_cpu_busy_larger_then_do

# done

# Finished.

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

密码保护：Shell：MySQL – 备份【Binlog】

By Adamhuan | 2018年7月5日

0 Comment

无法提供摘要。这是一篇受保护的文章。

SHELL + MySQL：MySQL – 备份脚本

By Adamhuan | 2018年6月28日

0 Comment

直接看代码：

#!/bin/bash

# File name : mysql_backup.sh

# variable
  # Time
str_date=$(date "+%Y%m%d_%H_%M_%S")
  # File and Path
path_data_backup=/cloudera/backup
  # MySQL
mysql_user=root
mysql_passwd="*****"

# function
function do_mysql_backup_single(){
  # intro
  echo "%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%"

  # variable
  f_schema="$1"

  f_file_file=$path_data_backup"/MySQL_db_backup_SINGLE_"$f_schema"."$str_date
  f_file_log=$f_file_file".log"

  # display
  echo "*******"
  echo "file is: [$f_file_file]"
  echo "log is: [$f_file_log]"

  echo "0000000000000" | tee -a $f_file_log
  echo "MySQL backup - schema [$f_schema]" | tee -a $f_file_log
  echo "Date time - Begin: [$str_date]" | tee -a $f_file_log
  echo "0000000000000" | tee -a $f_file_log
  echo "" | tee -a $f_file_log

  # do backup
  mysqldump -u$mysql_user -p$mysql_passwd --lock-tables --events --databases $f_schema > $f_file_file | tee -a $f_file_log

  # end
  echo "Date time - Finished: [$str_date]" | tee -a $f_file_log

}

function do_mysql_backup_list(){

  # intro
  echo "%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%"

  # variable
  f_list_schema="$1"
  f_schema_array=(${f_list_schema//,/ })
  f_schema_string_with_space=""

  f_file_name="$2"

  # do
  for schema_list_item in ${f_schema_array[@]}
  do
    #echo "============="
    #echo "Current is: [$schema_list_item]"

    # do
    #do_mysql_backup_single $schema_list_item
    f_schema_string_with_space+=$schema_list_item" "

  done
  echo "Schema List with Space : [$f_schema_string_with_space]"

  f_file_file=$path_data_backup"/MySQL_db_backup_LIST_"$f_file_name"."$str_date
  f_file_log=$f_file_file".log"

  # display
  echo "*******"
  echo "file is: [$f_file_file]"
  echo "log is: [$f_file_log]"

  echo "0000000000000" | tee -a $f_file_log
  echo "MySQL backup - schema [$f_schema_string_with_space]" | tee -a $f_file_log
  echo "Date time - Begin: [$str_date]" | tee -a $f_file_log
  echo "0000000000000" | tee -a $f_file_log
  echo "" | tee -a $f_file_log

  # do backup
  #mysqldump -u$mysql_user -p$mysql_passwd --lock-tables --databases $f_schema_string_with_space > $f_file_file | tee -a $f_file_log
  mysqldump -u$mysql_user -p$mysql_passwd --lock-tables --skip-lock-tables --databases $f_schema_string_with_space > $f_file_file | tee -a $f_file_log

  # end
  echo "Date time - Finished: [$str_date]" | tee -a $f_file_log

}

# begin

  # do backup
do_mysql_backup_list "people god devil" "business_data"
do_mysql_backup_list "mysql performance_schema sys" "mysql_metadata"

# end


# finished

100

101

#!/bin/bash

# File name : mysql_backup.sh

# variable

# Time

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

# File and Path

path_data_backup=/cloudera/backup

# MySQL

mysql_user=root

mysql_passwd="*****"

# function

function do_mysql_backup_single(){

# intro

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

# variable

f_schema="$1"

f_file_file=$path_data_backup"/MySQL_db_backup_SINGLE_"$f_schema"."$str_date

f_file_log=$f_file_file".log"

# display

echo "*******"

echo "file is: [$f_file_file]"

echo "log is: [$f_file_log]"

echo "0000000000000" | tee -a $f_file_log

echo "MySQL backup - schema [$f_schema]" | tee -a $f_file_log

echo "Date time - Begin: [$str_date]" | tee -a $f_file_log

echo "0000000000000" | tee -a $f_file_log

echo "" | tee -a $f_file_log

# do backup

mysqldump -u$mysql_user -p$mysql_passwd --lock-tables --events --databases $f_schema > $f_file_file | tee -a $f_file_log

# end

echo "Date time - Finished: [$str_date]" | tee -a $f_file_log

}

function do_mysql_backup_list(){

# intro

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

# variable

f_list_schema="$1"

f_schema_array=(${f_list_schema//,/ })

f_schema_string_with_space=""

f_file_name="$2"

# do

for schema_list_item in ${f_schema_array[@]}

#echo "============="

#echo "Current is: [$schema_list_item]"

# do

#do_mysql_backup_single $schema_list_item

f_schema_string_with_space+=$schema_list_item" "

done

echo "Schema List with Space : [$f_schema_string_with_space]"

f_file_file=$path_data_backup"/MySQL_db_backup_LIST_"$f_file_name"."$str_date

f_file_log=$f_file_file".log"

# display

echo "*******"

echo "file is: [$f_file_file]"

echo "log is: [$f_file_log]"

echo "0000000000000" | tee -a $f_file_log

echo "MySQL backup - schema [$f_schema_string_with_space]" | tee -a $f_file_log

echo "Date time - Begin: [$str_date]" | tee -a $f_file_log

echo "0000000000000" | tee -a $f_file_log

echo "" | tee -a $f_file_log

# do backup

#mysqldump -u$mysql_user -p$mysql_passwd --lock-tables --databases $f_schema_string_with_space > $f_file_file | tee -a $f_file_log

mysqldump -u$mysql_user -p$mysql_passwd --lock-tables --skip-lock-tables --databases $f_schema_string_with_space > $f_file_file | tee -a $f_file_log

# end

echo "Date time - Finished: [$str_date]" | tee -a $f_file_log

}

# begin

# do backup

do_mysql_backup_list "people god devil" "business_data"

do_mysql_backup_list "mysql performance_schema sys" "mysql_metadata"

# end

# finished

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

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

By Adamhuan | 2018年6月13日

0 Comment

使用的时候：
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。

Cobbler Server：自动修改IP设定

By Adamhuan | 2018年6月11日

0 Comment

Cobbler Server所在的主机如果IP地址改掉了，那么Cobbler服务端也是需要做出相应变更的。

下面的脚本可以让你一键完成所有关于IP变更的配置：
使用方法：
auto_cobbler_change_ip.sh [新的IP地址]

如：
auto_cobbler.sh19[……]