根据表名表达式匹配来过滤相应的DML操作 #4537
Open
根据表名表达式匹配来过滤相应的DML操作 #4537
Conversation
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Conflicts: # deployer/src/main/resources/canal.properties # parse/src/main/java/com/alibaba/otter/canal/parse/inbound/mysql/MysqlMultiStageCoprocessor.java
|
改动需要考虑兼容性，继续保留canal.instance.filter.dml.insert/update/delete的相关参数，如果有设置regex则优先级更高 做一下老版本参数兼容后，可以考虑合并MR |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
2 participants
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
实际数据同步过程中只需要对部分表按照dml操作过滤，其它的表不需要过滤。去除了以下配置来对dml操作进行一刀切方式的过滤。
canal.instance.filter.dml.insert = false
canal.instance.filter.dml.update = false
canal.instance.filter.dml.delete = false
新增以下配置来进行表名匹配的方式进行DML操作过滤：
table regex for insert-dml
canal.instance.filter.dml.insert.regex =
table regex for update-dml
canal.instance.filter.dml.update.regex =
table regex for delete-dml
canal.instance.filter.dml.delete.regex =