install_mysql.sh

    1. #!/bin/bash
    3. # 端口
    4. PORT=${1}
    5. # mysql版本
    6. LEVEL=${2}
    7. # 是否多实例, 0, 1
    8. MULTI=${3}
    10. mysqlpackage="/usr/local"
    12. mysqldatapack="/data/mysql"
    14. cat > /etc/my.cnf <<EOFINMYSQLD
    15. [mysql]
    16. no-auto-rehash
    17. prompt='\\u@\\h:\\d \\v \\r:\\m:\\s> '
    18. default-character-set=utf8mb4
    19. show-warnings
    21. [mysqld]
    22. user=mysql
    23. pid-file=/data/mysql/mysqldata${PORT}/sock/mysql.pid
    24. port=${PORT}
    25. socket=/data/mysql/mysqldata${PORT}/sock/mysql.sock
    26. datadir=/data/mysql/mysqldata${PORT}/mydata
    27. tmpdir=/data/mysql/mysqldata${PORT}/tmpdir
    28. slave-load-tmpdir=/data/mysql/mysqldata${PORT}/tmpdir
    30. general-log-file=/data/mysql/mysqldata${PORT}/log/general.log
    31. log-error=/data/mysql/mysqldata${PORT}/log/error.log
    32. slow-query-log-file=/data/mysql/mysqldata${PORT}/log/slow-query.log
    34. server-id=${PORT}
    35. log-bin-index=/data/mysql/mysqldata${PORT}/binlog/mysql-bin.index
    36. log-bin=/data/mysql/mysqldata${PORT}/binlog/mysql-bin
    37. sync-binlog=10
    39. relay-log-index=/data/mysql/mysqldata${PORT}/relaylog/mysql-relay-bin.index
    40. relay-log=/data/mysql/mysqldata${PORT}/relaylog/mysql-relay-bin
    42. character-set-server=utf8mb4
    43. collation-server=utf8mb4_general_ci
    46. innodb-buffer-pool-size=`free -m | grep Mem | awk '{print $2*1024*0.8}'`
    47. innodb-data-home-dir=/data/mysql/mysqldata${PORT}/innodb_ts
    48. innodb-data-file-path=ibdata1:4096M:autoextend
    49. innodb-log-group-home-dir=/data/mysql/mysqldata${PORT}/innodb_log
    50. innodb-log-file-size=128M
    51. innodb-flush-log-at-trx-commit=2
    52. innodb-io-capacity=100
    54. innodb-force-recovery=0
    57. gtid-mode=ON
    58. enforce-gtid-consistency
    59. sql-mode='STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION'
    60. EOFINMYSQLD
    62. # 解压二进制包到指定目录
    63. mysqlpackexists=`ls -l ${mysqlpackage} | grep mysql`
    65. if [[ ${mysqlpackexists} == "" ]];then
    66.     if [[ ${LEVEL} == "5.7" ]];then
    67.         tar -zxvf ./mysql-${LEVEL}* -C ${mysqlpackage}
    68.     fi
    69.     if [[ ${LEVEL} == "8.0" ]];then
    70.         tar -xvf ./mysql-${LEVEL}.*.tar -C ${mysqlpackage}
    71.     fi
    72. else
    73.     echo "mysql binary package is already exists!"
    74. fi
    76. if [ ! -d ${mysqlpackage}/mysql ];then
    77.     ln -s ${mysqlpackage}/mysql-${LEVEL}* ${mysqlpackage}/mysql
    78. fi
    80. # 拷贝mysql.server
    81. if [ ! -f /etc/init.d/mysqld ];then
    82.     cp ${mysqlpackage}/mysql/support-files/mysql.server /etc/init.d/mysqld
    83. fi
    85. # 创建用户
    86. userexists=`cat /etc/passwd | grep mysql`
    87. if [[ ${userexists} == "" ]];then
    88.     useradd mysql
    89. else
    90.     echo "user mysql is already exists!"
    91. fi 
    93. # 创建目录
    94. if [ ! -d ${mysqldatapack}/mysqldata${PORT} ];then
    95.     mkdir -p ${mysqldatapack}/mysqldata${PORT}
    96. fi
    98. mkdir -p  ${mysqldatapack}/mysqldata${PORT}/{mydata,mydata,innodb_ts,innodb_log,relaylog,tmpdir,log,sock,binlog}
    100. chown -R mysql.mysql ${mysqldatapack}/mysqldata${PORT}
    102. # 初始化
    103. #${mysqlpackage}/mysql/bin/mysqld --defaults-file=/tmp/mysqlinstall.cnf --user=mysql --initialize-insecure
    104. ${mysqlpackage}/mysql/bin/mysqld --defaults-file=/etc/my.cnf --user=mysql --initialize-insecure
    105. # 启动
    106. ${mysqlpackage}/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf &
    107. #cat /tmp/mysqlinstall.cnf > /etc/my.cnf
    108. #rm -rf /tmp/mysqlinstall.cnf