mysql8从库并行复制_mysql主库与从库配置（并行复制配置）

主库：

[mysqld]

server-id = 2233

port = 13306

basedir = /usr/local/mysql

datadir = /usr/local/mysql/data

socket = /usr/local/mysql/mysql.sock

pid-file=/usr/local/mysql/data/mysql.pid

skip-external-locking

skip_name_resolve = 0

skip-slave-start

transaction_isolation = REPEATABLE-READ

character-set-server = utf8

collation-server = utf8_general_ci

init_connect='SET NAMES utf8'

lower_case_table_names = 1

max_connections = 2000

max_connect_errors = 1000

max_allowed_packet = 24M

open_files_limit=65536

max_prepared_stmt_count=1048576

tmp_table_size = 256M

max_heap_table_size = 256M

query_cache_size = 128M

query_cache_type = 1

query_cache_limit