my.cnf

[client]
port                                        = 3310
socket                                      = /data/mysql/mysql.sock

[mysql]
prompt                                      = "\u@\h:\p/\d> "  
no-auto-rehash  
tee                                         = /data/mysql/mysql_operation.log
default_character_set                       = utf8mb4

[mysqld]
## 需要根据实际情况修改的参数
port                                        = 3310
server_id                                   = 1083310 
basedir                                     = /usr/local/mysql
datadir                                     = /data/mysql/
pid_file                                    = /data/mysql/mysqld.pid
socket                                      = /data/mysql/mysql.sock
tmpdir                                      = /data/mysql
secure_file_priv                            = /data/mysql
log_bin                                     = /data/mysql/mysql-bin
log_bin_index                               = /data/mysql/mysql-bin-index
slow_query_log_file                         = /data/mysql/slow.log
log-error                                   = /data/mysql/error.log
relay_log                                   = /data/mysql/mysql-relay
relay_log_index                             = /data/mysql/mysql-relay-index
innodb_buffer_pool_size                     = 1G 
default_time_zone                           = "+8:00"   #若MySQL数据库主要运行在境外，请务必根据实际情况调整本参数
#report_host                                 = 192.168.104.108    #填写本IP

## 下面的参数适用于 5.7
#expire_logs_days                            = 3  #注意：MySQL 8.0开始， binlog_expire_logs_seconds 选项也存在的话，会忽略expire_logs_days选项
#query_cache_size                            = 0  
#query_cache_type                            = 0  

## 下面的参数适用于 8.0
binlog_expire_logs_seconds                 = 259200

## 下面的参数适用于主从复制
#loose_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

# 下面的参数适用于双主模式
#auto_increment_offset                      = 1
#auto_increment_increment                   = 2

## 下面的参数适用于MGR
loose_plugin_load_add                       = "group_replication.so"
binlog_checksum                             = NONE
transaction_write_set_extraction            = XXHASH64
loose_group_replication_start_on_boot       = OFF
loose_group_replication_bootstrap_group     = OFF
loose_group_replication_consistency         = BEFORE_ON_PRIMARY_FAILOVER
loose_group_replication_flow_control_applier_threshold     = 250000
loose_group_replication_flow_control_certifier_threshold   = 250000
binlog_transaction_dependency_tracking            = WRITESET

## general
user                                        = mysql
character_set_server                        = utf8mb4
collation_server                            = utf8mb4_bin
transaction_isolation                       = READ-COMMITTED
lower_case_table_names                      = 1  
skip_name_resolve                           = 1
log_timestamps                              = SYSTEM
slow_query_log                              = 1
long_query_time                             = 3
log_queries_not_using_indexes               = 1
log_throttle_queries_not_using_indexes      = 60
log_slow_admin_statements                   = 1
log_slow_slave_statements                   = 1
table_open_cache_instances                  = 64
external-locking                            = FALSE
explicit_defaults_for_timestamp             = 1
skip_external_locking                       = 1
default_authentication_plugin               = mysql_native_password
local_infile                                = 1

## GTID
gtid_mode                                   = on
enforce_gtid_consistency                    = 1
master_info_repository                      = TABLE
relay_log_info_repository                   = TABLE

# replication
#read_only                                  = 1 #从库必须开启
skip_slave_start                            = 0 #如果作为中级节点必须开启否则不用开启
slave-skip-errors                           = 1032 #跳过1032错误
log_slave_updates                           = 1
slave-rows-search-algorithms                = 'INDEX_SCAN,HASH_SCAN'

## relay log
#slave_parallel_workers                     = 8  # 并行的复制，多个数据库就要开启并行
max-relay-log-size                          = 256M    
relay_log_purge                             = 1
relay_log_recovery                          = 1

## binary logging
binlog_format                               = row
sync_binlog                                 = 1
binlog_rows_query_log_events                = 1
log_bin_trust_function_creators             = 1
binlog_error_action                         = ABORT_SERVER

## myisam
key_buffer_size                             = 16M  
myisam_sort_buffer_size                     = 128M
myisam_repair_threads                       = 1

## buffers & cache
table_open_cache                            = 4000
table_definition_cache                      = 4000
max_heap_table_size                         = 64M
tmp_table_size                              = 64M
sort_buffer_size                            = 4M
join_buffer_size                            = 4M
thread_cache_size                           = 200
thread_stack                                = 512K
read_buffer_size                            = 8M
read_rnd_buffer_size                        = 8M
bulk_insert_buffer_size                     = 16M
max_allowed_packet                          = 2G

## connect
max_connections                             = 3000
max_user_connections                        = 3000  
max_connect_errors                          = 1000000
open_files_limit                            = 65535  
back_log                                    = 500  

## timeout
wait_timeout                                = 28800
lock_wait_timeout                           = 28800
innodb_lock_wait_timeout                    = 50
interactive_timeout                         = 28800
connect_timeout                             = 20
slave-net-timeout                           = 60

## innodb
innodb_adaptive_flushing                    = 1  
innodb_adaptive_hash_index                  = ON  
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_data_file_path                       = ibdata1:1G:autoextend
innodb_temp_data_file_path                  = ibtmp1:12M:autoextend:max:20G
innodb_flush_log_at_trx_commit              = 1
innodb_log_buffer_size                      = 64M
innodb_sort_buffer_size                     = 8M
innodb_log_file_size                        = 1G
innodb_log_files_in_group                   = 2
innodb_thread_concurrency                   = 0
innodb_io_capacity                          = 3000
innodb_io_capacity_max                      = 6000
innodb_flush_neighbors                      = 0
innodb_write_io_threads                     = 8
innodb_read_io_threads                      = 8
innodb_purge_threads                        = 4
innodb_page_cleaners                        = 4
innodb_open_files                           = 4096
innodb_max_dirty_pages_pct                  = 60
innodb_flush_method                         = O_DIRECT
innodb_lru_scan_depth                       = 2000
innodb_print_all_deadlocks                  = 1
innodb_file_per_table                       = 1
innodb_strict_mode                          = 1

## Other
innodb_numa_interleave                      = 1

[mysqldump]
quick
max_allowed_packet                          = 2G