Mysql5.7.17 Installation Deployment

1. Create a MySQL user

Groupadd Mysqluseradd-r-G mysql-s/bin/false MySQL

2. Install MySQL dependency package download 5.7.17 Package

Yum install-y libaiocd/usr/local/src/wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86 _64.TAR.GZTAR-ZXF mysql-5.7.17-linux-glibc2.5-x86_64.tar.gzmkdir-p/data/app/

　　

3. Copy the extracted files to the installation directory and authorize

CP-RF mysql-5.7. --LINUX-GLIBC2.5-x86_64/data/app/mysql-3306CP-RF mysql-5.7. --LINUX-GLIBC2.5-x86_64/data/app/mysql-3307CP-RF mysql-5.7. --LINUX-GLIBC2.5-x86_64/data/app/mysql-3308CP-RF mysql-5.7. --LINUX-GLIBC2.5-x86_64/data/app/mysql-3309Chown-R mysql:mysql/data/app/mysql-3306Chown-R mysql:mysql/data/app/mysql-3307Chown-R mysql:mysql/data/app/mysql-3308Chown-R mysql:mysql/data/app/mysql-3309

4. Initialize the program

/data/app/mysql-3306/bin/mysqld--initialize-insecure--user=mysql--basedir=/data/app/mysql-3306--datadir=/data/app/mysql-3306/Data/data/app/mysql-3307/bin/mysqld--initialize-insecure--user=mysql--basedir=/data/app/mysql-3307--datadir=/data/app/mysql-3307/Data/data/app/mysql-3308/bin/mysqld--initialize-insecure--user=mysql--basedir=/data/app/mysql-3308--datadir=/data/app/mysql-3308/Data/data/app/mysql-3309/bin/mysqld--initialize-insecure--user=mysql--basedir=/data/app/mysql-3309--datadir=/data/app/mysql-3309/data

5. Configure MY.CNF

Modify the parameters that the MY.CNF needs to modify: Server-id: Ensure that each profile is unique and that the self-growth ID of the two master must be different

Linux-node2
Cat>/data/app/mysql-3306/my.cnf<<Eof[client]port=3306Socket=/data/app/mysql-3306/Mysql.sock[mysqld]port=3306User=MySQLServer-ID=1Bind-address =0.0.0.0Basedir=/data/app/mysql-3306DataDir=/data/app/mysql-3306/Datasocket=/data/app/mysql-3306/Mysql.sockpid-file=/data/app/mysql-3306/Mysql.pidlog-error =/data/app/mysql-3306/Mysqld.logskip-name-Resolvelog_bin= mysql-Binlog-slave-Updatessql_mode=no_engine_substitution,strict_trans_tableseofChownmysql.mysql/data/app/mysql-3306/my.cnf----------------------------------------------------------Cat>/data/app/mysql-3307/my.cnf<<Eof[client]port=3307Socket=/data/app/mysql-3307/Mysql.sock[mysqld]port=3307User=MySQLServer-ID= OneBind-address =0.0.0.0Basedir=/data/app/mysql-3307DataDir=/data/app/mysql-3307/Datasocket=/data/app/mysql-3307/Mysql.sockpid-file=/data/app/mysql-3307/Mysql.pidlog-error =/data/app/mysql-3307/Mysqld.logskip-name-Resolvelog_bin= mysql-Binsql_mode=no_engine_substitution,strict_trans_tableseofChownmysql.mysql/data/app/mysql-3306/my.cnf

6. Configure the start MySQL service

Touch/data/app/mysql-3306/mysqld.log &&Chownmysql.mysql/data/app/mysql-3306/Mysqld.logsed-I.'s#/usr/local/mysql#/data/app/mysql-3306#g'/data/app/mysql-3306/bin/Mysqld_safeTouch/data/app/mysql-3307/mysqld.log &&Chownmysql.mysql/data/app/mysql-3307/Mysqld.logsed-I.'s#/usr/local/mysql#/data/app/mysql-3307#g'/data/app/mysql-3307/bin/Mysqld_safeTouch/data/app/mysql-3308/mysqld.log &&Chownmysql.mysql/data/app/mysql-3308/Mysqld.logsed-I.'s#/usr/local/mysql#/data/app/mysql-3308#g'/data/app/mysql-3307/bin/Mysqld_safeTouch/data/app/mysql-3309/mysqld.log &&Chownmysql.mysql/data/app/mysql-3309/Mysqld.logsed-I.'s#/usr/local/mysql#/data/app/mysql-3309#g'/data/app/mysql-3309/bin/mysqld_safe

Start modification: The first type:

vim/data/app/mysql-3306/support-files/mysql.servermysqld_pid_file_path=/data/app/mysql-  3306/basedir=/data/app/mysql-3306/datadir=/data/app/mysql-3306/  DataCP -a/data/app/mysql-3306/support-files/mysql.server/etc/init.d/mv /etc/ Init.d/mysql.server  /etc/init.d/mysql3306chmod +x  /etc/init.d/  Mysql.serverserver mysql3306 Start

Start:3306/data/app/mysql-3306/bin/mysqld_safe--defaults-file=/data/app/mysql-3306/MY.CNF--basedir=/data/app/mysql-3306--datadir=/data/app/mysql-3306/data--user=mysql &Start:3307/data/app/mysql-3307/bin/mysqld_safe--defaults-file=/data/app/mysql-3307/MY.CNF--basedir=/data/app/mysql-3307--datadir=/data/app/mysql-3307/data--user=mysql &Start:3308/data/app/mysql-3308/bin/mysqld_safe--defaults-file=/data/app/mysql-3308/MY.CNF--basedir=/data/app/mysql-3308--datadir=/data/app/mysql-3308/data--user=mysql &Start:3309/data/app/mysql-3309/bin/mysqld_safe--defaults-file=/data/app/mysql-3309/MY.CNF--basedir=/data/app/mysql-3309--datadir=/data/app/mysql-3309/data--user=mysql &

Startup modification: The second type:

Check the boot port:

Ss-lntup | Egrep ' 3306|3307|3308|3309 ' Yum Install --uroot-s/data/app/mysql-3306/mysql.sockyumInstall --uroot-s/data/app/mysql-3307/mysql.sock

Reference post: http://www.cnblogs.com/kevingrace/p/5685511.html

Mysql5.7.17 Installation Deployment