• 日常运维中的一键安装或启停脚本


    日常运维中的一键安装或启停脚本

    在日常运维中,我们通常会利用shell的"function函数+if逻辑判断+case选择语句"来实现中间件服务一键部署或一键启停。下面分享几个常用运维的一键脚本:

    一、Tomcat一键启停服务脚本 [如有多个tomcat实例,就在/etc/init.d/下配置多个针对每个tomcat端口的启停脚本。下面为tomcat_8080脚本文件]

    #!/bin/bash
    #chkconfig: 345 99 10
    #description: Auto-starts tomcat
    # /etc/init.d/tomcatd
    # Tomcat auto-start
       
    # Source function library.
    source /etc/init.d/functions
    # source networking configuration.
    #. /etc/sysconfig/network
      
    RETVAL=0
    project_tomcat=tomcat_8080
    #这里的tomcat采用结尾以端口号方式命令。即tomcat_port
    #如果本机由多个tomcat示例,则这种结尾以端口号命名的方式比较好,
       
    #执行"echo $JAVA_HOME"可以查看到本机JAVA主目录路径
    export JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el7_7.x86_64/
       
    export CATALINA_HOME=/usr/local/${project_tomcat}
    #export CATALINA_BASE=/usr/local/${project_tomcat}  
      
    #(centos7系统)重新加载服务配置文件。只有当该脚本被修改的时候需要执行该项,可以不配置。
    systemctl daemon-reload
    #TOMCATUSER=tomcat
    start()
    {
            if [ -f ${CATALINA_HOME}/bin/startup.sh ];
              then
                echo $"Starting Tomcat"
                #这里tomcat使用root启动的,如果不是root用户启动的,这里就修改下用户。
                if [ root = `whoami` ];
                  then
                    ${CATALINA_HOME}/bin/startup.sh
                  else
                    su - root -c "${CATALINA_HOME}/bin/startup.sh"
                fi
                RETVAL=$?
                echo " OK"
                return ${RETVAL}
            fi
    }
    stop()
    {
            if [ -f ${CATALINA_HOME}/bin/shutdown.sh ];
              then
                echo $"Stopping Tomcat"
                ${CATALINA_HOME}/bin/shutdown.sh
                RETVAL=$?
                sleep 1
                #ps -ef|grep $project_tomcat|egrep -v 'grep|init'|awk '{print$2}'|xargs kill -9
                #egrep -v "grep|init" 的过滤效果等同于 grep -v "grep|init"
                ps -ef|grep ${project_tomcat}|egrep -v 'grep|init' | grep ${CATALINA_HOME}|awk '{print $2}'|xargs kill -9
                #下面可根据自己tomcat日志的实际路径进行更改
                mv ${CATALINA_HOME}/logs/catalina.out ${CATALINA_HOME}/logs/catalina.out_`date '+%Y%m%d_%H_%M_%S'`
                find ${CATALINA_HOME}/logs/ -mtime +10 -exec rm -rf {} ;
                echo " OK"
                # [ $RETVAL -eq 0 ] && rm -f /var/lock/...
                return ${RETVAL}
            fi
    }
    status()
    {
    #这里tomcat实例名结尾是以端口号命名的。如果实例名中没有显示端口号,则取tomcat端口号如下:
    #port=$(cat ${CATALINA_HOME}/conf/server.xml |grep -w 'URIEncoding="UTF-8"'|awk '{print $2}'|cut -d"=" -f2|cut -d""" -f2)
    port=$(echo ${project_tomcat}|awk -F _ '{print$2}')
    #打印"lsof -i:port"结果中第二行的第二列,即是该端口所属服务的pid
    pid=$(`which lsof` -i:$port|awk 'NR==2{print$2}')
    if [ -z $pid ]    #判断${pid}字符串是否为空串,空串为真。
            then
            #使用下面echo方式会将打印内容标红!
            echo -e "33[40;31m${project_tomcat} is stopped33[0m"
            else
            echo ${project_tomcat} is running
            fi
    }
    case "$1" in
    start)
            start
            ;;
    stop)
            stop
            ;;
    restart)
             echo $"Restaring Tomcat"
             stop
             sleep 1
             start
             ;;
    status)
            status
            ;;
    *)
            echo $"Usage: $0 {start|stop|restart|status}"
            exit 1
            ;;
    esac
    exit ${RETVAL}
     
    执行脚本:
    [root@localhost ~]# /etc/init.d/tomcat_8080
    Usage: /etc/init.d/tomcat_8080 {start|stop|restart|status}
     
    [root@localhost ~]# chmod 755 /etc/init.d/tomcat_8080
      
    [root@localhost ~]# /etc/init.d/tomcat_8080 restart
    Restarting tomcat_8080 (via systemctl):                    [  OK  ]
      
    [root@localhost ~]# /etc/init.d/tomcat_8080 status
    tomcat_8080 is running
      
    [root@localhost ~]# /etc/init.d/tomcat_8080 stop
    Stopping tomcat_8080 (via systemctl):                      [  OK  ]
      
    [root@localhost ~]# /etc/init.d/tomcat_8080 status
    tomcat_8080 is stopped
      
    [root@localhost ~]# /etc/init.d/tomcat_8080 start
    Starting tomcat_8080 (via systemctl):                      [  OK  ]
      
    [root@localhost ~]# /etc/init.d/tomcat_8080 status
    tomcat_8080 is running
    

    二、Zookeeper集群环境一键部署脚本 [生产环境中推荐使用该脚本]

    [root@bobo zookeeper]# cat install_zookeeper.sh
    #!/bin/bash
       
    source /etc/profile
    java -version
    if [ "$?" -ne 0 ]; then
      echo "JDK未安装,请先安装JDK"
      exit 1
    fi
    while getopts "a:b:n:l:c:f:m:h" opts
    do
            case $opts in
                    a)
                            #APP_NAME:项目编码
                            APP_NAME=$OPTARG
                            ;;
                    b)
                            #MODULE_NAME:模块名称
                            MODULE_NAME=$OPTARG
                            ;;
                    n)
                            #ZK_SRVNUM:ZOOKEEPER数量
                            ZK_SRVNUM=$OPTARG
                            ;;
                    l)
                            #ZK_IPLIST:ZOOKEEPER服务器IP地址列表
                            ZK_IPLIST=$OPTARG
                            ;;
                    c)
                            #ZKCLIENT_PORT:客户端访问 zookeeper 的端口号
                            ZKCLIENT_PORT=$OPTARG
                            ;;
                    f)
                            #ZKLEADER_PORT:ZOOKEEPER的F和L通信端口号
                            ZKLEADER_PORT=$OPTARG
                            ;;
                    m)
                            #ZKCOM_PORT:ZOOKEEPER选举端口号
                            ZKCOM_PORT=$OPTARG
                            ;;
                    h)
                            echo -e "OPTIONS:
    -a:项目编码(必选)
    -b:模块名称(可选,默认为空)
    -n:ZooKeeper服务器数量(可选,默认为3)"
                            echo -e "-l:ZooKeeper服务器IP地址列表(必选,IP地址以英文逗号分隔)"
                            echo -e "-c:Client-Port(可选,默认为2181,多个端口以英文逗号分隔,且与IP地址一一对应)"
                            echo -e "-f:ZooKeeper的F和L通信端口号(可选,默认为2888,多个端口以英文逗号分隔,且与IP地址一一对应)"
                            echo -e "-m:ZooKeeper选举端口号(可选,默认为3888,多个端口以英文逗号分隔,且与IP地址一一对应)"
                            exit 1
                            ;;
                    ?)
                            echo "missing  options,pls check!"
                            exit 1
                            ;;
            esac
    done
    #可选参数赋值
    ZK_SRVNUM=${ZK_SRVNUM:-3}
    ZKCLIENT_PORT=${ZKCLIENT_PORT:-2181}
    ZKLEADER_PORT=${ZKLEADER_PORT:-2888}
    ZKCOM_PORT=${ZKCOM_PORT:-3888}
    #定义公共变量
    #zookeep安装包存放位置
    ZKSAVDIR="/usr/local/src/zookeeper"
    #zookeeper安装包名(不带扩展名)
    ZKNAME="zookeeper-3.4.8"
    #必选参数存在性及参数合法性判断
    #if [ -z ${APP_NAME} ]||[ -z ${MODULE_NAME} ]||[ -z ${ZK_IPLIST} ];then
    if [ -z ${APP_NAME} ]||[ -z ${ZK_IPLIST} ];then
            echo "Missing options,exit"
            exit 1
    elif [ ${ZK_SRVNUM} -ne 1 ]&&[ ${ZK_SRVNUM} -ne 3 ]&&[ ${ZK_SRVNUM} -ne 5 ];then
            echo "Wrong server num,exit"
            exit 1
    fi
    IPLIST_NUM=`echo ${ZK_IPLIST}|awk -F"," '{print NF}'`
    if [ ${ZK_SRVNUM} -ne ${IPLIST_NUM} ];then
            echo "IP list and server num do not match,exit"
            exit 1
    fi
    APP_NAME=`echo ${APP_NAME} | tr '[A-Z]' '[a-z]'`
    #多个端口时判断端口数与IP地址数量是否一致
    CPORT_NUM=`echo ${ZKCLIENT_PORT}|awk -F"," '{print NF}'`
    LPORT_NUM=`echo ${ZKLEADER_PORT}|awk -F"," '{print NF}'`
    EPORT_NUM=`echo ${ZKCOM_PORT}|awk -F"," '{print NF}'`
    if [ ${CPORT_NUM} -gt 1 ];then
            if [ ${IPLIST_NUM} -ne ${CPORT_NUM} ]||[ ${IPLIST_NUM} -ne ${LPORT_NUM} ]||[ ${IPLIST_NUM} -ne ${EPORT_NUM} ];then
                    echo "IP list and Port list number do not match,exit"
                    exit 1
            fi
    #获取IP地址和端口对应关系
            rm -f /home/workapp/zkinfo.cfg
            for ((i=1;i<=${ZK_SRVNUM};i++)); do
                    eval IP_$i='`echo ${ZK_IPLIST}|awk -F, "{ print $"$i" }"`'
                    eval PORT_$i='`echo ${ZKCLIENT_PORT}|awk -F, "{ print $"$i" }"`'
                    eval LPORT_$i='`echo ${ZKLEADER_PORT}|awk -F, "{ print $"$i" }"`'
                    eval EPORT_$i='`echo ${ZKCOM_PORT}|awk -F, "{ print $"$i" }"`'
    #               eval echo "server.${i}=$IP_$i:${ZKLEADER_PORT}:${ZKCOM_PORT}">>${ZKHOME}/conf/zoo.cfg
    #               eval IPTMP=$IP_$i
                    eval PORTTMP=$PORT_$i
    #zookeeper HOME路径
                    [ -z ${MODULE_NAME} ]&&eval ZKHOME="/opt/${APP_NAME}/zookeeper_$PORT_$i"||eval ZKHOME="/opt/${APP_NAME}/zookeeper_${MODULE_NAME}_$PORT_$i"
    #zookeeper日志存储路径
                    [ -z ${MODULE_NAME} ]&&eval DATA_LOGDIR="/var/log/${APP_NAME}/zookeeper_$PORT_$i"||eval DATA_LOGDIR="/var/log/${APP_NAME}/zookeeper_${MODULE_NAME}_$PORT_$i"
    #zookeeper数据存储路径
                    DATA_DIR="${ZKHOME}/data"
    #生成参数列表
                    eval echo "$i,$IP_$i,$PORT_$i,$LPORT_$i,$EPORT_$i,${ZKHOME},${DATA_LOGDIR},${DATA_DIR}">>/home/workapp/zkinfo.cfg
            done
            cat /home/workapp/zkinfo.cfg
    else
    #zookeeper HOME路径
            [ -z ${MODULE_NAME} ]&&ZKHOME="/opt/${APP_NAME}/zookeeper"||ZKHOME="/opt/${APP_NAME}/zookeeper_${MODULE_NAME}"
            echo "ZKHOME is ${ZKHOME}"
    #zookeeper日志存储路径
            [ -z ${MODULE_NAME} ]&&DATA_LOGDIR="/var/log/${APP_NAME}/zookeeper"||DATA_LOGDIR="/var/log/${APP_NAME}/zookeeper_${MODULE_NAME}"
            echo "ZK log dir is ${DATA_LOGDIR}"
    #zookeeper数据存储路径
            DATA_DIR="${ZKHOME}/data"
            echo "ZK data dir is ${DATA_DIR}"
    fi
    #安装日志
    INSTALL_LOG="/home/workapp/zookeeperinstall.log"
    #打印变量值
    echo "APP_NAME is ${APP_NAME}"|tee -a ${INSTALL_LOG}
    echo "MODULE_NAME is ${MODULE_NAME}"|tee -a ${INSTALL_LOG}
    echo "ZK_Server_num is ${ZK_SRVNUM}"|tee -a ${INSTALL_LOG}
    echo "ZK_Server IP is ${ZK_IPLIST}"|tee -a ${INSTALL_LOG}
    echo "ZK_Client Port is ${ZKCLIENT_PORT}"|tee -a ${INSTALL_LOG}
    echo "ZK_Leader Port is $ZKLEADER_PORT"|tee -a ${INSTALL_LOG}
    echo "ZK_COM Port is ${ZKCOM_PORT}"|tee -a ${INSTALL_LOG}
    #获取本机IP地址
    HOST_IP=`ip a|grep global|awk '{print $2}'|awk -F"/" '{print $1}'`
    echo "Local IP is ${HOST_IP}"|tee -a ${INSTALL_LOG}
    #安装包MD5校验
    md5Now=`md5sum ${ZKSAVDIR}/${ZKNAME}.tar.gz|awk '{print $1}'`
    md5Save=`cat ${ZKSAVDIR}/${ZKNAME}.tar.gz.md5`
    if [ "${md5Now}" != "${md5Save}" ];then
        echo "MD5 check Failed!"|tee -a ${INSTALL_LOG}
        echo "the md5 now is ${md5Now}"|tee -a ${INSTALL_LOG}
        echo "the md5 saved is ${md5Save}"|tee -a ${INSTALL_LOG}
        exit 1
    else
        echo "MD5 check success!"|tee -a ${INSTALL_LOG}
    fi
    #安装zookeeper
    function Install_zk {
            echo "=================`date '+%Y%m%d %H:%M:%S'`Start Install ZooKeeper....==============="|tee -a ${INSTALL_LOG}
            #解压缩安装包至项目编码安装路径
            if [ ! -e /opt/${APP_NAME}/ ]; then
                    mkdir -p /opt/${APP_NAME}
            fi
            tar -xzf ${ZKSAVDIR}/${ZKNAME}.tar.gz -C /opt/${APP_NAME}/
            mv /opt/${APP_NAME}/${ZKNAME} ${ZKHOME}
            mkdir -p ${DATA_DIR}
            mkdir -p ${DATA_LOGDIR}
            cp ${ZKHOME}/conf/zoo_sample.cfg ${ZKHOME}/conf/zoo.cfg
            #客户化zoo.cfg配置
            sed -i "s/clientPort=2181/clientPort=${ZKCLIENT_PORT}/g" ${ZKHOME}/conf/zoo.cfg
            sed -i "s#dataDir=/tmp/zookeeper#dataDir=${DATA_DIR}#g" ${ZKHOME}/conf/zoo.cfg
            sed -i "/dataLogDir/s/^/#/" ${ZKHOME}/conf/zoo.cfg
            echo "dataLogDir=${DATA_LOGDIR}" >>${ZKHOME}/conf/zoo.cfg
            #修改zookeeper-env.sh,指定运行日志zookeeper.log路径
            sed -i "s#/var/log/zookeeper#${DATA_LOGDIR}#g" ${ZKHOME}/conf/zookeeper-env.sh
            #修改java.env,设置jvm参数,指定gc日志路径
            sed -i "s#/var/log/zookeeper#${DATA_LOGDIR}#g" ${ZKHOME}/conf/java.env
    #服务器数量为3个或5个为集群模式
            if [ ${ZK_SRVNUM} -eq 3 ]||[ ${ZK_SRVNUM} -eq 5 ];then
    #根据端口数量判断安装方式
                    if [ ${CPORT_NUM} -eq 1 ];then
    #拆分IP地址列表,获取本机ZK_ID
                            for ((i=1;i<=${ZK_SRVNUM};i++));do
                                    eval IP_$i='`echo ${ZK_IPLIST}|awk -F, "{ print $"$i" }"`'
    #                       eval echo $IP_$i
                                    eval IPTMP=$IP_$i
                                    eval echo "server.${i}=$IP_$i:${ZKLEADER_PORT}:${ZKCOM_PORT}">>${ZKHOME}/conf/zoo.cfg
                                    if [ "$HOST_IP" == "$IPTMP" ];then
    #当列表中的IP地址等于本机地址时,获取当前i值作为ID
                                            ZK_ID=${i}
                                    else
                                            continue
                                    fi
                            done
                    else
                                    ZK_ID=${NUM}
                                    while read ZK_INFO;do
                                             echo ${ZK_INFO}|awk -F, '{print "server."$1"="$2":"$4":"$5}'>>${ZKHOME}/conf/zoo.cfg
                                    done</home/workapp/zkinfo.cfg
                    fi
            #客户化myid
                    echo "${ZK_ID}" >${DATA_DIR}/myid
                    echo "zookeeper ID is ${ZK_ID}"|tee -a ${INSTALL_LOG}
            fi
            chown -R workapp:workapp ${ZKHOME}
            chown -R workapp:workapp ${DATA_LOGDIR}
            cat ${ZKHOME}/conf/zoo.cfg
    }
    function Check_install {
            retval=$?
            if [ $retval -eq 0 ];then
                    echo "`date '+%Y%m%d %H:%M:%S'` zookeeper install SUCCESS!|${APP_NAME} ${MODULE_NAME} ${HOST_IP} ${ZKCLIENT_PORT} ${ZK_ID}|0"|tee -a ${INSTALL_LOG}
            else
                    echo "`date '+%Y%m%d %H:%M:%S'` zookeeper install FAILED!|${APP_NAME} ${MODULE_NAME} ${HOST_IP} ${ZKCLIENT_PORT} ${ZK_ID}|1"|tee -a ${INSTALL_LOG}
            fi
    }
    function Start_check {
            su - workapp -c "sh ${ZKHOME}/bin/zkServer.sh start"
            sleep 10
            su - workapp -c "sh ${ZKHOME}/bin/zkServer.sh status"
            netstat -anp|grep ${ZKCLIENT_PORT}
    }
    #根据端口数量判断安装方式,1个端口为standalone或集群模式,正常安装;
    if [ ${CPORT_NUM} -eq 1 ];then
            Install_zk
            Check_install
            Start_check
    else
    #多个端口为伪集群模式,读取zkinfo.cfg文件
            while read ZK_INFO;do
                    NUM=`echo ${ZK_INFO}|awk -F, '{print $1}'`
                    IP=`echo ${ZK_INFO}|awk -F, '{print $2}'`
                    ZKCLIENT_PORT=`echo ${ZK_INFO}|awk -F, '{print $3}'`
                    ZKHOME=`echo ${ZK_INFO}|awk -F, '{print $6}'`
                    DATA_LOGDIR=`echo ${ZK_INFO}|awk -F, '{print $7}'`
                    DATA_DIR=`echo ${ZK_INFO}|awk -F, '{print $8}'`
                    if [ "$IP" == "$HOST_IP" ];then
                            Install_zk
                            Check_install
                            Start_check
                    else
                            continue
                    fi
            done</home/workapp/zkinfo.cfg
    fi
    rm -f /home/workapp/zkinfo.cfg
    

    查看脚本帮助信息

    #!/bin/bash
    # Date: 2018-09-08
    # Mail: kevin@163.com
    # Founder: kevin
    # Describe: This is a one - button installation service script 
    function CDAN(){
    cat << One_button_install
    +------------------------------------------------+
    |                                                |
    |    _o0o_        1. 安装Nginx                   |
    |    08880        2. 安装Apache                  | 
    |    88"."88      3. 安装MySQL                   |
    |    (|-_-|)      4. 安装PHP                     |
    |    0=/0        5. 部署LNMP环境                |
    |   __/  \__      6. 安装zabbix监控              |
    |   ‘  ///‘      7. 退出此管理程序              |
    |  / Linux一键   8. 关闭计算机                  |
    | ||  Server  || ================================| 
    |     ////       一键安装服务                   |
    |  ||| i i i  ||| by Kevin                       |
    |  ___    ___    ================================|
    |___‘. /--.-- .‘___                             |
    +------------------------------------------------+
    One_button_install
    }
    CDAN
     source /etc/init.d/functions
    BASE_DIR=/usr/local/src
    read -p "请您输入1-8任意字符:" NUM
    expr $NUM + 1 >/dev/null 2>&1
    if [ "$?" -ne 0 ]
     then
      echo "请您输入{1|2|3|4|5|6|7|8}"
      exit 1
    fi
       
    function Nginx_server (){
      echo "开始安装Nginx,请喝杯咖啡,耐心等待一段时间...."
      yum install -y gcc gcc-c++ pcre-devel zlib-devel openssl-devel >/dev/null 2>&1
      cd $BASE_DIR
      wget http://nginx.org/download/nginx-1.12.2.tar.gz >/dev/null 2>&1 
      useradd -M -s /sbin/nologin nginx
      tar -zvxf nginx-1.12.2.tar.gz >/dev/null 2>&1
      cd $BASE_DIR/nginx-1.12.2/
      ./configure --prefix=/usr/local/nginx --with-http_dav_module --with-http_stub_status_module --with-http_addition_module --with-http_sub_module --with-http_flv_module --with-http_mp4_module --with-pcre --with-http_ssl_module --with-http_gzip_static_module --user=nginx --group=nginx >/dev/null 2>&1
       
      if [ "$?" -eq 0 ];then
        make && make install >/dev/null 2>&1
      fi
     
      if [ -f /usr/local/nginx/sbin/nginx ];then
        ln -s /usr/local/nginx/sbin/nginx /usr/local/sbin
        /usr/local/nginx/sbin/nginx
        echo "恭喜您! Nginx安装成功!"
      fi
    }
             
    function Apache_server (){
      echo "开始安装Apache,请喝杯咖啡,耐心等待一段时间...."
      yum install httpd -y >/dev/null 2>&1
      if [ "$?" -eq 0 ]
       then
        echo "恭喜您! Apache安装成功!"
       else
        echo "很抱歉, Apache安装失败! 请仔细检查安装脚本,可能有点问题."
      fi
    }
     
    function Mysql_server (){
        echo "开始安装Mysql,请喝杯咖啡,耐心等待一段时间...."
        rpm -e $(/bin/rpm -qa | grep mysql|xargs) --nodeps >/dev/null 2>&1
        rpm -e $(/bin/rpm -qa | grep mariadb|xargs) --nodeps >/dev/null 2>&1
     
        yum -y install make gcc-c++ cmake bison-devel ncurses-devel >/dev/null 2>&1
        mkdir -p /usr/local/boost && cd /usr/local/boost
        wget http://www.sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz >/dev/null 2>&1
        tar -zvxf boost_1_59_0.tar.gz >/dev/null 2>&1
     
        /usr/sbin/groupadd mysql
        /usr/sbin/useradd -g mysql mysql -M -s /sbin/nologin
        mkdir -p /data/mysql/data
     
        cd $BASE_DIR
        wget -c http://ftp.ntu.edu.tw/MySQL/Downloads/MySQL-5.7/mysql-5.7.28.tar.gz >/dev/null 2>&1
        tar -zxvf mysql-5.7.28.tar.gz >/dev/null 2>&1
        cd mysql-5.7.28/
        #mysql安装目录和数据目录最好分开,配置文件为/usr/local/mysql/my.cnf
        cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql/data -DSYSCONFDIR=/usr/local/mysql -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_BOOST=/usr/local/boost >/dev/null 2>&1
         
        if [ "$?" -eq 0 ];then
           make && make install >/dev/null 2>&1
        fi
     
        chown -R mysql:mysql /usr/local/mysql
        chown -R mysql:mysql /data/mysql
        # 执行初始化配置脚本,创建系统自带的数据库和表
        /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data/mysql/data --user=mysql --initialize >/dev/null 2>&1
     
        ## 配置my.cnf, 注意下面EOF输入的内容需要顶格写,否则输入无效!
    cat > /usr/local/mysql/my.cnf << EOF 
    [client]
    port = 3306
    socket = /usr/local/mysql/var/mysql.sock
     
    [mysqld]
    port = 3306
    socket = /usr/local/mysql/var/mysql.sock
     
    basedir = /usr/local/mysql/
    datadir = /data/mysql/data
    pid-file = /data/mysql/data/mysql.pid
    user = mysql
    bind-address = 0.0.0.0
    server-id = 1
    sync_binlog=1
    log_bin = mysql-bin
     
    skip-name-resolve
    #skip-networking
    back_log = 600
     
    max_connections = 3000
    max_connect_errors = 3000
    ##open_files_limit = 65535
    table_open_cache = 512
    max_allowed_packet = 16M
    binlog_cache_size = 16M
    max_heap_table_size = 16M
    tmp_table_size = 256M
     
    read_buffer_size = 1024M
    read_rnd_buffer_size = 1024M
    sort_buffer_size = 1024M
    join_buffer_size = 1024M
    key_buffer_size = 8192M
     
    thread_cache_size = 8
     
    query_cache_size = 512M
    query_cache_limit = 1024M
     
    ft_min_word_len = 4
     
    binlog_format = mixed
    expire_logs_days = 30
     
    log_error = /data/mysql/data/mysql-error.log
    slow_query_log = 1
    long_query_time = 1
    slow_query_log_file = /data/mysql/data/mysql-slow.log
     
    performance_schema = 0
    explicit_defaults_for_timestamp
     
    ##lower_case_table_names = 1 
    skip-external-locking
     
    default_storage_engine = InnoDB
    ##default-storage-engine = MyISAM
    innodb_file_per_table = 1
    innodb_open_files = 500
    innodb_buffer_pool_size = 40960M
    innodb_write_io_threads = 1000
    innodb_read_io_threads = 1000
    innodb_thread_concurrency = 8
    innodb_purge_threads = 1
    innodb_flush_log_at_trx_commit = 2
    innodb_log_buffer_size = 4M
    innodb_log_file_size = 32M
    innodb_log_files_in_group = 3
    innodb_max_dirty_pages_pct = 90
    innodb_lock_wait_timeout = 120
     
    bulk_insert_buffer_size = 8M
    #myisam_sort_buffer_size = 8M
    #myisam_max_sort_file_size = 1G
    #myisam_repair_threads = 1
     
    interactive_timeout = 28800
    wait_timeout = 28800
     
    [mysqldump]
    quick
    max_allowed_packet = 16M
     
    [myisamchk]
    key_buffer_size = 8M
    sort_buffer_size = 8M
    read_buffer = 4M
    write_buffer = 4M
     
    sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
    port = 3306
    EOF
     
        #启动mysql服务
        cd /usr/local/mysql && mkdir var
        chown -R mysql.mysql var
        cp support-files/mysql.server /etc/init.d/mysql
        chmod 755 /etc/init.d/mysql
        #由于是拷贝到/etc/init.d下的启动脚本,这里不管是centos6或centos6都使用chkconfig添加开机启动
        chkconfig mysql on
        service mysql start >/dev/null 2>&1
     
        #设置环境变量
        echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
        source /etc/profile
     
        mkdir -p /var/lib/mysql
        ln -s /usr/local/mysql/var/mysql.sock /var/lib/mysql/mysql.sock
        chown -R mysql:mysql /var/lib/mysql
     
        #设置初始密码为"mysql@123"
        sed -i '/[mysqld]/askip-grant-tables' /usr/local/mysql/my.cnf
        service mysql restart >/dev/null 2>&1
        #mysql无密码登陆,可以使用mysql -p" "直接登陆(即密码为空)。如果直接使用mysql -p回车,然后无密码,但还是需要触发一次回车。
        /usr/local/mysql/bin/mysql -p" " -e "update mysql.user set authentication_string=password('mysql@123') where user='root';" -e "flush privileges;"
        
        sed -i '/skip-grant-tables/d' /usr/local/mysql/my.cnf
        MYSQL_VERSION=$(basename $(ls $BASE_DIR/mysql-*.tar.gz)|cut -d"-" -f2|awk -F".tar" '{print $1}')
     
        chown -R mysql:mysql /usr/local/mysql
        chown -R mysql:mysql /data/mysql
     
        service mysql restart >/dev/null 2>&1
        if [ "$?" -eq 0 ];then
          echo "恭喜您! Mysql${MYSQL_VERSION}安装成功!目前Mysql服务已启动,初始密码为mysql@123"
        fi
     }
       
    case $NUM in
      1)
         Nginx_server
      ;;
      2)
         Apache_server
      ;;
      3)
        Mysql_server
      ;;
    esac
    

    执行脚本

    需要注意:
    上面One_button_install.sh一键部署脚本中涉及服务安装包的下载,考虑到网络因素,可以提前将包下载下来放到指定的${BASE_DIR}目录下,这样有利于提高脚本执行效率。
     
    执行脚本,必须选择安装mysql
    [root@localhost ~]# chmod 755 One_button_install.sh
    [root@localhost ~]# sh One_button_install.sh
    +------------------------------------------------+
    |                                                |
    |    _o0o_        1. 安装Nginx                   |
    |    08880        2. 安装Apache                  | 
    |    88"."88      3. 安装MySQL                   |
    |    (|-_-|)      4. 安装PHP                     |
    |    0=/0        5. 部署LNMP环境                |
    |   __/  \__      6. 安装zabbix监控              |
    |   ‘  ///‘      7. 退出此管理程序              |
    |  / Linux一键   8. 关闭计算机                  |
    | ||  Server  || ================================| 
    |     ////       一键安装服务                   |
    |  ||| i i i  ||| by Kevin                       |
    |  ___    ___    ================================|
    |___‘. /--.-- .‘___                             |
    +------------------------------------------------+
    请您输入1-8任意字符:3
    开始安装Mysql,请喝杯咖啡,耐心等待一段时间....
     
    接着就是耐心等待就好了,本脚本经过线上测试可用。
    

    转载至:https://www.cnblogs.com/kevingrace/p/6086426.html

    很高兴各位朋友能欣赏作品,本文版权归作者和博客园共有,欢迎转载,请在文章页面明显位置给出原文出处,否则将追究法律责任。 原文链接: https://www.cnblogs.com/strugger-0316
  • 相关阅读:
    java时间戳与Date相互转换、日期格式化、给日期加上指定时长、判断两时间点是否为同一天
    notepad++去掉红色波浪线
    发生异常Address already in use: bind
    SecureCRT背景颜色
    linux查看实时日志命令
    idel上传代码到github时遇到的Push rejected: Push to origin/master was rejected
    git解决error: The following untracked working tree files would be overwritten by checkout
    使用SecureCRT工具上传、下载文件的两种方法
    Windows下Zookeeper启动zkServer.cmd闪退问题的解决方案
    Maven的Snapshot版本与Release版本
  • 原文地址:https://www.cnblogs.com/strugger-0316/p/15106908.html
Copyright © 2020-2023  润新知