[mysqld]
port = 3306
skip-slave-start
server-id = 9159
report-host = db19-ks2.pr3.tenet
datadir = /data/mysql/db
pid-file = /data/mysql/mysqld.pid
socket = /data/mysql/mysql.sock
tmpdir = /data/mysql/tmp
secure_file_priv = /data/mysql/export_dbs
log-error = /data/mysql/log/error.log
slow_query_log = 1
slow_query_log_file = /data/mysql/log/slow.log
relay-log = /data/mysql/relay-log/relay-bin
relay-log-index = /data/mysql/relay-log/relay-bin.index
relay-log-info-file = /data/mysql/relay-log/relay-log.info
master-info-file = /data/mysql/relay-log/master.info
log_bin = /data/mysql/binlog/binlog
max_binlog_size = 1G
binlog_expire_logs_seconds = 2592000
log_slave_updates = ON
binlog_format = ROW
binlog_order_commits = off
binlog_row_image = minimal
gtid_mode = ON
enforce_gtid_consistency = ON
master_info_repository = TABLE
relay_log_info_repository = TABLE
binlog_checksum = NONE
slave_parallel_workers = 40
slave_parallel_type = LOGICAL_CLOCK
slave_preserve_commit_order = ON
slave_compressed_protocol = ON
max_connections = 600
max-allowed-packet = 64M
net_read_timeout = 480
net_write_timeout = 480
wait_timeout = 300
large-pages
default-storage-engine = innodb
character_set_server = utf8
collation_server = utf8_general_ci # For compatibility hen master: v8.0 and slave: v5.7
innodb_data_home_dir = /data/mysql/innodb
innodb_data_file_path = ibdata1:100M:autoextend
innodb_autoextend_increment = 10
innodb_log_files_in_group = 16
innodb_log_file_size = 128M
innodb_log_write_ahead_size = 8192
innodb_buffer_pool_size = 24G
innodb_buffer_pool_instances = 12
innodb_log_buffer_size = 32M
innodb_lock_wait_timeout = 20
innodb_flush_log_at_trx_commit = 1
innodb_doublewrite = 0
innodb_flush_method = O_DSYNC
innodb_max_dirty_pages_pct = 80
innodb_file_per_table = 1
innodb_thread_concurrency = 0
internal_tmp_mem_storage_engine = TempTable
innodb_io_capacity = 16000
innodb_io_capacity_max = 20000
innodb_write_io_threads = 32
innodb_read_io_threads = 32
innodb_lru_scan_depth = 2000
innodb_flush_neighbors = 0
innodb_strict_mode = 1
innodb_stats_on_metadata = off
innodb_stats_persistent_sample_pages = 40
transaction_isolation = REPEATABLE-READ
innodb_purge_threads = 1
innodb_monitor_enable = log_lsn_last_checkpoint,log_lsn_current
sort_buffer_size = 32M
key_buffer_size = 128M
join_buffer_size = 8M
read_rnd_buffer_size = 4M
read_buffer_size = 128K
tmp_table_size = 512M
max_heap_table_size = 512M
thread_cache_size = 250
skip-name-resolve
explicit_defaults_for_timestamp = 1
log_timestamps = SYSTEM
sql_mode = NO_ENGINE_SUBSTITUTION
log_bin_trust_function_creators = 1
mysqlx = off
mysqlx_cache_cleaner = off
default_time_zone = 'America/New_York'