[client]
port = 3306
socket = /tmp/mysql.sock
default-character-set = UTF8

[mysqld]
user = mysql
port = 3306
bind-address = 0.0.0.0
character-set-server = UTF8
collation-server = utf8_general_ci
datadir = /data/mysql/db
socket = /tmp/mysql.sock
pid-file = /var/run/mysqld/mysqld.pid
skip-name-resolve
sql_mode = NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
symbolic-links = 0

default-authentication-plugin = mysql_native_password

max_allowed_packet=1073741824
# Logging configuration.
log_error = /data/mysql/log/error.log
# Slow query log configuration.
slow_query_log = 1
slow_query_log_file = /data/mysql/log/mysql-slow.log
long_query_time = 2
log_timestamps = system
log_bin_trust_function_creators = True

server_id = 2

log_bin = /data/mysql/db/mysql-bin
binlog_format = ROW
expire_logs_days = 1
max_binlog_size = 256M
max_relay_log_size =512M
sync_binlog = 0


init-connect = 'SET NAMES utf8'
character-set-server = utf8

default-time-zone = '+08:00'
log-bin-trust-function-creators = true
sysdate-is-now = 1
auto-increment-increment = 1

explicit_defaults_for_timestamp = true

max_connections        = 2000
max_connect_errors     = 1000
table_open_cache       = 512

lower_case_table_names = 0

skip-external-locking

default_storage_engine            = InnoDB
default_tmp_storage_engine        = InnoDB
internal_tmp_disk_storage_engine  = InnoDB
innodb_file_per_table             = ON
innodb_buffer_pool_size           = 8G
innodb_thread_concurrency         = 0
innodb_flush_log_at_trx_commit    = 2
innodb_log_files_in_group         = 2
innodb_flush_method               = O_DIRECT

interactive_timeout = 28800
wait_timeout        = 28800

# Muti-Thread slave
#slave_parallel_type                         = LOGICAL_CLOCK
#slave_parallel_workers                      = 8
#relay_log_recovery                          = ON
#master_info_repository                      = TABLE
#relay_log_info_repository                   = TABLE
#
gtid_mode                = ON
enforce_gtid_consistency = ON
master_verify_checksum   = ON
sync_master_info         = 1

#rpl_semi_sync_master_enabled                = ON
#plugin-load-add                             = rpl_semi_sync_master=semisync_master.so
#plugin-load-add                             = rpl_semi_sync_slave=semisync_slave.so
#rpl_semi_sync_master_timeout                = 1000
#rpl_semi_sync_master_trace_level            = 32
#rpl_semi_sync_master_wait_for_slave_count   = 1
#rpl_semi_sync_master_wait_no_slave          = ON
#rpl_semi_sync_master_wait_point             = AFTER_SYNC
#rpl_semi_sync_slave_enabled                 = ON
#rpl_semi_sync_slave_trace_level             = 32