13518219792
文件: allstop.sh allstart.sh
路径 $HOME/ggscript/ggoperat
l运维OGG过程中，曾经遇到非数据同步运维同事需要配合数据库DBA维护启停所有数据同步链路的情况
因此特别编写了这两套全进程启停脚本，一套用于全进程停止，会调用长事务跳过脚本，跳过长事务，以及停止进程和MGR监控进程。一套用于全部OGG进程启动。
allstop.sh
#!/bin/bash echo $dir cd $HOME/ggscript/ggoperat dir=$PWD cd $HOME if [ -f .profile ];then . .profile fi if [ -f .bash_profile ];then . .bash_profile fi cd $dir echo "All process will be stop! Are you sure will do this job?(press any key to continue)" select ch in "yes" "no" do case $ch in "yes") echo "execute the process stop operation" break; ;; "no") echo "process break" exit 2; ;; *) echo "Please select your choice :1.yes.2.no" ;; esac done; cd $HOME/ggserver (echo info all;echo exit)|./ggsci|grep "EXTRACT" |awk 'BEGIN {FS=" +"} {print $3}'|grep '^E' > $dir/extract (echo info all;echo exit)|./ggsci|grep -E "EXTRACT|REPLICAT" |awk 'BEGIN {FS=" +"} {print $3}' > $dir/process cd $dir i=1 NUX=`sed -n '$=' extract` #if [ "$i" -le "$NUX" ];then while(($i<=$NUX)); do ext=`sed -n $i'p' extract` echo $ext /bin/bash $HOME/ggscript/ggtrandata/skip.sh $ext ((i++)); done cd $dir i=1 NUX=`sed -n '$=' process` echo "nux=$NUX" cat /dev/null > $HOME/ggserver/dirdat/stop while(($i<=$NUX)); do ext=`sed -n $i'p' process` echo $ext echo "stop $ext" >> $HOME/ggserver/dirdat/stop ((i++)); done rm -f extract rm -f process cd $HOME/ggserver (echo obey dirdat/stop; echo exit)|./ggsci (echo stop mgr;echo y;echo exit)|./ggsciallstart.sh
#!/bin/bash echo $dir cd $HOME/ggscript/ggoperat dir=$PWD cd $HOME if [ -f .profile ];then . .profile fi if [ -f .bash_profile ];then . .bash_profile fi cd $dir cd $HOME/ggserver (echo START mgr;echo exit)|./ggsci (echo info all;echo exit)|./ggsci|grep "EXTRACT" |awk 'BEGIN {FS=" +"} {print $3}' > $dir/process (echo info all;echo exit)|./ggsci|grep "REPLICAT" |awk 'BEGIN {FS=" +"} {print $3}' >> $dir/process cd $dir i=1 NUX=`sed -n '$=' process` while(($i<=$NUX)); do ext=`sed -n $i'p' process` echo $ext /bin/bash $HOME/ggscript/ggoperat/start.sh $ext ((i++)); done另外有需要云服务器可以了解下创新互联cdcxhl.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。
