[mysqld]
basedir=/mysql/rdbms/8.0.22
datadir=/mydata/3306/data
log_error=/mydata/3306/log/error.log
general_log_file=/mydata/3306/log/general.log
slow_query_log_file=/mydata/3306/log/slow.log
socket=/mydata/3306/var/mysql.sock
pid_file=/mydata/3306/var/mysql.pid

log_bin=/mydata/3306/log/mysql-bin
log_bin_index=/mydata/3306/log/mysql-bin.index
relay-log=/mydata/3306/log/relay-log
relay-log-index=/mydata/3306/log/relay-log.index

tmpdir=/mydata/3306/tmp

character-set-server=utf8mb4
skip-character-set-client-handshake
server-id=1
event-scheduler=0
read_only=1
port=3306
default_authentication_plugin=mysql_native_password
#*****common parameters
skip-federated
skip-blackhole
skip-name-resolve
skip_external_locking
flush=OFF
performance_schema=1
default-storage-engine=InnoDB
collation_server=utf8mb4_general_ci
lower_case_table_names=1
sql_mode=‘STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION’
log_timestamps=SYSTEM
optimizer_switch=‘index_merge=off,index_merge_union=off,index_merge_sort_union=off,index_merge_intersection=off’
user=mysql

group_concat_max_len=1048576

back_log=100
max_connections=8000
max_user_connections=7900
thread_cache_size=128
max_connect_errors=99999
wait_timeout=172800
interactive_timeout=172800
net_buffer_length=8K
max_allowed_packet=64M

max_heap_table_size=1G
tmp_table_size=2M

sort_buffer_size=8M
max_length_for_sort_data=16k
join_buffer_size=4M
read_rnd_buffer_size=8M
table_open_cache=1024

skip_name_resolve=1

transaction-isolation=READ-COMMITTED

#******************************* Logs related settings ***************************
long_query_time=0.3
slow_query_log=on
log_queries_not_using_indexes=OFF

binlog_cache_size=256K
max_binlog_size=512M

binlog-format=ROW
binlog-checksum=NONE
sync_binlog=1
#expire_logs_days=7
binlog_expire_logs_seconds=7

#******************************* Replication related settings **********************
log_slave_updates=1
log_bin_trust_function_creators=1
auto_increment_increment=1
auto_increment_offset=1
allow-suspicious-udfs
sysdate-is-now
slave_parallel_workers=4
gtid-mode=ON
enforce-gtid-consistency=ON
master-info-repository=TABLE
relay-log-recovery=1
relay-log-info-repository=TABLE
plugin_load=“rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so”

report_host=LOCAL_IP
report_port=3306

#******************************* Group Replication related settings **********************
transaction_write_set_extraction=XXHASH64

#******************************* MyISAM Specific options ****************************
key_buffer_size=8M
bulk_insert_buffer_size=16M
myisam_sort_buffer_size=64M
myisam_max_sort_file_size=10G
myisam_repair_threads=1
myisam-recover-options=default
read_buffer_size=1M

#***************************** INNODB Specific options ****************************
innodb_buffer_pool_size=500M
innodb_buffer_pool_instances=8
innodb_max_dirty_pages_pct=60
innodb_sort_buffer_size=16M
innodb_data_file_path=ibdata1:12M;ibdata2:16M:autoextend
innodb_autoextend_increment=128
innodb_file_per_table
innodb_open_files=7168

innodb_fast_shutdown=1
innodb_force_recovery=0

innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=64M
innodb_log_file_size=256M
innodb_log_files_in_group=2
innodb_adaptive_flushing_lwm=30

innodb_read_io_threads=8
innodb_write_io_threads=8
innodb_io_capacity=600
innodb_flush_method=O_DIRECT
innodb_flush_neighbors=1
innodb_lru_scan_depth=1024
innodb_change_buffering=all
innodb_purge_threads

innodb_commit_concurrency=0
innodb_thread_concurrency=0
innodb_concurrency_tickets=1024
innodb_autoinc_lock_mode=1

innodb_stats_on_metadata=0
innodb_lock_wait_timeout=120
innodb_rollback_on_timeout=1
innodb_print_all_deadlocks=on

innodb_undo_tablespaces=3
innodb_undo_directory=/mydata/3306/data

#rpl_semi_sync_master_enabled=1
#rpl_semi_sync_master_timeout=500
#rpl_semi_sync_slave_enabled=1

[mysqldump]
quick
max_allowed_packet=2G
default-character-set=utf8mb4

[mysql]
no-auto-rehash
prompt="\u@\h : \d \r:\m:\s> "
default-character-set=utf8mb4
show-warnings

[myisamchk]
key_buffer=512M
sort_buffer_size=512M
read_buffer=8M
write_buffer=8M

[mysqlhotcopy]
interactive-timeout

[mysqld_safe]
user=mysql
open-files-limit=8192

[mysqld-8.0]

new replication settings

slave-parallel-type=LOGICAL_CLOCK
slave-parallel-workers=16
slave_preserve_commit_order=1