mariadb-10.5.sh 7.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215
  1. #!/bin/bash
  2. # Author: yeho <lj2007331 AT gmail.com>
  3. # BLOG: https://linuxeye.com
  4. #
  5. # Notes: OneinStack for CentOS/RedHat 7+ Debian 9+ and Ubuntu 16+
  6. #
  7. # Project home page:
  8. # https://oneinstack.com
  9. # https://github.com/oneinstack/oneinstack
  10. Install_MariaDB105() {
  11. pushd ${oneinstack_dir}/src > /dev/null
  12. id -u mysql >/dev/null 2>&1
  13. [ $? -ne 0 ] && useradd -M -s /sbin/nologin mysql
  14. [ ! -d "${mariadb_install_dir}" ] && mkdir -p ${mariadb_install_dir}
  15. mkdir -p ${mariadb_data_dir};chown mysql:mysql -R ${mariadb_data_dir}
  16. if [ "${dbinstallmethod}" == "1" ]; then
  17. tar zxf mariadb-${mariadb105_ver}-linux-systemd-x86_64.tar.gz
  18. mv mariadb-${mariadb105_ver}-linux-systemd-x86_64/* ${mariadb_install_dir}
  19. sed -i 's@executing mysqld_safe@executing mysqld_safe\nexport LD_PRELOAD=/usr/local/lib/libjemalloc.so@' ${mariadb_install_dir}/bin/mysqld_safe
  20. sed -i "s@/usr/local/mysql@${mariadb_install_dir}@g" ${mariadb_install_dir}/bin/mysqld_safe
  21. elif [ "${dbinstallmethod}" == "2" ]; then
  22. boostVersion2=$(echo ${boost_oldver} | awk -F. '{print $1"_"$2"_"$3}')
  23. tar xzf boost_${boostVersion2}.tar.gz
  24. tar xzf mariadb-${mariadb105_ver}.tar.gz
  25. pushd mariadb-${mariadb105_ver}
  26. cmake . -DCMAKE_INSTALL_PREFIX=${mariadb_install_dir} \
  27. -DMYSQL_DATADIR=${mariadb_data_dir} \
  28. -DDOWNLOAD_BOOST=1 \
  29. -DWITH_BOOST=../boost_${boostVersion2} \
  30. -DSYSCONFDIR=/etc \
  31. -DWITH_INNOBASE_STORAGE_ENGINE=1 \
  32. -DWITH_PARTITION_STORAGE_ENGINE=1 \
  33. -DWITH_FEDERATED_STORAGE_ENGINE=1 \
  34. -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
  35. -DWITH_MYISAM_STORAGE_ENGINE=1 \
  36. -DWITH_EMBEDDED_SERVER=1 \
  37. -DENABLE_DTRACE=0 \
  38. -DENABLED_LOCAL_INFILE=1 \
  39. -DDEFAULT_CHARSET=utf8mb4 \
  40. -DDEFAULT_COLLATION=utf8mb4_general_ci \
  41. -DEXTRA_CHARSETS=all \
  42. -DCMAKE_EXE_LINKER_FLAGS='-ljemalloc'
  43. make -j ${THREAD}
  44. make install
  45. popd
  46. fi
  47. if [ -d "${mariadb_install_dir}/support-files" ]; then
  48. sed -i "s+^dbrootpwd.*+dbrootpwd='${dbrootpwd}'+" ../options.conf
  49. echo "${CSUCCESS}MariaDB installed successfully! ${CEND}"
  50. if [ "${dbinstallmethod}" == "1" ]; then
  51. rm -rf mariadb-${mariadb105_ver}-linux-systemd-x86_64
  52. elif [ "${dbinstallmethod}" == "2" ]; then
  53. rm -rf mariadb-${mariadb105_ver} boost_${boostVersion2}
  54. fi
  55. else
  56. rm -rf ${mariadb_install_dir}
  57. echo "${CFAILURE}MariaDB install failed, Please contact the author! ${CEND}" && grep -Ew 'NAME|ID|ID_LIKE|VERSION_ID|PRETTY_NAME' /etc/os-release
  58. kill -9 $$; exit 1;
  59. fi
  60. /bin/cp ${mariadb_install_dir}/support-files/mysql.server /etc/init.d/mysqld
  61. sed -i "s@^basedir=.*@basedir=${mariadb_install_dir}@" /etc/init.d/mysqld
  62. sed -i "s@^datadir=.*@datadir=${mariadb_data_dir}@" /etc/init.d/mysqld
  63. chmod +x /etc/init.d/mysqld
  64. [ "${PM}" == 'yum' ] && { chkconfig --add mysqld; chkconfig mysqld on; }
  65. [ "${PM}" == 'apt-get' ] && update-rc.d mysqld defaults
  66. popd
  67. # my.cnf
  68. cat > /etc/my.cnf << EOF
  69. [client]
  70. port = 3306
  71. socket = /tmp/mysql.sock
  72. default-character-set = utf8mb4
  73. [mysqld]
  74. port = 3306
  75. socket = /tmp/mysql.sock
  76. basedir = ${mariadb_install_dir}
  77. datadir = ${mariadb_data_dir}
  78. pid-file = ${mariadb_data_dir}/mysql.pid
  79. user = mysql
  80. bind-address = 0.0.0.0
  81. server-id = 1
  82. init-connect = 'SET NAMES utf8mb4'
  83. character-set-server = utf8mb4
  84. skip-name-resolve
  85. #skip-networking
  86. back_log = 300
  87. max_connections = 1000
  88. max_connect_errors = 6000
  89. open_files_limit = 65535
  90. table_open_cache = 128
  91. max_allowed_packet = 500M
  92. binlog_cache_size = 1M
  93. max_heap_table_size = 8M
  94. tmp_table_size = 16M
  95. read_buffer_size = 2M
  96. read_rnd_buffer_size = 8M
  97. sort_buffer_size = 8M
  98. join_buffer_size = 8M
  99. key_buffer_size = 4M
  100. thread_cache_size = 8
  101. query_cache_type = 1
  102. query_cache_size = 8M
  103. query_cache_limit = 2M
  104. ft_min_word_len = 4
  105. log_bin = mysql-bin
  106. binlog_format = mixed
  107. expire_logs_days = 7
  108. log_error = ${mariadb_data_dir}/mysql-error.log
  109. slow_query_log = 1
  110. long_query_time = 1
  111. slow_query_log_file = ${mariadb_data_dir}/mysql-slow.log
  112. performance_schema = 0
  113. #lower_case_table_names = 1
  114. skip-external-locking
  115. default_storage_engine = InnoDB
  116. innodb_file_per_table = 1
  117. innodb_open_files = 500
  118. innodb_buffer_pool_size = 64M
  119. innodb_write_io_threads = 4
  120. innodb_read_io_threads = 4
  121. innodb_purge_threads = 1
  122. innodb_flush_log_at_trx_commit = 2
  123. innodb_log_buffer_size = 2M
  124. innodb_log_file_size = 32M
  125. innodb_max_dirty_pages_pct = 90
  126. innodb_lock_wait_timeout = 120
  127. bulk_insert_buffer_size = 8M
  128. myisam_sort_buffer_size = 8M
  129. myisam_max_sort_file_size = 10G
  130. interactive_timeout = 28800
  131. wait_timeout = 28800
  132. [mysqldump]
  133. quick
  134. max_allowed_packet = 500M
  135. [myisamchk]
  136. key_buffer_size = 8M
  137. sort_buffer_size = 8M
  138. read_buffer = 4M
  139. write_buffer = 4M
  140. EOF
  141. sed -i "s@max_connections.*@max_connections = $((${Mem}/3))@" /etc/my.cnf
  142. if [ ${Mem} -gt 1500 -a ${Mem} -le 2500 ]; then
  143. sed -i 's@^thread_cache_size.*@thread_cache_size = 16@' /etc/my.cnf
  144. sed -i 's@^query_cache_size.*@query_cache_size = 16M@' /etc/my.cnf
  145. sed -i 's@^myisam_sort_buffer_size.*@myisam_sort_buffer_size = 16M@' /etc/my.cnf
  146. sed -i 's@^key_buffer_size.*@key_buffer_size = 16M@' /etc/my.cnf
  147. sed -i 's@^innodb_buffer_pool_size.*@innodb_buffer_pool_size = 128M@' /etc/my.cnf
  148. sed -i 's@^tmp_table_size.*@tmp_table_size = 32M@' /etc/my.cnf
  149. sed -i 's@^table_open_cache.*@table_open_cache = 256@' /etc/my.cnf
  150. elif [ ${Mem} -gt 2500 -a ${Mem} -le 3500 ]; then
  151. sed -i 's@^thread_cache_size.*@thread_cache_size = 32@' /etc/my.cnf
  152. sed -i 's@^query_cache_size.*@query_cache_size = 32M@' /etc/my.cnf
  153. sed -i 's@^myisam_sort_buffer_size.*@myisam_sort_buffer_size = 32M@' /etc/my.cnf
  154. sed -i 's@^key_buffer_size.*@key_buffer_size = 64M@' /etc/my.cnf
  155. sed -i 's@^innodb_buffer_pool_size.*@innodb_buffer_pool_size = 512M@' /etc/my.cnf
  156. sed -i 's@^tmp_table_size.*@tmp_table_size = 64M@' /etc/my.cnf
  157. sed -i 's@^table_open_cache.*@table_open_cache = 512@' /etc/my.cnf
  158. elif [ ${Mem} -gt 3500 ]; then
  159. sed -i 's@^thread_cache_size.*@thread_cache_size = 64@' /etc/my.cnf
  160. sed -i 's@^query_cache_size.*@query_cache_size = 64M@' /etc/my.cnf
  161. sed -i 's@^myisam_sort_buffer_size.*@myisam_sort_buffer_size = 64M@' /etc/my.cnf
  162. sed -i 's@^key_buffer_size.*@key_buffer_size = 256M@' /etc/my.cnf
  163. sed -i 's@^innodb_buffer_pool_size.*@innodb_buffer_pool_size = 1024M@' /etc/my.cnf
  164. sed -i 's@^tmp_table_size.*@tmp_table_size = 128M@' /etc/my.cnf
  165. sed -i 's@^table_open_cache.*@table_open_cache = 1024@' /etc/my.cnf
  166. fi
  167. ${mariadb_install_dir}/scripts/mysql_install_db --user=mysql --basedir=${mariadb_install_dir} --datadir=${mariadb_data_dir}
  168. [ "${Wsl}" == true ] && chmod 600 /etc/my.cnf
  169. chown mysql:mysql -R ${mariadb_data_dir}
  170. [ -d "/etc/mysql" ] && /bin/mv /etc/mysql{,_bk}
  171. service mysqld start
  172. [ -z "$(grep ^'export PATH=' /etc/profile)" ] && echo "export PATH=${mariadb_install_dir}/bin:\$PATH" >> /etc/profile
  173. [ -n "$(grep ^'export PATH=' /etc/profile)" -a -z "$(grep ${mariadb_install_dir} /etc/profile)" ] && sed -i "s@^export PATH=\(.*\)@export PATH=${mariadb_install_dir}/bin:\1@" /etc/profile
  174. . /etc/profile
  175. ${mariadb_install_dir}/bin/mysql -e "grant all privileges on *.* to root@'127.0.0.1' identified by \"${dbrootpwd}\" with grant option;"
  176. ${mariadb_install_dir}/bin/mysql -e "grant all privileges on *.* to root@'localhost' identified by \"${dbrootpwd}\" with grant option;"
  177. ${mariadb_install_dir}/bin/mysql -uroot -p${dbrootpwd} -e "delete from mysql.user where Password='' and User not like 'mariadb.%';"
  178. ${mariadb_install_dir}/bin/mysql -uroot -p${dbrootpwd} -e "delete from mysql.db where User='';"
  179. ${mariadb_install_dir}/bin/mysql -uroot -p${dbrootpwd} -e "delete from mysql.proxies_priv where Host!='localhost';"
  180. ${mariadb_install_dir}/bin/mysql -uroot -p${dbrootpwd} -e "drop database test;"
  181. ${mariadb_install_dir}/bin/mysql -uroot -p${dbrootpwd} -e "reset master;"
  182. rm -rf /etc/ld.so.conf.d/{mysql,mariadb,percona}*.conf
  183. echo "${mariadb_install_dir}/lib" > /etc/ld.so.conf.d/z-mariadb.conf
  184. ldconfig
  185. service mysqld stop
  186. }