Skip to content

Instantly share code, notes, and snippets.

@Linuxpizi
Last active March 31, 2020 07:13
Show Gist options
  • Save Linuxpizi/745b1acd427f72ebe1d6406f6cc98a0c to your computer and use it in GitHub Desktop.
Save Linuxpizi/745b1acd427f72ebe1d6406f6cc98a0c to your computer and use it in GitHub Desktop.
mysql主从设置忽略的数据库

master

[mysqld]
# binlog-do-db      二进制日志记录的数据库(多数据库用逗号,隔开)
# binlog-ignore-db  二进制日志中忽略数据库 (多数据库用逗号,隔开)
binlog-do-db     = testdb
binlog-ignore-db = mysql  #这是不记录binlog,来达到从库不同步mysql库,以确保各自权限
binlog-ignore-db = performance_schema
binlog-ignore-db = information_schema

slave

[mysqld]
# replicate-do-db    设定需要复制的数据库(多数据库使用逗号,隔开)
# replicate-ignore-db 设定需要忽略的复制数据库 (多数据库使用逗号,隔开)
# replicate-do-table  设定需要复制的表
# replicate-ignore-table 设定需要忽略的复制表 
# replicate-wild-do-table 同replication-do-table功能一样,但是可以通配符
# replicate-wild-ignore-table 同replication-ignore-table功能一样,但是可以加通配符

replicate-do-db = testdb
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment