mysql主从

[mysqld]
server-id=1
auto_increment_offset=1
auto_increment_increment=2
log-bin=mysql-bin
max_binlog_size=1024M
binlog_format = MIXED
replicate-ignore-db=mysql
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema

basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
socket=/var/lib/mysql/mysql.sock
character-set-server=utf8

[client]
default-character-set=utf8
socket=/var/lib/mysql/mysql.sock

[mysql]
default-character-set=utf8
socket=/var/lib/mysql/mysql.sock

 

posted @ 2022-06-09 15:34  所向披靡zz  阅读(20)  评论(0编辑  收藏  举报