shell实现mysql快捷环境切换

脚本文件结构

db_common_envs 存储mysql环境变量设置

dblist.txt 存储mysql列表

dblogin.sh 快捷脚本

dblogin.sh

i=1

if [ ! -z $1 ];then
   cat /data/dbadmin/dblogin/dblist.txt|grep -i "${1}" > /tmp/dblist.tmp
else
   cat /data/dbadmin/dblogin/dblist.txt > /tmp/dblist.tmp
fi

while read line
do
   inst_name=`echo $line |awk '{print $1}'`
   inst_host=`echo $line |awk '{print $2}'`
   admin_user=`echo $line |awk '{print $3}'`
   admin_pass=`echo $line |awk '{print $4}'`
   printf "%-5s --Instance: %-30s --Host: %-30s\n" ${i} ${inst_name} ${inst_host}
   alias ${i}="export my_inst=${inst_name};export my_host=${inst_host};export my_adm_user=${admin_user};export my_adm_pass=${admin_pass};source /data/dbadmin/dblogin/db_common_envs"
   let i=i+1
done < /tmp/dblist.tmp

db_common_envs

#######label 

echo "####################################################"
echo "  production db envs, pay attention before operate  "
echo "                 ${my_inst}                         "
echo "####################################################"

alias ?="echo ${my_inst}"
alias mysql="mysql -h${my_host} -P3306 -udbsearch -pY6e29uZ1bb"
alias my_sql="mysql -h${my_host} -P3306 -u${my_adm_user} -p${my_adm_pass}"
alias innotop="innotop -h${my_host}  -P3306 -u${my_adm_user} -p${my_adm_pass} -d1 -m Q"
alias orzdba="orzdba_remote --host=${my_host} --user=${my_adm_user}  --password='${my_adm_pass}'  --port=3306 -mysql -sys --innodb --lazy"
alias pt_kill="echo pt-kill --host=${my_host}  --port=3306 --user=${my_adm_user} --password=${my_adm_pass} --interval=5  --victims all --match-host/--match-user/--match-info"

dblist.txt

标签名      地址        用户名     密码       库名列表

环境变量

vi ~/.bashrc
alias db='source /data/dbadmin/dblogin/dblogin.sh'