CentOS6.5 上部署 MySQL5.7.17 二進(jìn)制安裝以及多實(shí)例配置
更新時(shí)間：2017年01月21日 16:20:12 作者：雁南飛丶
這篇文章主要介紹了CentOS6.5 上部署 MySQL5.7.17 二進(jìn)制安裝以及多實(shí)例配置,需要的朋友可以參考下
1、建用戶、下載、解壓
groupadd mysql useradd -r -g mysql mysql wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz tar xvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz -C /usr/local/ ln -sv /usr/local/mysql-5.7.17-linux-glibc2.5-x86_64 /usr/local/mysql
2、輸出環(huán)境變量、幫助
/etc/profile export PATH=$PATH:/usr/local/mysql/bin source /etc/profile vim /etc/man.config MANPATH /usr/local/mysql/man
3、創(chuàng)建數(shù)據(jù)目錄、授權(quán)、初始化mysql mysql5.7.7及以上做了很多改變，5.7.7以前安裝方法和以前差不多，初始化也保留了mysql_install_db，5.7.7以后則去掉了該腳本，使用了-initialize 或者 --initialize-insecure 參數(shù)作為初始化。
mysql5.7.14版本初始化時(shí)候已經(jīng)拋棄了defaults-file參數(shù)文件，所以在初始化時(shí)候指定配置文件會(huì)出錯(cuò)，同時(shí)必須保證datadir為空。
mkdir /data/mysql chown mysql.mysql /data/mysql [root@leo mysql]# mysqld --verbose --help |more 查看更多初始化參數(shù) [root@leo mysql]# /usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql 2016-12-21T09:37:13.532770Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-12-21T09:37:16.364569Z 0 [Warning] InnoDB: New log files created, LSN=45790 2016-12-21T09:37:16.881727Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2016-12-21T09:37:17.115686Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 0fbca93f-c761-11e6-9409-000c299a8601. 2016-12-21T09:37:17.220886Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2016-12-21T09:37:17.284087Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
初始化成功了。這里說明下，初始化參數(shù)我使用了--initialize-insecure，這樣不會(huì)設(shè)置初始化root密碼，如果是 --initialize的話，會(huì)隨機(jī)生成一個(gè)密碼：
4、設(shè)置加密連接
[root@leo mysql]# /usr/local/mysql/bin/mysql_ssl_rsa_setup Generating a 2048 bit RSA private key ..........................................................+++ .......+++ writing new private key to 'ca-key.pem' ----- Generating a 2048 bit RSA private key ...........+++ ...........................................+++ writing new private key to 'server-key.pem' ----- Generating a 2048 bit RSA private key ............................................+++ .............................................................+++ writing new private key to 'client-key.pem' -----
5、復(fù)制配置文件和啟動(dòng)腳本
[root@leo mysql]# cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf [root@leo mysql]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
6、配置如下
[root@leo mysql]# cat /etc/my.cnf # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the # *** default location during install, and will be replaced if you # *** upgrade to a newer version of MySQL. [mysqld] # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # These are commonly set, remove the # and set as required. basedir=/usr/local/mysql datadir=/data/mysql port=3306 server_id=1 socket=/data/mysql/mysql.sock symbolic-links=0 character_set_server=utf8 # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES [client] socket=/data/mysql/mysql.sock
7、啟動(dòng)、并查看日志
[root@leo ~]# /etc/init.d/mysqld start Starting MySQL.Logging to '/data/mysql/leo.err'. . [確定] [root@leo ~]# /etc/init.d/mysqld restart Shutting down MySQL.. [確定] Starting MySQL.. [確定] [root@leo ~]# tail -f /data/mysql/leo.err 2016-12-21T09:42:48.493804Z 0 [Note] - '::' resolves to '::'; 2016-12-21T09:42:48.493834Z 0 [Note] Server socket created on IP: '::'. 2016-12-21T09:42:48.493990Z 0 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/ib_buffer_pool 2016-12-21T09:42:48.496446Z 0 [Note] InnoDB: Buffer pool(s) load completed at 161221 17:42:48 2016-12-21T09:42:48.512719Z 0 [Note] Event Scheduler: Loaded 0 events 2016-12-21T09:42:48.512907Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2016-12-21T09:42:48.512922Z 0 [Note] Beginning of list of non-natively partitioned tables 2016-12-21T09:42:48.529189Z 0 [Note] End of list of non-natively partitioned tables 2016-12-21T09:42:48.529703Z 0 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.7.17' socket: '/data/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
8、登錄測試
[root@leo mysql]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 Server version: 5.7.17 MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ 4 rows in set (0.01 sec) mysql> [root@leo mysql]# ps -ef |grep mysql root 49305 1 0 17:54 pts/0 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data/mysql --pid-file=/data/mysql/leo.pid mysql 49501 49305 0 17:54 pts/0 00:00:01 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data/mysql --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/data/mysql/leo.err --pid-file=/data/mysql/leo.pid --socket=/data/mysql/mysql.sock --port=3306 root 49598 46306 0 18:14 pts/0 00:00:00 grep mysql
多實(shí)例配置部分
1、復(fù)制多實(shí)例啟動(dòng)腳本
[root@leo ~]# cp /usr/local/mysql/support-files/mysqld_multi.server /etc/init.d/mysqld_multi
2、初始化數(shù)據(jù)庫目錄并修改多實(shí)例配置文件
mkdir /data/mysql2 mkdir /data/mysql3 chown mysql.mysql /data/mysql2 chown mysql.mysql /data/mysql3 [root@leo ~]# /usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql2 2016-12-21T16:36:00.886650Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-12-21T16:36:06.481686Z 0 [Warning] InnoDB: New log files created, LSN=45790 2016-12-21T16:36:07.145444Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2016-12-21T16:36:07.443823Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 92945fc8-c79b-11e6-88a5-000c299a8601. 2016-12-21T16:36:07.453113Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2016-12-21T16:36:07.456819Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. [root@leo ~]# /usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql3 2016-12-21T16:36:16.094948Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-12-21T16:36:21.224144Z 0 [Warning] InnoDB: New log files created, LSN=45790 2016-12-21T16:36:21.900500Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2016-12-21T16:36:22.095535Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 9b500f71-c79b-11e6-8af0-000c299a8601. 2016-12-21T16:36:22.105950Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2016-12-21T16:36:22.112685Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. [root@leo ~]# cat /etc/my.cnf # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the # *** default location during install, and will be replaced if you # *** upgrade to a newer version of MySQL. [mysqld_multi] mysqld=/usr/local/mysql/bin/mysqld_safe mysqladmin=/usr/local/mysql/bin/mysqladmin log=/data/mysql_multi.log user = root password = redhat # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # These are commonly set, remove the # and set as required. [mysqld1] basedir=/usr/local/mysql datadir=/data/mysql port=3306 server_id=1 socket=/data/mysql/mysql.sock symbolic-links=0 character_set_server=utf8 pid-file=/data/mysql/mysql.pid [mysqld2] datadir=/data/mysql2 port=3307 socket=/data/mysql2/mysql.sock symbolic-links=0 character_set_server=utf8 pid-file=/data/mysql2/mysql2.pid [mysqld3] datadir=/data/mysql3 port=3308 socket=/data/mysql3/mysql.sock symbolic-links=0 character_set_server=utf8 pid-file=/data/mysql3/mysql3.pid # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES #[client] #socket=/data/mysql/mysql.sock
3、啟動(dòng)多實(shí)例測試并查看日志
[root@leo ~]# /etc/init.d/mysqld_multi start [root@leo ~]# /etc/init.d/mysqld_multi report Reporting MySQL servers MySQL server from group: mysqld1 is running MySQL server from group: mysqld2 is running MySQL server from group: mysqld3 is running [root@leo ~]# netstat -antlp |grep :330* tcp 0 0 :::3307 :::* LISTEN 55762/mysqld tcp 0 0 :::3308 :::* LISTEN 55765/mysqld tcp 0 0 :::3306 :::* LISTEN 55764/mysqld
4、連接測試
[root@leo ~]# mysql -uroot -h127.0.0.1 -P3308 -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.17 MySQL Community Server (GPL)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
mysql> grant shutdown on *.* to 'root'@'%' identified by 'redhat'; #授權(quán)
Query OK, 0 rows affected, 1 warning (0.08 sec)
mysql>flush provileges;
update mysql.user set authentication_string=password('redhat') where user='root' and Host = 'localhost';#設(shè)置mysql登錄密碼
[root@leo ~]# mysqladmin -uroot -p -S /data/mysql3/mysql.sock shutdown #關(guān)閉實(shí)例
Enter password:
5、附帶腳本多實(shí)例管理腳本
stop關(guān)閉MySQL實(shí)例，注意此處是需要一個(gè)具有shutdown權(quán)限的用戶，且密碼并被是加密的，也不可以交互式輸入密碼，Linux又具有history功能，所以為了數(shù)據(jù)庫的安全，還是不要用mysqld_multi stop的方式關(guān)閉數(shù)據(jù)庫了吧
[root@leo ~]# cat /etc/init.d/mysqld_multi
#!/bin/sh
#
# A simple startup script for mysqld_multi by Tim Smith and Jani Tolonen.
# This script assumes that my.cnf file exists either in /etc/my.cnf or
# /root/.my.cnf and has groups [mysqld_multi] and [mysqldN]. See the
# mysqld_multi documentation for detailed instructions.
#
# This script can be used as /etc/init.d/mysql.server
#
# Comments to support chkconfig on RedHat Linux
# chkconfig: 2345 64 36
# description: A very fast and reliable SQL database engine.
#
# Version 1.0
#
basedir=/usr/local/mysql
bindir=/usr/local/mysql/bin
conf=/etc/my.cnf
if test -x $bindir/mysqld_multi
then
mysqld_multi="$bindir/mysqld_multi";
else
echo "Can't execute $bindir/mysqld_multi from dir $basedir";
exit;
fi
case "$1" in
'start' )
"$mysqld_multi" --defaults-extra-file=$conf start $2
;;
'stop' )
"$mysqld_multi" --defaults-extra-file=$conf stop $2 --user=root --password=redhat
;;
'report' )
"$mysqld_multi" --defaults-extra-file=$conf report $2
;;
'restart' )
"$mysqld_multi" --defaults-extra-file=$conf stop $2 --user=root --password=redhat
"$mysqld_multi" --defaults-extra-file=$conf start $2
;;
*)
echo "Usage: $0 {start|stop|report|restart}" >&2
;;
esac
6、多實(shí)例測試啟停
[root@leo ~]# /etc/init.d/mysqld_multi stop [root@leo ~]# /etc/init.d/mysqld_multi report Reporting MySQL servers MySQL server from group: mysqld1 is not running MySQL server from group: mysqld2 is not running MySQL server from group: mysqld3 is not running [root@leo ~]# /etc/init.d/mysqld_multi start [root@leo ~]# /etc/init.d/mysqld_multi report Reporting MySQL servers MySQL server from group: mysqld1 is running MySQL server from group: mysqld2 is running MySQL server from group: mysqld3 is running [root@leo ~]# netstat -antlp |grep :330* #查看監(jiān)聽端口 tcp 0 0 :::3307 :::* LISTEN 74667/mysqld tcp 0 0 :::3308 :::* LISTEN 74666/mysqld tcp 0 0 :::3306 :::* LISTEN 74665/mysqld [root@leo ~]# mysql -uroot -predhat -P3307 -h127.0.0.1 #登錄3307 測試 mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.7.17 MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | | t1 | +--------------------+ 5 rows in set (0.13 sec) mysql> [root@leo ~]# tail -f /data/mysql3/leo.err #查看日志 2016-12-21T21:47:56.114139Z 0 [Note] Server hostname (bind-address): '*'; port: 3308 2016-12-21T21:47:56.145404Z 0 [Note] IPv6 is available. 2016-12-21T21:47:56.169487Z 0 [Note] - '::' resolves to '::'; 2016-12-21T21:47:56.171033Z 0 [Note] Server socket created on IP: '::'. 2016-12-21T21:47:57.157171Z 0 [Note] Event Scheduler: Loaded 0 events 2016-12-21T21:47:57.157710Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2016-12-21T21:47:57.157729Z 0 [Note] Beginning of list of non-natively partitioned tables 2016-12-21T21:47:58.138317Z 0 [Note] End of list of non-natively partitioned tables 2016-12-21T21:47:58.138474Z 0 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.7.17' socket: '/data/mysql3/mysql.sock' port: 3308 MySQL Community Server (GPL)
mysqld_multi啟動(dòng)會(huì)查找my.cnf文件中的[mysqldN]組，N為mysqld_multi后攜帶的整數(shù)值。 mysqld_multi的固定選項(xiàng)可在配置文件my.cnf中進(jìn)行配置，在[mysqld_multi]組下配置（如果沒有該組，可自行建立）。 mysqld_multi使用方式如下： mysqld_multi [options] {start|stop|reload|report} [GNR[,GNR] ...]
以上所述是小編給大家介紹的CentOS6.5 上部署 MySQL5.7.17 二進(jìn)制安裝以及多實(shí)例配置，希望對(duì)大家有所幫助，如果大家有任何疑問請(qǐng)給我留言，小編會(huì)及時(shí)回復(fù)大家的。在此也非常感謝大家對(duì)腳本之家網(wǎng)站的支持！
您可能感興趣的文章:
- Linux下MySQL5.7.18二進(jìn)制包安裝教程（無默認(rèn)配置文件my_default.cnf）
- Mysql5.7.18版本（二進(jìn)制包安裝）自定義安裝路徑教程詳解
- Centos 7 安裝mysql5.7.24二進(jìn)制 版本的方法及解決辦法
- Centos7.5安裝mysql5.7.24二進(jìn)制包方式部署
- CentOS 7 中以命令行方式安裝 MySQL 5.7.11 for Linux Generic 二進(jìn)制版本教程詳解
- linux二進(jìn)制通用包安裝mysql5.6.20教程
- ubuntu系統(tǒng)中安裝mysql5.6(通過二進(jìn)制)
- mysql 5.7.19 二進(jìn)制最新安裝
- Linux下mysql5.6.24（二進(jìn)制）自動(dòng)安裝腳本
- Mysql二進(jìn)制安裝與備份的全過程記錄
相關(guān)文章
這篇文章主要介紹了ubuntu16.04設(shè)置寬帶連接的圖文教程,需要的朋友可以參考下2017-09-09
#進(jìn)度條：顧名思義就是看計(jì)算機(jī)處理任務(wù)時(shí)的速度，完成度。下面通過本文給大家分享Linux簡易彩色進(jìn)度條的實(shí)例代碼，需要的朋友參考下吧2017-11-11
這篇文章主要介紹了Linux下scp無密碼上傳 下載 文件 目錄的方法，非常不錯(cuò)，具有參考借鑒價(jià)值,需要的朋友可以參考下2017-11-11
Linux系統(tǒng)中防火墻的框架分析...2006-10-10
國產(chǎn)中文操作系統(tǒng)OpenDesktop
國產(chǎn)中文操作系統(tǒng)OpenDesktop...2006-10-10
安裝linux后 如何安裝win2000？...2006-10-10
linux 安裝過程全攻略...2006-10-10
CentOS是自帶OpenJDK的，但遺憾的是有些軟件需要在OracleJDK下才能正常的工作，所以需要卸載并重新安裝。接下來通過本文給大家分享CentOS7下java環(huán)境的搭建教程，一起看看吧2017-01-01
CentOS6.5下安裝Mysql5.7.18，首先先下載mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz，傳到CentOS6.5系統(tǒng)下的/usr/local目錄下，具體執(zhí)行命令大家參考下本文吧2017-04-04
Linux中輕松使用USB移動(dòng)存儲(chǔ)器...2006-10-10