Mysql应用MySQL的一些功能实用的Linux shell脚本分享

概述介绍《Mysql应用MySQL的一些功能实用的Linux shell脚本分享》开发教程，希望对您有用。

《MysqL应用MysqL的一些功能实用的linux shell脚本分享》要点：
本文介绍了MysqL应用MysqL的一些功能实用的linux shell脚本分享，希望对您有用。如果有疑问，可以联系我们。

MysqL教程Memcached启动脚本

MysqL教程# vim /etc/init.d/memcached

MysqL教程#!/bin/bash#=======================================================================================# chkconfig: - 80 12# description: distributed memory caching daemon# processname: memcached#=======================================================================================IPADDR=`/sbin/ifconfig eth1 | awk -F ':' '/inet addr/{print $2}' | sed 's/[a-zA-Z ]//g'`PORT="11211"USER="root"SIZE="2048"CONNNUM="51200"PIDfile="/var/run/memcached.pID"BINfile="/usr/local/memcached/bin/memcached"LOCKfile="/var/lock/subsys/memcached"RETVAL=0      start() {  echo -n $"Starting memcached......"  $BINfile -d -l $IPADDR -p $PORT -u $USER -m $SIZE -c $CONNNUM -P $PIDfile  RETVAL=$?  echo  [ $RETVAL -eq 0 ] && touch $LOCKfile          return $RETVAL}      stop() {  echo -n $"Shutting down memcached......"  /sbin/killproc $BINfile  RETVAL=$?  echo  [ $RETVAL -eq 0 ] && rm -f $LOCKfile          return $RETVAL}      restart() {  stop  sleep 1  start}      reload() {  echo -n $"Reloading memcached......"  /sbin/killproc $BINfile -HUP  RETVAL=$?  echo          return $RETVAL}      case "$1" instart)  start  ;;        stop)  stop  ;;        restart)  restart  ;;        condrestart)  [ -e $LOCKfile ] && restart  RETVAL=$?  ;;        reload)  reload  ;;        status)  status $prog  RETVAL=$?  ;;        *)  echo "Usage: $0 {start|stop|restart|condrestart|status}"  RETVAL=1esac

MysqL教程           

MysqL教程exit $RETVAL# chmod +x /etc/init.d/memcached# chkconfig --add memcached# chkconfig --level 235 memcached on# service memcached start

MysqL教程binlog 自动清理脚本

MysqL教程# vim /data/scripts/delete_MysqL_binlog.sh

MysqL教程#!/bin/bash#=======================================================================================#  用于删除 MysqL Master 端已经同步完的 binlog【需在 Master 端运行】,以减少磁盘空间#  每天凌晨 5:30 分运行一次##  注：需在 Slave 端添加允许 Master 端访问的帐号【帐号：check_binlog,暗码：binlog_2356】#     运行于 MysqL Master 端【目前只用于一主一从的同步模式,对于多从的情况暂时未考虑】#=======================================================================================PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin   ## Slave端连接信息SLAVE_ADDR="XXX.XXX.XXX.XXX"SLAVE_USER="check_binlog"SLAVE_PWD="binlog_2356"   LOGfile="/data/logs/db_sync_info.log"Pingfile="/tmp/MysqLPing.log"   ## MysqL状态信息查看命令sqlCMD="show slave status"   #=======================================================================================## 检查MysqL是否已经运行if [[ `ps aux | grep MysqL[d] | wc -l` -eq 0 ]]; then  echo The MysqL is not running at: `date +%F" "%H-%M-%s` >> ${LOGfile}  exit 1fi   ## 测试Slave端的连通性nohup MysqLadmin -h${SLAVE_ADDR} -u${SLAVE_USER} -p${SLAVE_PWD} Ping > ${Pingfile}retval=`grep "^error" ${Pingfile}`rm -f ${Pingfile}if [[ "${retval}X" != "X" ]]; then  echo The MysqL Slave can not be connected at: `date +%F" "%H-%M-%s` >> ${LOGfile}  exit 1fi   ## 检查是否合法的SlaveMASTER_ADDR=`MysqL -h${SLAVE_ADDR} -u${SLAVE_USER} -p${SLAVE_PWD} -e "${sqlCMD}\G;" | awk '$1=="Master_Host:" {print $2}'`LOCAL_ADDR=`/sbin/ifconfig eth1 | awk -F ':' '/inet addr/{print $2}' | sed 's/[a-zA-Z ]//g'`if [[ "${MASTER_ADDR}" != "${LOCAL_ADDR}" ]]; then  echo The MysqL Slave is not lawful at: `date +%F" "%H-%M-%s` >> ${LOGfile}  exit 1fi   ## 获得Slave端信息,以此来确定是否处于正常同步的情况IO_STATUS=`MysqL -h${SLAVE_ADDR} -u${SLAVE_USER} -p${SLAVE_PWD} -e "${sqlCMD}\G;" | awk '$1=="Slave_IO_Running:" {print $2}'`sql_STATUS=`MysqL -h${SLAVE_ADDR} -u${SLAVE_USER} -p${SLAVE_PWD} -e "${sqlCMD}\G;" | awk '$1=="Slave_sql_Running:" {print $2}'`if [[ "${IO_STATUS}" != "Yes" || "${sql_STATUS}" != "Yes" ]]; then  echo The MysqL Replication is not synchronous at: `date +%F" "%H-%M-%s` >> ${LOGfile}  exit 1fi   ## 再做一次判断,以保证数据同步绝对正常【创建测试数据】MysqL -uroot -e "create database if not exists mytestdb;"sleep 3   retval=`MysqL -h${SLAVE_ADDR} -u${SLAVE_USER} -p${SLAVE_PWD} -e "show databases;" | grep mytestdb`MysqL -uroot -e "drop database if exists mytestdb;"if [[ "${retval}X" = "X" ]]; then  echo The MysqL Replication is not synchronous at: `date +%F" "%H-%M-%s` >> ${LOGfile}  exit 1fi   ## 在已经同步的情况,还需要判断当前同步的binlog,以此来确定哪些已经是过期的binlogSLAVE_binlog1=`MysqL -h${SLAVE_ADDR} -u${SLAVE_USER} -p${SLAVE_PWD} -e "${sqlCMD}\G;" | awk '$1=="Master_Log_file:" {print $2}'`SLAVE_binlog2=`MysqL -h${SLAVE_ADDR} -u${SLAVE_USER} -p${SLAVE_PWD} -e "${sqlCMD}\G;" | awk '$1=="Relay_Master_Log_file:" {print $2}'`## 获得Master端,当前的binlog文件以及binlog路径MASTER_binlog=`MysqL -uroot -e "show master status;" | grep -v '^+' | tail -1 | awk '{print $1}'`   ## 主从端已经同步到相同的binlogif [[ "${SLAVE_binlog1}" = "${SLAVE_binlog2}" && "${SLAVE_binlog1}" = "${MASTER_binlog}" ]]; then  CURR_binlog="${MASTER_binlog}"     ## 主从端已经同步,但从端的binlog还没有追赶到主端最新的binlogelif [[ "${SLAVE_binlog1}" = "${SLAVE_binlog2}" && "${SLAVE_binlog1}" != "${MASTER_binlog}" ]]; then  CURR_binlog="${SLAVE_binlog1}"     ## 主从端已经同步,主从端的binlog一致,但relaylog还不一致elif [[ "${SLAVE_binlog1}" != "${SLAVE_binlog2}" && "${SLAVE_binlog1}" = "${MASTER_binlog}" ]]; then  CURR_binlog="${SLAVE_binlog2}"     else  echo Has nokNown error at：`date +%F" "%H-%M-%s` >> ${LOGfile}  exit 1fi   MysqL -uroot -e "purge binary logs to '${CURR_binlog}';"if [[ $? -eq 0 ]]; then  echo Clear MysqL binlog is ok at: `date +%F" "%H-%M-%s` >> ${LOGfile}fi

MysqL教程# crontab -e 30 05 * * * /data/scripts/delete_MysqL_binlog.sh >/dev/null 2>&1

MysqL教程修复MysqL主从同步

MysqL教程#!/bin/shPATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin  LOGfile=/data/repair_MysqL_sync_`date +%F`.logsqlCMD1="show slave status"  ## 查看MysqL是否已启动if [[ `ps aux | grep MysqLd | grep -v grep`"X" = "X" ]]; then  echo The MysqL is not running at: `date +%F" "%H-%M-%s` >> ${LOGfile}  exit 1fi  ## 获得MysqL从端Relay binlog的路径retval=`grep "^relay-log" /etc/my.cnf | grep -v relay-log- | grep '/'`if [[ "${retval}" = "X" ]]; then  RELAY_binlog_PATH=`ps aux | grep -w MysqLd | grep -v grep | awk '{print $13}' | awk -F '=' '{print $2}'`else  RELAY_binlog_PATH=`dirname $(echo ${retval} | awk -F '=' '{print $2}')`fi  ## 查找master.info文件,用于定位binlog信息MASTER_file=`ps aux | grep -w MysqLd | grep -v grep | awk '{print $13}' | awk -F '=' '{print $2}'`/master.infoif [[ ! -e ${MASTER_file} ]]; then  echo This Server is not MysqL Slave at: `date +%F" "%H-%M-%s` >> ${LOGfile}  exit 1fi  ## 获得当前的同步状态IO_STATUS=`MysqL -uroot -e "${sqlCMD1}\G;" | awk '$1=="Slave_IO_Running:" {print $2}'`sql_STATUS=`MysqL -uroot -e "${sqlCMD1}\G;" | awk '$1=="Slave_sql_Running:" {print $2}'`if [[ "${IO_STATUS}" = "Yes" && "${sql_STATUS}" = "Yes" ]]; then  echo Now,The MysqL Replication is synchronous at: `date +%F" "%H-%M-%s` >> ${LOGfile}  exit 0fi  ## 从master.info文件中,获得MysqL主端的同步信息REPli_INFO=`sed '/^$/d' ${MASTER_file} | tail +2 | head -5`REPli_binlog_file=`echo ${REPli_INFO} | awk '{print $1}'`REPli_IPADDR=`echo ${REPli_INFO} | awk '{print $3}'`REPli_USER=`echo ${REPli_INFO} | awk '{print $4}'`REPli_PWD=`echo ${REPli_INFO} | awk '{print $5}'`  ## 删除无用的Relay binlogrm -rf ${RELAY_binlog_PATH}/*-relay-bin.*  ## 直接从0位置开始同步sqlCMD2="change master to master_host='${REPli_IPADDR}',master_user='${REPli_USER}',master_password='${REPli_PWD}',"sqlCMD2="${sqlCMD2} master_log_file='${REPli_binlog_file}',master_log_pos=0"MysqL -uroot -e "stop slave;"MysqL -uroot -e "${sqlCMD2};"MysqL -uroot -e "start slave;"  ## 如果同步的过程中,出现重复记录导致同步失败,就跳过while truedo  sleep 2  IO_STATUS=`MysqL -uroot -e "${sqlCMD1}\G;" | awk '$1=="Slave_IO_Running:" {print $2}'`  sql_STATUS=`MysqL -uroot -e "${sqlCMD1}\G;" | awk '$1=="Slave_sql_Running:" {print $2}'`  BEHIND_STATUS=`MysqL -uroot -e "${sqlCMD1}\G;" | awk '$1=="Seconds_Behind_Master:" {print $2}'`  SLAVE_binlog1=`MysqL -uroot -e "${sqlCMD1}\G;" | awk '$1=="Master_Log_file:" {print $2}'`  SLAVE_binlog2=`MysqL -uroot -e "${sqlCMD1}\G;" | awk '$1=="Relay_Master_Log_file:" {print $2}'`      ## 出现差错,就将差错信息记录到日志文件,并跳过差错继续同步  if [[ "${IO_STATUS}" != "Yes" || "${sql_STATUS}" != "Yes" ]]; then    ERRORINFO=`MysqL -uroot -e "${sqlCMD1}\G;" | awk -F ': ' '$1=="Last_Error" {print $2}'`    echo "The MysqL synchronous error information: ${ERRORINFO}" >> ${LOGfile}    MysqL -uroot -e "stop slave;"    MysqL -uroot -e "set GLOBAL sql_SLAVE_SKIP_COUNTER=1;"    MysqL -uroot -e "start slave;"        ## 已完成同步,就正常退出  elif [[ "${IO_STATUS}" = "Yes" && "${sql_STATUS}" = "Yes" && "${SLAVE_binlog1}" = "${SLAVE_binlog2}" && ${BEHIND_STATUS} -eq 0 ]]; then    echo The MysqL synchronous is ok at: `date +%F" "%H-%M-%s` >> ${LOGfile}    break  fidone

《MysqL应用MysqL的一些功能实用的linux shell脚本分享》是否对您有启发，欢迎查看更多与《MysqL应用MysqL的一些功能实用的linux shell脚本分享》相关教程，学精学透。内存溢出PHP学院为您提供精彩教程。

总结

以上是内存溢出为你收集整理的Mysql应用MySQL的一些功能实用的Linux shell脚本分享全部内容，希望文章能够帮你解决Mysql应用MySQL的一些功能实用的Linux shell脚本分享所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。