因使用源碼安裝的MySQL5.7.28多實例，在導入數據庫時會出現問題，所以重新研究使用mysql_multi的方法來管理多實例，經過測試環境驗證之后，在各方面使用上特別在備份還原上，沒有報MySQL5.7.28多實例的問題，踩了不少坑，這里我將我的部署過程分享下，如果在哪里出問題的，還請多多指正與指導，謝謝！！

參考文章：Centos7.5安裝mysql5.7.24二進制包方式部署

https://www.jb51.net/article/151867.htm

本從就直接從2.7章節開始安裝mysql多實例，具體部署過程如下：

2.7 安裝mysql多實例

2.7.1. 創建軟件安裝目錄(部署路徑請根據實際修改)

[root@~]# mkdir -pv /data/mysql/{3306,3307}[root@~]# mkdir -v /data/mysql/3306/{logs,data,binlog}[root@~]# mkdir -v /data/mysql/3307/{logs,data,binlog}

2.7.2. MySQL安裝包下載

[root@~]# cd /opt[root@~]# wget -c https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz[root@~]# tar zxvf mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz[root@~]# mv mysql-5.7.28-linux-glibc2.12-x86_64 /usr/local/mysql[root@~]# chown -R mysql:mysql /usr/local/mysql[root@~]# chown -R mysql:mysql /data

2.7.3. MySQL參數配置

 配置my.cnf參數文件

（1）server_id=3306與server_id=3307數值請根據實際配置，注意配置的id值與局域網內其他各實例所配置的數值不可以沖突；

（2）max_connections=1000配置MySQL數據庫的最大連接數，根據實際需要配置，其他參數的優化根據實際需要修改或添

加；

（3）配置文件全部內容如下

[root@~]# vim /etc/my.cnf[mysqld_multi]mysqld = /usr/local/mysql/bin/mysqldmysqladmin = /usr/local/mysql/bin/mysqladminlog = /data/mysql/mysqld_multi.log #user=root#pass=[mysql]prompt="/u@jsshapp /R:/m:/s [/d]> "no-auto-rehash[mysqld3306]user = mysqlport = 3306symbolic-links = 0#basedir = /usr/datadir = /data/mysql/3306/datasocket = /data/mysql/3306/mysql3306.sockpid-file = /data/mysql/3306/mysqld3306.pidserver_id = 3306character_set_server = utf8max_connections = 1000skip_name_resolve = 1open_files_limit = 65536thread_cache_size = 64table_open_cache = 4096table_definition_cache = 1024table_open_cache_instances = 64max_prepared_stmt_count = 1048576explicit_defaults_for_timestamp = truelog_timestamps = systembinlog_format = rowlog_bin = /data/mysql/3306/binlog/mysql-binbinlog_rows_query_log_events = onexpire_logs_days = 7binlog_cache_size = 4Mmax_binlog_cache_size = 2Gmax_binlog_size = 1Gsync_binlog = 1log_bin_trust_function_creators = 1slow_query_log = onslow_query_log_file = /data/mysql/3306/data/slow.loglog-error = /data/mysql/3306/logs/error.loglog_queries_not_using_indexes = onlong_query_time = 1.000000gtid_mode = onenforce_gtid_consistency = ondefault_storage_engine = innodbdefault_tmp_storage_engine = innodbinnodb_data_file_path = ibdata1:12M:autoextend:max:2000Minnodb_temp_data_file_path = ibtmp1:12M:autoextend:max:2000Minnodb_buffer_pool_filename = ib_buffer_poolinnodb_log_files_in_group = 3innodb_log_file_size = 512Minnodb_online_alter_log_max_size = 1024Minnodb_open_files = 4096innodb_page_size = 16kinnodb_thread_concurrency = 0innodb_read_io_threads = 4innodb_write_io_threads = 4innodb_purge_threads = 4innodb_page_cleaners = 4innodb_print_all_deadlocks = oninnodb_lock_wait_timeout = 20innodb_spin_wait_delay = 128innodb_autoinc_lock_mode = 2innodb_io_capacity = 200innodb_io_capacity_max = 2000#innodb_flush_neighbors = innodb_log_buffer_size = 8Minnodb_flush_log_at_timeout = 1innodb_flush_log_at_trx_commit = 2innodb_buffer_pool_size = 1024Minnodb_buffer_pool_instances = 4autocommit = 1innodb_buffer_pool_dump_pct = 25innodb_buffer_pool_dump_at_shutdown = ONinnodb_buffer_pool_load_at_startup = ON[mysqld3307]user = mysqlport = 3307symbolic-links = 0lower_case_table_names = 1#basedir = /usr/datadir = /data/mysql/3307/datasocket = /data/mysql/3307/mysql3307.sockpid-file = /data/mysql/3307/mysqld3307.pidserver_id = 3307character_set_server = utf8max_connections = 1000skip_name_resolve = 1open_files_limit = 65536thread_cache_size = 64table_open_cache = 4096table_definition_cache = 1024table_open_cache_instances = 64max_prepared_stmt_count = 1048576explicit_defaults_for_timestamp = truelog_timestamps = systembinlog_format = rowlog_bin = /data/mysql/3307/binlog/mysql-binbinlog_rows_query_log_events = onexpire_logs_days = 7binlog_cache_size = 4Mmax_binlog_cache_size = 2Gmax_binlog_size = 1Gsync_binlog = 1slow_query_log = onslow_query_log_file = /data/mysql/3307/data/slow.loglog-error = /data/mysql/3307/logs/error.loglog_queries_not_using_indexes = onlong_query_time = 1.000000gtid_mode = onenforce_gtid_consistency = ondefault_storage_engine = innodbdefault_tmp_storage_engine = innodbinnodb_data_file_path = ibdata1:12M:autoextend:max:2000Minnodb_temp_data_file_path = ibtmp1:12M:autoextend:max:2000Minnodb_buffer_pool_filename = ib_buffer_poolinnodb_log_files_in_group = 3innodb_log_file_size = 512Minnodb_online_alter_log_max_size = 1024Minnodb_open_files = 4096innodb_page_size = 16kinnodb_thread_concurrency = 0innodb_read_io_threads = 4innodb_write_io_threads = 4innodb_purge_threads = 4innodb_page_cleaners = 4innodb_print_all_deadlocks = oninnodb_lock_wait_timeout = 20innodb_spin_wait_delay = 128innodb_autoinc_lock_mode = 2innodb_io_capacity = 200innodb_io_capacity_max = 2000#innodb_flush_neighbors = innodb_log_buffer_size = 8Minnodb_flush_log_at_timeout = 1innodb_flush_log_at_trx_commit = 2innodb_buffer_pool_size = 1024Minnodb_buffer_pool_instances = 4autocommit = 1innodb_buffer_pool_dump_pct = 25innodb_buffer_pool_dump_at_shutdown = ONinnodb_buffer_pool_load_at_startup = ON[mysqldump]quickmax_allowed_packet = 32M