ALTER SHADOW RULE
storageUnitMapping
specifies the mapping relationship between thesource
database and the shadow library. You need to use the storage unit managed by RDL, please refer to ;shadowAlgorithm
can act on multipleshadowTableRule
at the same time;- If
algorithmName
is not specified, it will be automatically generated according toruleName
,tableName
andshadowAlgorithmType
; - currently supports
VALUE_MATCH
,REGEX_MATCH
andSIMPLE_HINT
.
- Create a shadow rule
SOURCE=demo_su,
SHADOW=demo_su_shadow,
t_order(TYPE(NAME="SIMPLE_HINT", PROPERTIES("shadow"="true", "foo"="bar"))),
t_order_item(TYPE(NAME="VALUE_MATCH", PROPERTIES("operation"="insert","column"="user_id", "value"='1')))
ALTER
, SHADOW
, RULE
, SOURCE
, SHADOW
, TYPE
, NAME
, PROPERTIES