mysql复制结构基本配置

mysql配置

[mysqld]
character_set_server=utf8
init_connect='SET NAMEs utf8'
#character-set-server=utf8mb4
character-set-client-handshake=FALSE
collation-server=utf8mb4_general_ci
#init_connect='SET NAMES utf8mb4'

user=mysql
port=3306

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
pid_file=/var/lib/mysql/mysql.pid
log_error=/var/lib/mysql/mysql-err.log

log_bin=first-bin
log_bin_index=first-bin.index
binlog_format=mixed
max_binlog_size=100M
server_id=1
expire_logs_days=30
log_slave_updates=1
slave_skip_errors=all
auto_increment_increment=2
auto_increment_offset=1
log_bin_trust_function_creators=1

#启用半同步复制
rpl_semi_sync_master_enabled = 1
rpl_semi_sync_slave_enabled = 1

relay_log=first-relay-bin
relay_log_index=first-relay-bin.index

innodb_buffer_pool_size=6G
innodb_flush_log_at_trx_commit=2

max_connections=1024
max_allowed_packet=10M
skip_name_resolve=ON
sql_buffer_result=ON
query_cache_size=64M