影子库压测

定义

  1. CREATE SHADOW RULE shadowRuleDefinition [, shadowRuleDefinition] ... 
  3. ALTER SHADOW RULE shadowRuleDefinition [, shadowRuleDefinition] ... 
  5. ALTER SHADOW ALGORITHM shadowAlgorithm [, shadowAlgorithm] ...
  7. DROP SHADOW RULE ruleName [, ruleName] ...
  9. DROP SHADOW ALGORITHM algorithmName [, algorithmName] ...
  11. shadowRuleDefinition: ruleName(resourceMapping, shadowTableRule [, shadowTableRule] ...)
  13. resourceMapping: SOURCE=resourceName, SHADOW=resourceName
  15. shadowTableRule: tableName(shadowAlgorithm [, shadowAlgorithm] ...)
  17. shadowAlgorithm: ([algorithmName, ] TYPE(NAME=shadowAlgorithmType, PROPERTIES([algorithmProperties] ...)))
  19. algorithmProperties: algorithmProperty [, algorithmProperty] ... 
  21. algorithmProperty: key=value
  • 重复的ruleName无法被创建
  • resourceMapping 指定源数据库和影子库的映射关系，需使用 RDL 管理的 resource ，请参考 数据源资源
  • shadowAlgorithm 可同时作用于多个 shadowTableRule
  • algorithmName 未指定时会根据 ruleName、tableName 和 shadowAlgorithmType 自动生成
  • shadowAlgorithmType 目前支持 COLUMN_REGEX_MATCH 和 SIMPLE_NOTE
  • shadowTableRule 能够被不同的 shadowRuleDefinition 复用，因此在执行 DROP SHADOW RULE 时，对应的 shadowTableRule 不会被移除
  • shadowAlgorithm 能够被不同的 shadowTableRule 复用，因此在执行 ALTER SHADOW RULE 时，对应的 shadowAlgorithm 不会被移除

示例

  1. CREATE SHADOW RULE shadow_rule(
  2. SOURCE=demo_ds,
  3. SHADOW=demo_ds_shadow,
  4. t_order((simple_note_algorithm, TYPE(NAME=SIMPLE_NOTE, PROPERTIES("shadow"="true", foo="bar"))),(TYPE(NAME=COLUMN_REGEX_MATCH, PROPERTIES("operation"="insert","column"="user_id", "regex"='[1]')))), 
  5. t_order_item((TYPE(NAME=SIMPLE_NOTE, PROPERTIES("shadow"="true", "foo"="bar")))));
  7. ALTER SHADOW RULE shadow_rule(
  8. SOURCE=demo_ds,
  9. SHADOW=demo_ds_shadow,
  10. t_order((simple_note_algorithm, TYPE(NAME=SIMPLE_NOTE, PROPERTIES("shadow"="true", foo="bar"))),(TYPE(NAME=COLUMN_REGEX_MATCH, PROPERTIES("operation"="insert","column"="user_id", "regex"='[1]')))), 
  11. t_order_item((TYPE(NAME=SIMPLE_NOTE, PROPERTIES("shadow"="true", "foo"="bar")))));
  13. ALTER SHADOW ALGORITHM 
  14. (simple_note_algorithm, TYPE(NAME=SIMPLE_NOTE, PROPERTIES("shadow"="true", "foo"="bar"))), 
  15. (user_id_match_algorithm, TYPE(NAME=COLUMN_REGEX_MATCH,PROPERTIES("operation"="insert", "column"="user_id", "regex"='[1]')));
  17. DROP SHADOW RULE shadow_rule;
  19. DROP SHADOW ALGORITHM simple_note_algorithm;