• 企业400电话
  • 微网小程序
  • AI电话机器人
  • 电商代运营
  • 全 部 栏 目

    企业400电话 网络优化推广 AI电话机器人 呼叫中心 网站建设 商标✡知产 微网小程序 电商运营 彩铃•短信 增值拓展业务
    mysql源码安装脚本分享

    复制代码 代码如下:

    #!/bin/bash
    PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:~/bin
    export PATH
    clear;
    SysName=""
    SysBit=""
    CpuNum=""
    RamTotal=""
    RamSwap=""
    FileMax=""
    MysqlVersion="Percona-Server-5.6.15-rel63.0"
    MysqlLine="http://www.percona.com/downloads/Percona-Server-5.6/LATEST/source"
    MysqlPath="/usr/local/mysql"
    MysqlDataPath="$MysqlPath/data"
    MysqlLogPath="/var/log/mysql"
    MysqlConfigPath="$MysqlPath/conf"
    MysqlPass="test123"
    SYSTEM_CHECK(){
     [[ $(id -u) != '0' ]] echo '[Error] Please use root to install PUPPET.' exit;
     egrep -i "centos" /etc/issue SysName='centos';
     egrep -i "ubuntu" /etc/issue SysName='ubuntu';
     [[ "$SysName" == '' ]] echo '[Error] Your system is not supported this script' exit;
     SysBit='32' [ `getconf WORD_BIT` == '32' ] [ `getconf LONG_BIT` == '64' ] SysBit='64';
     CpuNum=`cat /proc/cpuinfo |grep 'processor'|wc -l`;
     RamTotal=`free -m | grep 'Mem' | awk '{print $2}'`;
     RamSwap=`free -m | grep 'Swap' | awk '{print $2}'`;
     FileMax=`cat /proc/sys/fs/file-max`
    }
    INSTALL_BASE_PACKAGES()
    {
     SYSTEM_CHECK
     if [ "$SysName" == 'centos' ]; then
      echo '[yum-fastestmirror Installing] ************************************************** >>';
      yum -y install yum-fastestmirror;
      cp /etc/yum.conf /etc/yum.conf.lnmp
      sed -i 's:exclude=.*:exclude=:g' /etc/yum.conf
      for packages in gcc gcc-c++ openssl-devel ncurses-devel wget crontabs iptables bison cmake automake make readline-devel logrotate openssl; do
       echo "[${packages} Installing] ************************************************** >>";
       yum -y install $packages;
      done;
      mv -f /etc/yum.conf.lnmp /etc/yum.conf;
     else
      apt-get remove -y mysql-client mysql-server mysql-common;
      apt-get update;
      for packages in gcc g++ cmake make ntp logrotate cron bison libncurses5-dev libncurses5 libssl-dev openssl curl openssl; do
       echo "[${packages} Installing] ************************************************** >>";
       apt-get install -y $packages --force-yes;apt-get -fy install;apt-get -y autoremove;
      done;
     fi;
    }
    INSTALL_MYSQL(){
     INSTALL_BASE_PACKAGES
     cd /tmp/
     echo "[${MysqlVersion} Installing] ************************************************** >>";
     [ ! -f ${MysqlVersion}.tar.gz ] wget -c ${MysqlLine}/${MysqlVersion}.tar.gz
     tar -zxf /tmp/$MysqlVersion.tar.gz;
     cd /tmp/$MysqlVersion;
     groupadd mysql;
     useradd -s /sbin/nologin -g mysql mysql;
     cmake -DCMAKE_INSTALL_PREFIX=$MysqlPath  -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=complex -DWITH_READLINE=ON -DENABLED_LOCAL_INFILE=ON -DWITH_INNODB_MEMCACHED=ON -DWITH_UNIT_TESTS=OFF;
     make -j $Cpunum;
     make install;
     for path in $MysqlLogPath $MysqlPath $MysqlConfigPath/conf.d $MysqlDataPath;do
      [ ! -d $path ] mkdir -p $path
      chmod 740 $path;
      chown -R mysql:mysql $path;
     done
    # EOF **********************************
    cat > $MysqlConfigPath/my.cnfEOF;
    [mysqld]
    user  = mysql
    server-id = 1
    pid-file = /var/run/mysqld.pid
    socket  = /var/run/mysqld.sock
    port  = 3306
    basedir  = $MysqlPath
    datadir  = $MysqlDataPath
    bind-address = 0.0.0.0
    skip-name-resolve
    skip-external-locking
    thread_concurrency = `expr $CpuNum \* 2`
    max_connections = `expr $FileMax \* $CpuNum \* 2 / $RamTotal`
    max_connect_errors = 30
    table_open_cache = `expr $RamTotal + $RamSwap`
    max_allowed_packet = `expr $RamTotal \* 2 / 1000`M
    binlog_cache_size = 4M
    max_heap_table_size = `expr $RamTotal / 100`M
    sort_buffer_size = `expr $RamTotal \* 2 / 1000`M
    join_buffer_size = `expr $RamTotal \* 2 / 1000`M
    query_cache_size = `expr $RamTotal / 100`M
    thread_cache_size = 30
    thread_concurrency = `expr $CpuNum \* 4`
    connect_timeout  = 1200
    wait_timeout  = 1200
    general_log = 1
    general_log_file = $MysqlLogPath/mysql.log
    log_error = $MysqlLogPath/mysql-err.log
    slow_query_log = 1
    slow_query_log_file = $MysqlLogPath/mysql-slow.log
    long_query_time = 3
    log_bin = $MysqlLogPath/mysql-bin
    log_bin_index = $MysqlLogPath/mysql-bin.index
    expire_logs_days = 7
    max_binlog_size = `expr $(df -m $MysqlLogPath |awk 'NR==2{printf "%s\n",$4}') / 10000`M
    default_storage_engine = InnoDB
    innodb_buffer_pool_size = `expr $RamTotal / 100`M
    innodb_log_buffer_size = 8M
    innodb_file_per_table = 1
    innodb_open_files = `expr $FileMax \* $CpuNum / $RamTotal`
    innodb_io_capacity = `expr $FileMax \* $CpuNum / $RamTotal`
    innodb_flush_method = O_DIRECT

    !includedir $$MysqlConfigPath/conf.d
    [mysqld_safe]
    open_files_limit = `expr $FileMax / $CpuNum / 100`
    [isamchk]
    key_buffer  = 16M
    [mysqldump]
    quick
    quote-names
    max_allowed_packet = 16M
    EOF
    # **************************************
     $MysqlPath/scripts/mysql_install_db --user=mysql --defaults-file=$MysqlConfigPath/my.cnf --basedir=$MysqlPath --datadir=$MysqlDataPath;
    # EOF **********************************
    cat > /etc/ld.so.conf.d/mysql.confEOF
    /usr/local/mysql/lib/mysql
    /usr/local/lib
    EOF
    # **************************************
     ldconfig;
     if [ "$SysBit" == '64' ] ; then
      ln -s $MysqlPath/lib/mysql /usr/lib64/mysql;
     else
      ln -s $MysqlPath/lib/mysql /usr/lib/mysql;
     fi;
     cp $MysqlPath/support-files/mysql.server /etc/init.d/mysqld;
     chmod 775 /etc/init.d/mysqld;
     /etc/init.d/mysqld start;
     ln -s $MysqlPath/bin/mysql /usr/bin/mysql;
     ln -s $MysqlPath/bin/mysqladmin /usr/bin/mysqladmin;
     $MysqlPath/bin/mysqladmin password $MysqlPass;
     rm -rf $MysqlDataPath/test;
    # EOF **********************************
    mysql -hlocalhost -uroot -p$MysqlPass EOF
    USE mysql;
    DELETE FROM user WHERE user='';
    UPDATE user set password=password('$MysqlPass') WHERE user='root';
    DELETE FROM user WHERE not (user='root');
    DROP USER ''@'%';
    FLUSH PRIVILEGES;
    EOF
    # **************************************
     echo "[OK] ${MysqlVersion} install completed.";
    }
    INSTALL_MYSQL

    您可能感兴趣的文章:
    • 分享CentOS下MySQL最新版本5.6.13源码安装过程
    • mysql-5.5.28源码安装过程中错误总结
    • apache mysql php 源码编译使用方法
    • Linux下MySQL 5.5.8 源码编译安装记录分享
    • Mysql源码学习笔记 偷窥线程
    • Mysql数据库操作类( 1127版,提供源码下载 )
    • 超级简单的php+mysql留言本源码
    • PHP源码之 ext/mysql扩展部分
    • 一个简单的PHP&MYSQL留言板源码
    • 落伍首发 php+mysql 采用ajax技术的 省 市 地 3级联动无刷新菜单 源码
    上一篇:从apnic提取ip信息脚本分享
    下一篇:使用curl递归下载软件脚本分享
  • 相关文章
  • 

    © 2016-2020 巨人网络通讯 版权所有

    《增值电信业务经营许可证》 苏ICP备15040257号-8

    mysql源码安装脚本分享 mysql,源码,安装,脚本,分享,