- 论坛徽章:
- 0
|
本帖最后由 big_turnip 于 2013-08-09 16:34 编辑
[root@test-206 ~]# pt-table-sync --replicate=test.checksum h=192.168.1.206,p=h123,u=root h=192.168.1.205,p=h123,u=root --print
DELETE FROM `abc`.`aaa` WHERE `id`='99' LIMIT 1 /*percona-toolkit src_db:abc src_tbl:aaa src_dsn:h=192.168.1.206,p=...,u=root dst_db:abc dst_tbl:aaa dst_dsn:h=192.168.1.205,p=...,u=root lock:1 transaction:1 changing_src:test.checksum replicate:test.checksum bidirectional:0 pid:1941 user:root host:test-206*/;
主192.168.1.206
从192.168.1.205- 192.168.1.206
- MySQL [abc]> select * from aaa;
- +------+
- | id |
- +------+
- | 1 |
- | 2 |
- | 3 |
- | 5 |
- | 100 |
- | 1111 |
- | 1222 |
- +------+
- 7 rows in set (0.00 sec)
- 192.168.1.205MySQL [abc]> select * from aaa;
- +------+
- | id |
- +------+
- | 1 |
- | 2 |
- | 3 |
- | 5 |
- | 99 |
- | 100 |
- | 1111 |
- | 1222 |
- +------+
- 8 rows in set (0.00 sec)
复制代码 执行完pt-table-sync 从数据库里abc.aaa表中id=99这一行依然存在
求解 |
|