问下大佬们
使用canal做同步
源表
+------+------+
| id | name |
+------+------+
| 1 | a1 |
| 1 | a1 |
目标表
+------+------+
| id | name |
+------+------+
| 1 | a1 |
| 1 | a1 |
| 1 | a2 |
我在源执行
delete from t1 where id=1;
FLUSH PRIVILEGES;
结果,目标表也清空了,如果保证目标表也只删2条记录呢?