date: 2020-08-11title: mysql-5.7.23安装脚本 #标题
tags: mysql #标签
categories: shell # 分类

记录下mysql二进制离线部署脚本。

  1. # tree install-mysql-5.7.23      # 目录结构
  2. install-mysql-5.7.23
  3. ├── install.log    # 脚本安装过程中产生的日志
  4. ├── install-mysql-5.7.23.sh       # 安装脚本
  5. ├── libaio-0.3.109-13.el7.x86_64.rpm    # 某些系统需要此rpm包
  6. ├── my.cnf                      # mysql主配置文件
  7. └── mysql-5.7.23-linux-glibc2.12-x86_64.tar.gz   # mysql二进制包
  11. # cat install-mysql-5.7.23.sh      # 安装脚本内容如下
  12. #!/usr/bin/env bash
  14. init_mysql_root_passwd='cF!TSadGT6y%'
  15. tar_pkg="mysql-5.7.23-linux-glibc2.12-x86_64.tar.gz"
  16. cur_dir="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"
  17. mysql_home=/app/usr/mysql-5.7.23/
  18. mysql_3306=${mysql_home}mysql-3306/
  19. mysql_data=${mysql_3306}data
  20. install_log=${cur_dir}/install.log
  21. item=1
  22. h2() { 
  23.        printf "\n${underline}${bold}${white}%s${reset}\n" "$@"
  24.    }
  26. h2 "[Step $item]: 确认执行此脚本用户是否为root..."; let item+=1
  27. if [[ ${USER} != root ]];then
  28.     echo -e "\033[31m 
  29.              此脚本必须使用 root 执行
  30.              当前用户为 ${USER}
  31.              正在退出脚本...
  32.      \033[0m"
  33.              sleep 1 && exit 1
  34. fi
  37. mkdir -p ${mysql_3306}/{data,logs}
  39. id mysql &> /dev/null || useradd -M -s /sbin/nologin mysql &>> ${install_log}
  40. set -e
  41. h2 "[Step $item]: 解压..."; let item+=1
  42. cd ${cur_dir}
  43. rpm -ivh libaio-0.3.109-13.el7.x86_64.rpm &>> ${install_log}
  44. tar zxf ${tar_pkg} -C ${mysql_home} --strip-components=1
  45. cp ${cur_dir}/my.cnf ${mysql_3306}
  47. h2 "[Step $item]: 配置环境变量..."; let item+=1
  49. cat >> /etc/profile <<EOF
  50. PATH=${mysql_home}bin/:\$PATH
  51. EOF
  52. source /etc/profile
  54. h2 "[Step $item]: 初始化..."; let item+=1
  57. mysqld --initialize --user=mysql --datadir=${mysql_data} --basedir=${mysql_home} &>> ${install_log}
  58. tmp_passwd=$(grep root@localhost ${install_log} | awk -F 'root@localhost: ' '{print $2}')
  61. h2 "[Step $item]: 启动mysql..."; let item+=1
  63. mysqld_safe --defaults-file=${mysql_3306}my.cnf &>> ${install_log} &
  64. sleep 8
  65. # 修改root密码
  66. if [[ $(ss -lnput | grep 3306 | wc -l) -ne 0 ]];then
  67. mysqladmin -uroot -p''${tmp_passwd}'' password ''${init_mysql_root_passwd}''
  68.     echo -e "\033[33m
  69. Mysql 启动成功, 数据库root密码为: ${init_mysql_root_passwd} ,请妥善保管!
  70. 请执行指令    source /etc/profile  重新加载环境变量。
  71.      \033[0m"
  72. fi
  79. # cat my.cnf     # 主配置文件如下
  80. [client]
  81. port=3306
  82. socket=/tmp/mysql.sock
  83. default-character-set=utf8
  85. [mysql]
  86. port=3306
  87. socket=/tmp/mysql.sock
  88. default-character-set=utf8
  90. [mysqld]
  91. port=3306
  92. character-set-server=utf8
  93. socket=/tmp/mysql.sock
  94. basedir=/app/usr/mysql-5.7.23/
  95. datadir=/app/usr/mysql-5.7.23/mysql-3306/data
  96. explicit_defaults_for_timestamp=true
  97. federated
  98. lower_case_table_names=1
  99. secure_file_priv =/app/usr/mysql-5.7.23/mysql-3306
  100. back_log=150
  101. max_connections=3000
  102. max_connect_errors=10
  103. table_open_cache=2048
  104. external-locking=FALSE
  105. secure_file_priv = 
  106. max_allowed_packet=32M
  107. sort_buffer_size=8M
  108. join_buffer_size=8M
  109. thread_cache_size=8
  110. query_cache_size=512M
  111. query_cache_limit=4M
  112. transaction_isolation=REPEATABLE-READ
  113. tmp_table_size=96M
  114. max_heap_table_size=96M
  116. ###***slow query parameters
  117. long_query_time=1
  118. slow_query_log = 1
  119. slow_query_log_file=/app/usr/mysql-5.7.23/mysql-3306/logs/slow.log
  121. #***MyISAM parameters
  122. key_buffer_size=32M
  123. read_buffer_size=2M
  124. read_rnd_buffer_size=16M
  125. bulk_insert_buffer_size=64M
  128. myisam_sort_buffer_size = 16M
  129. myisam_max_sort_file_size = 16M
  130. myisam_repair_threads = 1
  132. skip-name-resolve
  134. ###***master-slave replication parameters
  135. server-id=14063
  136. #slave-skip-errors=all
  138. #***Innodb storage engine parameters
  139. innodb_buffer_pool_size=8192M
  140. innodb_temp_data_file_path = ibtmp1:12M:autoextend:max:5G
  141. innodb_data_file_path=ibdata1:10M:autoextend
  142. #innodb_file_io_threads=8
  143. #innodb_thread_concurrency=16
  144. innodb_flush_log_at_trx_commit=1
  145. innodb_log_buffer_size=16M
  146. innodb_log_file_size=128M
  147. innodb_log_files_in_group=3
  148. innodb_max_dirty_pages_pct=90
  149. innodb_buffer_pool_dump_pct=90
  150. innodb_lock_wait_timeout=2
  151. innodb_file_per_table=on
  153. [mysqldump]
  154. quick
  155. max_allowed_packet=32M
  157. [myisamchk]
  158. key_buffer=16M
  159. sort_buffer_size=16M
  160. read_buffer=8M
  161. write_buffer=8M
  163. [mysqld_safe]
  164. open-files-limit=8192