实战同步:
Master 122.49.40.147
1.编辑my.cnf
server-id=1
log-bin = /var/lib/mysql/mysql-bin-log
binlog-do-db = pdns
binlog-ignore-db = vmail
binlog-ignore-db = amavisd
2.在masters机上为slave机添加一同步账号
grant all on pdns.* to padmin@'122.49.40.161' identified by '123456';
3.重启mysql服务
4.show master status;
+----------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+----------------------+----------+--------------+------------------+
| mysql-bin-log.005336 | 1711 | pdns | vmail,amavisd |
+----------------------+----------+--------------+------------------+
1 row in set (0.00 sec)
Slave 122.49.40.161
1.编辑my.cnf
server-id=3
log-bin =/var/lib/mysql/mysql-bin-log
binlog-do-db = pdns //需要同步的数据库,如果没有本行,即表示同步所有数据库
binlog-ignore-db = vmail //被忽略的数据库
binlog-ignore-db = amavisd
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余2页未读,立即下载