[client] socket = /tmp/mysql.sock [mysqld] datadir=/data/mysql/data pid-file=/data/mysql/data/mysqld.pid socket=/tmp/mysql.sock port=3306 log-error=/log/mysql/mysqld.err user= mysql secure_file_priv=/data/mysql/mysql-files local_infile=OFF symbolic-links=0 log-bin = /log/mysql/mysql-bin expire-logs-days = 14 binlog_format = ROW innodb_file_per_table = 1 sync_binlog=1 innodb_flush_log_at_trx_commit=1 innodb_flush_method=O_DIRECT_NO_FSYNC innodb_max_dirty_pages_pct = 70 innodb_io_capacity=2000 innodb_write_io_threads=8 innodb_read_io_threads=8 innodb_purge_threads=4 innodb_page_cleaners=4 innodb_log_group_home_dir=/log/mysql innodb_log_files_in_group = 3 innodb_log_file_size = 3G innodb_buffer_pool_instances = 1 innodb_buffer_pool_size = 15G gtid_mode=ON enforce_gtid_consistency=ON server-id = 1115 # slave slave-parallel-type=LOGICAL_CLOCK slave-parallel-workers=8 master_info_repository=TABLE relay_log_info_repository=TABLE relay_log_recovery=ON log-slave-updates=1