[mysqld]
user = mysql
port = 3306
socket = /home/mysql/data/mysqld.sock
pid_file = /home/mysql/data/mysqld.pid
basedir = /usr
datadir = /home/mysql/data
tmpdir = /home/mysql/tmp
server_id = 11
bind_address = 0.0.0.0
report_host = 192.168.1.1
report_port = 3306
myisam_recover_options = FORCE,BACKUP

secure_file_priv = /home/mysql/tmp
default_password_lifetime = 0

character_set_client_handshake = FALSE
character_set_server = utf8mb4
collation_server = utf8mb4_general_ci
character_set_filesystem = utf8mb4

############### basic ###############
skip_name_resolve = 1
transaction_isolation = READ-COMMITTED
#read_only = ON
innodb_flush_log_at_trx_commit = 1
sync_binlog = 1
log_timestamps = system
query_cache_size = 0
host_cache_size = 0
explicit_defaults_for_timestamp = True
local_infile = OFF

############### per_thread_buffers ###############
max_connections = 50000
max_allowed_packet = 16777216
slave_pending_jobs_size_max = 16777216
max_connect_errors = 1000
sort_buffer_size = 2097152

############### error log ###############
log_error = /home/mysql/log/error.log

############### slow log ###############
slow_query_log_file = /home/mysql/log/slowlog/slow.log
long_query_time = 0.1
min_examined_row_limit = 100
slow_query_log = ON
log_queries_not_using_indexes = OFF

log_slow_admin_statements = ON
log_slow_slave_statements = ON
log_throttle_queries_not_using_indexes = 10

############### bin log ###############
log_bin = /home/mysql/log/binlog/binlog
binlog_format = row
expire_logs_days = 3

binlog_rows_query_log_events = False
binlog_gtid_simple_recovery = True
binlog_cache_size = 134217728

############### relay log ###############
relay_log = /home/mysql/log/relaylog/relaylog

############### innodb ###############
innodb_buffer_pool_size = 2147483648
innodb_io_capacity = 2000
#innodb_io_capacity_max = 5000
innodb_log_file_size = 2147483648
innodb_log_files_in_group = 4
innodb_data_file_path = ibdata1:512M:autoextend
innodb_flush_method = O_DIRECT
innodb_log_buffer_size = 16777216
innodb_lock_wait_timeout = 5
innodb_print_all_deadlocks = ON
innodb_thread_concurrency = 64

innodb_max_undo_log_size = 2147483648
innodb_buffer_pool_dump_pct = 40
innodb_undo_log_truncate = ON

innodb_undo_directory = /home/mysql/data
innodb_undo_tablespaces = 3
innodb_sort_buffer_size = 67108864
innodb_doublewrite = OFF
############### replication ###############
relay_log_recovery = True
log_slave_updates = True

slave_parallel_type = LOGICAL_CLOCK
slave_parallel_workers = 4

master_info_repository = TABLE
relay_log_info_repository = TABLE
gtid_mode = on
enforce_gtid_consistency = ON

######## semi_sync replication ########
plugin_load = "rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so"
#master
rpl_semi_sync_master_enabled = ON
rpl_semi_sync_master_wait_no_slave = 1
rpl_semi_sync_master_timeout = 1000

#slave
rpl_semi_sync_slave_enabled = ON

############# New variables added by script  #############
innodb_numa_interleave = ON
table_open_cache = 6000
performance_schema_max_file_handles = 655350
#performance_schema = OFF