MySQL配置文件

关于字符集

[mysqld]
default-storage-engine=INNODB
default-character-set=utf8
init_connect='SET NAMES utf8'

[mysql]
default-character-set=utf8

关于主从-主

[mysqld]
server-id = 1
skip-slave-start=1
log_bin = mysql-bin
log-slave-updates=1
relay-log = mysql-relay-bin
expire_logs_days = 3
replicate-ignore-db = mysql
max_binlog_size  = 100M
binlog_format='ROW'