!include ../suite/rpl/my.cnf [mysqld.1] master-info-repository=TABLE relay-log-info-repository=TABLE log-slave-updates gtid_mode=ON enforce-gtid-consistency sync_master_info=0 binlog_rows_query_log_events=1 sync_relay_log_info=1 slave_parallel_workers=0 binlog_format=row internal_tmp_disk_storage_engine = InnoDB default_tmp_storage_engine = InnoDB transaction_isolation = READ-COMMITTED binlog_checksum = CRC32 slave_sql_verify_checksum = on read_only relay_log_recovery = on sync_relay_log = 0 event_scheduler = on slave_preserve_commit_order = 0 relay_log_space_limit = 0 slave_parallel_type = DATABASE replicate-ignore-db = ops binlog_row_image = minimal relay_log_purge = on binlog_error_action = ABORT_SERVER binlog-ignore-db = ops max_binlog_size = 1G rpl_stop_slave_timeout = 86400 log_bin_trust_function_creators slave_checkpoint_group = 524280 slave_type_conversions = ALL_NON_LOSSY query_cache_size = 0 query_cache_type = 0 skip_external_locking innodb_log_checksums = on innodb_compression_level = 6 innodb_stats_persistent = on innodb_api_enable_mdl = on innodb_ft_enable_diag_print = off innodb_buffer_pool_dump_pct = 100 innodb_flush_log_at_trx_commit = 1 innodb_doublewrite = on innodb_checksum_algorithm = crc32 innodb_stats_auto_recalc innodb_stats_method = nulls_equal innodb_lock_wait_timeout = 50 innodb_adaptive_hash_index = on innodb_fast_shutdown = 0 innodb_status_output = off innodb_default_row_format = DYNAMIC innodb_ft_enable_stopword = on sync_binlog = 1 innodb_autoinc_lock_mode = 2 innodb_log_compressed_pages = off innodb_strict_mode = on innodb_api_trx_level = 1 innodb_fill_factor = 100 innodb_file_per_table = on innodb_sort_buffer_size = 64M innodb_thread_concurrency = 0 innodb_buffer_pool_dump_at_shutdown = on innodb_table_locks = on innodb_flush_log_at_timeout = 60 innodb_online_alter_log_max_size = 16G innodb_force_recovery = 0 innodb_max_purge_lag = 0 innodb_log_files_in_group = 2 innodb_replication_delay = 0 innodb_buffer_pool_load_at_startup = on innodb_buffer_pool_instances = 8 innodb_api_enable_binlog = on innodb_monitor_enable = all innodb_cmp_per_index_enabled = off innodb_stats_persistent_sample_pages = 128 innodb_rollback_on_timeout = on innodb_status_output_locks = on innodb_stats_on_metadata = off innodb_flush_neighbors = 1 innodb_force_load_corrupted = off innodb_api_disable_rowlock = off innodb_use_native_aio innodb_flush_sync = on innodb_change_buffering = all innodb_commit_concurrency = 0 innodb_adaptive_flushing = on [mysqld.2] master-info-repository=TABLE relay-log-info-repository=TABLE log-slave-updates gtid_mode=ON enforce-gtid-consistency sync_master_info=0 binlog_rows_query_log_events=1 sync_relay_log_info=1 slave_parallel_workers=0 binlog_format=row internal_tmp_disk_storage_engine = InnoDB default_tmp_storage_engine = InnoDB transaction_isolation = READ-COMMITTED binlog_checksum = CRC32 slave_sql_verify_checksum = on read_only relay_log_recovery = on sync_relay_log = 0 event_scheduler = on slave_preserve_commit_order = 0 relay_log_space_limit = 0 slave_parallel_type = DATABASE replicate-ignore-db = ops binlog_row_image = minimal relay_log_purge = on binlog_error_action = ABORT_SERVER binlog-ignore-db = ops max_binlog_size = 1G rpl_stop_slave_timeout = 86400 log_bin_trust_function_creators slave_checkpoint_group = 524280 slave_type_conversions = ALL_NON_LOSSY query_cache_size = 0 query_cache_type = 0 skip_external_locking innodb_log_checksums = on innodb_compression_level = 6 innodb_stats_persistent = on innodb_api_enable_mdl = on innodb_ft_enable_diag_print = off innodb_buffer_pool_dump_pct = 100 innodb_flush_log_at_trx_commit = 1 innodb_doublewrite = on innodb_checksum_algorithm = crc32 innodb_stats_auto_recalc innodb_stats_method = nulls_equal innodb_lock_wait_timeout = 50 innodb_adaptive_hash_index = on innodb_fast_shutdown = 0 innodb_status_output = off innodb_default_row_format = DYNAMIC innodb_ft_enable_stopword = on sync_binlog = 1 innodb_autoinc_lock_mode = 2 innodb_log_compressed_pages = off innodb_strict_mode = on innodb_api_trx_level = 1 innodb_fill_factor = 100 innodb_file_per_table = on innodb_sort_buffer_size = 64M innodb_thread_concurrency = 0 innodb_buffer_pool_dump_at_shutdown = on innodb_table_locks = on innodb_flush_log_at_timeout = 60 innodb_online_alter_log_max_size = 16G innodb_force_recovery = 0 innodb_max_purge_lag = 0 innodb_log_files_in_group = 2 innodb_replication_delay = 0 innodb_buffer_pool_load_at_startup = on innodb_buffer_pool_instances = 8 innodb_api_enable_binlog = on innodb_monitor_enable = all innodb_cmp_per_index_enabled = off innodb_stats_persistent_sample_pages = 128 innodb_rollback_on_timeout = on innodb_status_output_locks = on innodb_stats_on_metadata = off innodb_flush_neighbors = 1 innodb_force_load_corrupted = off innodb_api_disable_rowlock = off innodb_use_native_aio innodb_flush_sync = on innodb_change_buffering = all innodb_commit_concurrency = 0 innodb_adaptive_flushing = on [mysqld.3] master-info-repository=TABLE relay-log-info-repository=TABLE log-slave-updates gtid_mode=ON enforce-gtid-consistency sync_master_info=0 binlog_rows_query_log_events=1 sync_relay_log_info=1 slave_parallel_workers=0 binlog_format=row internal_tmp_disk_storage_engine = InnoDB default_tmp_storage_engine = InnoDB transaction_isolation = READ-COMMITTED binlog_checksum = CRC32 slave_sql_verify_checksum = on read_only relay_log_recovery = on sync_relay_log = 0 event_scheduler = on slave_preserve_commit_order = 0 relay_log_space_limit = 0 slave_parallel_type = DATABASE replicate-ignore-db = ops binlog_row_image = minimal relay_log_purge = on binlog_error_action = ABORT_SERVER binlog-ignore-db = ops max_binlog_size = 1G rpl_stop_slave_timeout = 86400 log_bin_trust_function_creators slave_checkpoint_group = 524280 slave_type_conversions = ALL_NON_LOSSY query_cache_size = 0 query_cache_type = 0 skip_external_locking innodb_log_checksums = on innodb_compression_level = 6 innodb_stats_persistent = on innodb_api_enable_mdl = on innodb_ft_enable_diag_print = off innodb_buffer_pool_dump_pct = 100 innodb_flush_log_at_trx_commit = 1 innodb_doublewrite = on innodb_checksum_algorithm = crc32 innodb_stats_auto_recalc innodb_stats_method = nulls_equal innodb_lock_wait_timeout = 50 innodb_adaptive_hash_index = on innodb_fast_shutdown = 0 innodb_status_output = off innodb_default_row_format = DYNAMIC innodb_ft_enable_stopword = on sync_binlog = 1 innodb_autoinc_lock_mode = 2 innodb_log_compressed_pages = off innodb_strict_mode = on innodb_api_trx_level = 1 innodb_fill_factor = 100 innodb_file_per_table = on innodb_sort_buffer_size = 64M innodb_thread_concurrency = 0 innodb_buffer_pool_dump_at_shutdown = on innodb_table_locks = on innodb_flush_log_at_timeout = 60 innodb_online_alter_log_max_size = 16G innodb_force_recovery = 0 innodb_max_purge_lag = 0 innodb_log_files_in_group = 2 innodb_replication_delay = 0 innodb_buffer_pool_load_at_startup = on innodb_buffer_pool_instances = 8 innodb_api_enable_binlog = on innodb_monitor_enable = all innodb_cmp_per_index_enabled = off innodb_stats_persistent_sample_pages = 128 innodb_rollback_on_timeout = on innodb_status_output_locks = on innodb_stats_on_metadata = off innodb_flush_neighbors = 1 innodb_force_load_corrupted = off innodb_api_disable_rowlock = off innodb_use_native_aio innodb_flush_sync = on innodb_change_buffering = all innodb_commit_concurrency = 0 innodb_adaptive_flushing = on [mysqld.4] master-info-repository=TABLE relay-log-info-repository=TABLE log-slave-updates gtid_mode=ON enforce-gtid-consistency sync-master-info=0 relay-log-purge=0 binlog_rows_query_log_events=0 sync_relay_log_info=0 slave_parallel_workers=4 binlog_format=row internal_tmp_disk_storage_engine = InnoDB default_tmp_storage_engine = InnoDB transaction_isolation = READ-COMMITTED binlog_checksum = CRC32 slave_sql_verify_checksum = on read_only relay_log_recovery = on sync_relay_log = 0 event_scheduler = on slave_preserve_commit_order = 0 relay_log_space_limit = 0 slave_parallel_type = DATABASE replicate-ignore-db = ops binlog_row_image = minimal relay_log_purge = on binlog_error_action = ABORT_SERVER binlog-ignore-db = ops max_binlog_size = 1G rpl_stop_slave_timeout = 86400 log_bin_trust_function_creators slave_checkpoint_group = 524280 slave_type_conversions = ALL_NON_LOSSY query_cache_size = 0 query_cache_type = 0 skip_external_locking innodb_log_checksums = on innodb_compression_level = 6 innodb_stats_persistent = on innodb_api_enable_mdl = on innodb_ft_enable_diag_print = off innodb_buffer_pool_dump_pct = 100 innodb_flush_log_at_trx_commit = 1 innodb_doublewrite = on innodb_checksum_algorithm = crc32 innodb_stats_auto_recalc innodb_stats_method = nulls_equal innodb_lock_wait_timeout = 50 innodb_adaptive_hash_index = on innodb_fast_shutdown = 0 innodb_status_output = off innodb_default_row_format = DYNAMIC innodb_ft_enable_stopword = on sync_binlog = 1 innodb_autoinc_lock_mode = 2 innodb_log_compressed_pages = off innodb_strict_mode = on innodb_api_trx_level = 1 innodb_fill_factor = 100 innodb_file_per_table = on innodb_sort_buffer_size = 64M innodb_thread_concurrency = 0 innodb_buffer_pool_dump_at_shutdown = on innodb_table_locks = on innodb_flush_log_at_timeout = 60 innodb_online_alter_log_max_size = 16G innodb_force_recovery = 0 innodb_max_purge_lag = 0 innodb_log_files_in_group = 2 innodb_replication_delay = 0 innodb_buffer_pool_load_at_startup = on innodb_buffer_pool_instances = 8 innodb_api_enable_binlog = on innodb_monitor_enable = all innodb_cmp_per_index_enabled = off innodb_stats_persistent_sample_pages = 128 innodb_rollback_on_timeout = on innodb_status_output_locks = on innodb_stats_on_metadata = off innodb_flush_neighbors = 1 innodb_force_load_corrupted = off innodb_api_disable_rowlock = off innodb_use_native_aio innodb_flush_sync = on innodb_change_buffering = all innodb_commit_concurrency = 0 innodb_adaptive_flushing = on [ENV] SERVER_MYPORT_3=@mysqld.3.port SERVER_MYSOCK_3=@mysqld.3.socket SERVER_MYPORT_4=@mysqld.4.port SERVER_MYSOCK_4=@mysqld.4.socket