[root@10-186-61-109 mysql_package80]# cat my.cnf
[client]
port = 3306
user = root
socket = /data/mysql/3306/data/mysqld.sock
password =
[mysql]
no-auto-rehash
default-character-set = utf8mb4
prompt =‘\U[\d]> ‘
## Base Config
[mysqld]
server_id = 1004
port = 3306
mysqlx_port = 33060
admin_port = 33062
admin_address = 127.0.0.1
default_authentication_plugin = mysql_native_password
basedir = /data/mysql/3306/base
plugin_dir = /data/mysql/3306/base/lib/plugin/
datadir = /data/mysql/3306/data
tmpdir = /data/mysql/3306/tmp
secure_file_priv = /data/mysql/3306/tmp
pid_file = mysqld.pid
socket = /data/mysql/3306/data/mysqld.sock
mysqlx_socket = /data/mysql/3306/data/mysqlx.sock
default_storage_engine = InnoDB
disabled_storage_engines = "MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY"
character_set_server = utf8mb4
collation_server = utf8mb4_bin
explicit_defaults_for_timestamp = 1
skip_slave_start = 1
skip_name_resolve = 1
skip_external_locking = 1
lower_case_table_names = 1
log_timestamps = SYSTEM
transaction_isolation = READ-COMMITTED
read_only = 0
## Connections
max_connections = 2000
max_connect_errors = 1000000
interactive_timeout = 1800
wait_timeout = 1800
## Session Memory Config
read_buffer_size = 8M
read_rnd_buffer_size = 8M
sort_buffer_size = 2M
join_buffer_size = 8M
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
## Cache Config
key_buffer_size = 16M
table_definition_cache = 2000
table_open_cache = 2000
table_open_cache_instances = 8
thread_cache_size = 200
open_files_limit = 65535
binlog_cache_size = 1M
## Log Config
log_bin =/data/mysql/3306/binlog/mysql-bin
binlog_format = row
sync_binlog = 1
binlog_error_action = ABORT_SERVER
max_binlog_size = 250M
binlog_rows_query_log_events = 1
binlog_expire_logs_seconds = 604800
log_bin_trust_function_creators = 1
log_slave_updates = 1
relay_log = /data/mysql/3306/relaylog/mysql-relay
relay_log_recovery = 1
master_info_repository = TABLE
relay_log_info_repository = TABLE
log_error = mysql-error.log
slow_query_log_file = mysql-slow.log
slow_query_log = 1
long_query_time = 0.2
log_queries_not_using_indexes = 1
log_slow_admin_statements = 1
log_slow_slave_statements = 1
log_throttle_queries_not_using_indexes = 10
## InnoDB Config
innodb_file_per_table = 1
innodb_data_file_path = ibdata1:1024M:autoextend
innodb_flush_log_at_trx_commit = 1
innodb_buffer_pool_size = 128M
innodb_buffer_pool_instances = 8
innodb_buffer_pool_load_at_startup = 1
innodb_buffer_pool_dump_at_shutdown = 1
innodb_buffer_pool_dump_pct = 25
innodb_lock_wait_timeout = 10
innodb_io_capacity = 1000
innodb_io_capacity_max = 2000
innodb_max_dirty_pages_pct = 60
innodb_flush_method = O_DIRECT
innodb_flush_neighbors = 0
innodb_log_group_home_dir = /data/mysql/3306/redolog
innodb_log_file_size = 2G
innodb_log_files_in_group = 3
innodb_log_buffer_size = 64M
innodb_purge_threads = 4
innodb_write_io_threads = 8
innodb_read_io_threads = 8
innodb_thread_concurrency = 0
innodb_print_all_deadlocks = 1
innodb_strict_mode = 1
innodb_sort_buffer_size = 8M
innodb_stats_persistent_sample_pages = 64
innodb_autoinc_lock_mode = 2
innodb_online_alter_log_max_size = 1G
innodb_open_files = 4096
innodb_temp_data_file_path = ibtmp1:12M:autoextend:max:50G
## Undo Log Config
innodb_undo_log_truncate = 1
innodb_max_undo_log_size = 8G
## GTID Config
gtid_mode = ON
enforce_gtid_consistency = 1
binlog_gtid_simple_recovery = 1
## Semi sync Config
plugin_load = "rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so"
loose_rpl_semi_sync_master_enabled = 0
loose_rpl_semi_sync_slave_enabled = 0
loose_rpl_semi_sync_master_timeout = 30000
loose_rpl_semi_sync_master_wait_for_slave_count = 1
loose_rpl_semi_sync_master_wait_no_slave = 0
## Password Validate Plugin
plugin-load-add = validate_password.so
loose_validate_password_policy = MEDIUM
## MTS Config
slave-parallel-type = LOGICAL_CLOCK
slave_parallel_workers = 8
slave_preserve_commit_order = ON
## Performance Schema Config
performance-schema-instrument = ‘wait/lock/metadata/sql/mdl=ON‘
performance-schema-instrument = ‘memory/%=COUNTED‘
## Other
innodb_numa_interleave = 1
## group replication
plugin_load_add = "group_replication.so"
binlog_checksum = NONE
transaction_write_set_extraction = XXHASH64
report_host = 10.186.61.109
loose_group_replication = FORCE_PLUS_PERMANENT
loose_group_replication_start_on_boot = OFF
loose_group_replication_group_name = f657ae0e-1111-11e8-8bd0-0242ac222222
loose_group_replication_local_address = "10.186.61.109:33061"
loose_group_replication_group_seeds = "10.186.61.109:33061,10.186.61.109:33071,10.186.61.109:33081"
loose_group_replication_single_primary_mode = ON
loose_group_replication_bootstrap_group = OFF
loose_group_replication_ip_whitelist = ‘10.186.61.109/24‘
## MGR flow control
loose_group_replication_flow_control_applier_threshold = 250000
loose_group_replication_flow_control_certifier_threshold = 250000
## Clone Plugin
plugin-load-add = mysql_clone.so
loose_clone = FORCE_PLUS_PERMANENT
使用MySQ Clone Plugin部署MySQL Group Replication