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

+ View Code?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53

[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/datadefault_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