[mysqld]
datadir=/var/lib/mysql
user=mysql
port=3306
server_id=2
socket=/var/lib/mysql/mysql.sock
lower_case_table_names=1
max_connections=1000
max_connect_errors=100000
event_scheduler=1
# slave 复制不随着mysql服务的启动而开始复制,必须配置这个选项,否则重启mysql服务后,数据会产生不一致
skip-name-resolve
character_set_server=utf8
character_set_client=utf8
skip_slave_start
collation-server=utf8_general_ci
log_bin_trust_function_creators=1
log-bin
binlog_format=mixed
log_output=file
auto-increment-increment=2
auto-increment-offset=2
expire_logs_days=7
max_binlog_size=209715200
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[client]
linux mysql 双主复制配置文件my.cnf
最新推荐文章于 2023-03-13 14:23:59 发布