my.cnf

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[mysql]
default-character-set=utf8


[client]
default-character-set=utf8

[mysqld]
# lower_case_table_names=1

log_error=/var/log/mysql/mysql_error.log

max_connections=1000
character-set-server=utf8
default-storage-engine=INNODB

server-id=1

log-bin=mysql-bin
relay-log=mysql-relay

expire_logs_days=5
log-slave-updates=true

binlog_ignore_db=mysql
binlog_ignore_db=information_schema
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION