mysql5.7多实例安装

[root@vhost1]# cd /opt/source
[root@vhost1]#ls
mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz
[root@vhost1]# tar -zxvf mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz
[root@vhost1]#ln -s /opt/source/mysql-5.7.21-linux-glibc2.12-x86_64 /usr/local/mysql
[root@vhost1]#groupadd -g 500 mysql
[root@vhost1]#useradd -r -g mysql -u 500 -s /bin/false mysql

[root@vhost1]#cd /usr/local/
[root@vhost1]#chown -R mysql.mysql mysql

创建3306端口实例
[root@vhost1]#mkdir -p /data/mysql_3306/{data,logs,run,tmp}
[root@vhost1]#cd /data/mysql_3306/logs
[root@vhost1]#touch mysql_error.log
[root@vhost1]#chown -R mysql.mysql /data/mysql_3306/

[root@vhost1]#vi /data/mysql_3306/my.cnf

[client]
port = 3306
socket = /data/mysql_3306/run/mysql.sock

[mysqld]
port = 3306
socket = /data/mysql_3306/run/mysql.sock
pid_file = /data/mysql_3306/run/mysql.pid
basedir = /usr/local/mysql
datadir = /data/mysql_3306/data

default_storage_engine = InnoDB
max_allowed_packet = 128M
max_connections = 1024
open_files_limit = 65535

skip-name-resolve
lower_case_table_names=1

character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'

innodb_buffer_pool_size = 8192M
innodb_buffer_pool_instances = 8
innodb_buffer_pool_load_at_startup = 1
innodb_buffer_pool_dump_at_shutdown = 1
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 2
innodb_data_home_dir=/data/mysql_3306/data/
innodb_log_group_home_dir=/data/mysql_3306/logs/
innodb_log_files_in_group=3
innodb_log_file_size=512M
innodb_data_file_path=ibdata1:512M:autoextend
log_slave_updates=1
binlog-format=ROW
key_buffer_size = 16M
innodb_log_buffer_size  = 32M
innodb_io_capacity = 4000
innodb_io_capacity_max = 8000
innodb_flush_method = O_DIRECT
innodb_print_all_deadlocks = 1

log-error = /data/mysql_3306/logs/mysql_error.log
log-bin = /data/mysql_3306/logs/mysql_bin.log
slow_query_log = 1
slow_query_log_file = /data/mysql_3306/logs/mysql_slow_query.log
long_query_time = 2
sync_binlog     =  1
relay_log_recovery = 1

tmp_table_size = 64M
max_heap_table_size = 64M

server-id=33063

　　

slave_load_tmpdir=/data/mysql/tmp/
tmpdir =/data/mysql/tmp/

初始化mysql
/usr/local/mysql/bin/mysqld --defaults-file=/data/mysql_3306/my.cnf --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql_3306/data
启动实例：
/usr/local/mysql/bin/mysqld_safe --defaults-file=/data/mysql_3306/my.cnf --user=mysql

创建3307端口实例
[root@vhost1]#mkdir -p /data/mysql_3307/{data,logs,run,tmp}
[root@vhost1]#cd /data/mysql_3307/logs
[root@vhost1]#touch mysql_error.log
[root@vhost1]#chown -R mysql.mysql /data/mysql_3307/

[root@vhost1]#vi /data/mysql_3307/my.cnf

初始化mysql
/usr/local/mysql/bin/mysqld --defaults-file=/data/mysql_3307/my.cnf --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql_3307/data
启动实例：
/usr/local/mysql/bin/mysqld_safe --defaults-file=/data/mysql_3307/my.cnf --user=mysql