kaiser_cn 发表于 2018-10-7 07:27:23

mysql5.7主从复制遇到的坑

  datadir=/var/lib/mysql
  socket=/var/lib/mysql/mysql.sock
  replicate-do-db=shopping
  binlog-do-db=shopping   #复制的库
  server-id = 3
  #skip-grant-tables = 1
  symbolic-links=0
  replicate-do-db=shop#需要复制的库
  binlog-do-db=shop
  tmpdir      = /tmp#这个最好给个目录 否则会报错 ,今天遇到了
  log-error=/var/log/mysqld.log
  pid-file=/var/run/mysqld/mysqld.pid
  max_connections = 1000
  binlog-ignore-db=mysql
  binlog-ignore-db=test
  binlog-ignore-db=information_schema
  binlog-ignore-db=performance_schema #不复制的库
  replicate-ignore-db=test
  replicate-ignore-db=mysql
  replicate-ignore-db=information_schema
  replicate-ignore-db=performance_schema#不复制的库
  validate_password=off#禁用密码策略,否则会很麻烦

页: [1]
查看完整版本: mysql5.7主从复制遇到的坑