[client]
port		= 3306
socket		= /data/my3306/run/mysqld.sock

[mysqld]
port		    = 3306
socket		    = /data/my3306/run/mysqld.sock
datadir		    = /data/my3306/data
basedir         = /app/mysql-5.7.28
pid_file	    = /data/my3306/run/mysqld.pid
bind_address        = 0.0.0.0

lower_case_table_names  = 1
collation_server        = utf8_bin
character_set_server	= utf8

ssl = 0
event_scheduler         = DISABLED
skip_name_resolve
skip_external_locking
explicit_defaults_for_timestamp

tmp_table_size  = 24M
tmpdir			= /data/my3306/tmp
back_log        = 1024

max_connections         = 8000
max_user_connections    = 80
max_connect_errors      = 2000

table_open_cache        = 20480
table_definition_cache  = 20480
table_open_cache_instances = 16
open_files_limit = 655340

binlog_cache_size           = 512K
bulk_insert_buffer_size     = 64M
ft_min_word_len             = 4
join_buffer_size            = 6M
key_buffer_size             = 32M
max_allowed_packet          = 1024M
max_heap_table_size         = 32M
myisam_max_sort_file_size   = 10G
myisam_repair_threads       = 1
myisam_sort_buffer_size     = 24M
query_cache_limit           = 2M
query_cache_size            = 64M
read_buffer_size            = 2M
read_rnd_buffer_size        = 3M
sort_buffer_size            = 4M
thread_cache_size           = 512
thread_stack                = 192K
sql_mode                    = NO_ENGINE_SUBSTITUTION

# log
general_log                 = off
general_log_file            = /data/my3306/log/general-log.log
log_error_verbosity         = 3
log_error   	            = /data/my3306/log/mysqld-err.log
log_timestamps              = SYSTEM
slow_query_log              = on
slow_query_log_file         = /data/my3306/log/mysqld-slow.log
long_query_time             = 0.1
log_slow_admin_statements = on
log_slow_slave_statements = on
binlog_rows_query_log_events = on
log_raw = on

# replication
read_only
super_read_only
log_slave_updates
skip_slave_start
slave_compressed_protocol = off
transaction_write_set_extraction = off
slave_parallel_type = logical_clock
slave_preserve_commit_order = off
binlog_checksum = CRC32
binlog_group_commit_sync_delay = 50
binlog_group_commit_sync_no_delay_count =100

binlog_format               = row
binlog_row_image            = full
expire_logs_days            = 10
gtid_mode                   = on
enforce_gtid_consistency    = on
gtid_executed_compression_period = 1000
log-bin                     = /data/my3306/binlog/mysql-bin
master_info_repository      = table
relay_log                   = /data/my3306/binlog/mysqld-relay-bin
relay_log_info_repository   = table
server-id                   = *****
slave_net_timeout           = 60
slave_checkpoint_group      = 512
slave_checkpoint_period     = 300
slave_load_tmpdir		    = /data/my3306/tmp
slave_parallel_workers      = 8
slave_pending_jobs_size_max = 1G
sync_binlog                 = 1

report_port		= 3306
report_host		= ****

default_storage_engine          = InnoDB
disabled_storage_engines        = "MyISAM,MEMORY"
# innodb
innodb_print_all_deadlocks
innodb_autoextend_increment     = 64
innodb_buffer_pool_dump_at_shutdown = on
innodb_buffer_pool_instances    = 32
innodb_buffer_pool_load_at_startup  = on
innodb_buffer_pool_size         = 128G
innodb_data_file_path           = ibdata1:64M:autoextend
innodb_data_home_dir            = /data/my3306/ibdata
innodb_fast_shutdown            = 1
innodb_file_per_table           = 1
innodb_flush_log_at_trx_commit  = 1
innodb_flush_method             = O_DIRECT
innodb_flush_neighbors          = 0
innodb_io_capacity              = 7500
innodb_io_capacity_max          = 10000
innodb_lock_wait_timeout        = 50
innodb_log_buffer_size          = 32M
innodb_log_file_size            = 1024M
innodb_log_files_in_group       = 4
innodb_log_group_home_dir       = /data/my3306/iblog
innodb_max_dirty_pages_pct      = 75
innodb_online_alter_log_max_size = 1342177280
innodb_open_files               = 64535
innodb_purge_threads            = 8
innodb_read_io_threads          = 16
innodb_sort_buffer_size         = 4M
innodb_thread_concurrency       = 60
innodb_undo_directory           = /data/my3306/iblog
innodb_undo_logs                = 128
innodb_undo_tablespaces         = 2
innodb_write_io_threads         = 16
innodb_file_format              = Barracuda
innodb_file_format_max          = Barracuda
transaction_isolation           = READ-COMMITTED

# plugin
plugin_load = rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so
# Semi_sync
rpl_semi_sync_master_enabled	            = 1
rpl_semi_sync_slave_enabled                 = 1
rpl_semi_sync_master_timeout	            = 1000
rpl_semi_sync_master_wait_point             = AFTER_SYNC
rpl_semi_sync_master_wait_no_slave          = off
rpl_semi_sync_master_wait_for_slave_count   = 1

# group replication
loose_group_replication_start_on_boot = off
loose_group_replication_enforce_update_everywhere_checks = false
loose_group_replication_bootstrap_group = off

# performance_schema
performance_schema = on
performance-schema-instrument = 'wait/lock/metadata/sql/mdl=ON'


[mysqldump]
quick
max_allowed_packet = 256M


[mysql]
no-auto-rehash
prompt=\\u@\\v \\d \\r:\\m:\\s>
default-character-set=utf8