这是相关的配置
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 7
max_binlog_size = 10G
binlog_do_db = db1,db2,db3,db4 ....
binlog_ignore_db = information_schema,mysql,dbA,dbB,dbC
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 7
max_binlog_size = 10G
binlog_do_db = db1,db2,db3,db4 ....
binlog_ignore_db = information_schema,mysql,dbA,dbB,dbC
解决方案 »
- MySql删除操作的触发器
- mysqldump在命令行里总是备份不到新数据
- 请教,关于procedure的传参数问题
- mysql4.026 怎样修改 max_connections 等等的配置参数
- 求一个mysql的sql语句最优写法
- 图像和声音怎么在数据库中存储?(每个小题20分)
- 快速导出大数据量表方法有哪些
- 为什么删除不了这一行!!
- 2张张表关联查询的问题,求大神解决
- MySql登录不了,ERROR 2026 (HY000): SSL connection error: socket layer receive error
- 职场方向,选择Oracle 还是MySQL,请大牛前辈指点!
- mysql-connector-c++ 执行execute之后连接会关闭
server-id = 1
log-bin=/usr/local/mysql/var/mysql-bin.000001
#binlog-do-db = zabbix
binlog-ignore-db = mysql
binlog-ignore-db = test
binlog-ignore-db = information_schema
mysql>grant replication slave on *.* to 'rep'@'%' identified by 'password'; #授权用户
mysql> show master status\G; #binlog-id,pos号码
File: mysql-bin.000011
Position: 490
2 slave 端
my.conf #编辑my.cnf
server-id = 2
mysql>change master to master_host='192.168.56.10',master_user='rep',master_password='password',master_log_file='mysql-bin.000011',master_log_pos=490;
mysql> start slave;
mysql> show slave status\G;
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
replicate-wild-do-table=dbname.%
replicate-wild-ignore-table=dbname.%
这样可以解决跨库更新时,不同步复制的问题。