my.cnf主从推荐配置

主机my.cnf推荐配置

[client]

#password       = your_password

port            = 3306

socket          = /tmp/mysql.sock

 

[mysqld]

port            = 3306

socket          = /tmp/mysql.sock

max_connections=1024

event_scheduler=ON

skip-name-resolve

default-storage-engine=INNODB

max_allowed_packet=256M

group_concat_max_len=200000

innodb_log_file_size=1024M

innodb_log_buffer_size=8M

 

# [必须]默认是1，一般取IP最后一段

server-id=110

#[必须]启用二进制日志

log-bin=mysql-bin

 

#不对mysql库进行日志记录操作 如下意思雷同

binlog-ignore-db=mysql
binlog-ignore-db=test
binlog-ignore-db=information_schema
binlog-ignore-db=performance_schema

#不对test进行复制操作 如下意思雷同
replicate-ignore-db=test
replicate-ignore-db=mysql
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema

 

从机my.cnf推荐配置

[client]

#password       = your_password

port            = 3306

socket          = /tmp/mysql.sock

 

[mysqld]

port            = 3306

socket          = /tmp/mysql.sock

max_connections=1024

event_scheduler=ON

skip-name-resolve

default-storage-engine=INNODB

max_allowed_packet=256M

group_concat_max_len=200000

innodb_log_file_size=1024M

innodb_log_buffer_size=8M

 

# [必须]默认是1，一般取IP最后一段

server-id=90

#手动启动从服务比较安全，可避免突然宕机导致的数据日志不同步

skip-slave-start

 

#[不是必须]启用二进制日志

log-bin=mysql-bin

#不对mysql库进行日志记录操作 如下意思雷同

binlog-ignore-db=mysql
binlog-ignore-db=test
binlog-ignore-db=information_schema
binlog-ignore-db=performance_schema

#不对test进行复制操作 如下意思雷同
replicate-ignore-db=test
replicate-ignore-db=mysql
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema