读写分离

定义

  1. CREATE READWRITE_SPLITTING RULE readwriteSplittingRuleDefinition [, readwriteSplittingRuleDefinition] ...
  3. ALTER READWRITE_SPLITTING RULE readwriteSplittingRuleDefinition [, readwriteSplittingRuleDefinition] ...
  5. DROP READWRITE_SPLITTING RULE ruleName [, ruleName] ...
  7. readwriteSplittingRuleDefinition:
  8.     ruleName ([staticReadwriteSplittingRuleDefinition | dynamicReadwriteSplittingRuleDefinition] 
  9.               [, loadBanlancerDefinition])
  11. staticReadwriteSplittingRuleDefinition:
  12.     WRITE_RESOURCE=writeResourceName, READ_RESOURCES(resourceName [, resourceName] ... )
  14. dynamicReadwriteSplittingRuleDefinition:
  15.     AUTO_AWARE_RESOURCE=resourceName
  17. loadBanlancerDefinition:
  18.     TYPE(NAME=loadBanlancerType [, PROPERTIES([algorithmProperties] )] )
  20. algorithmProperties:
  21.     algorithmProperty [, algorithmProperty] ...
  23. algorithmProperty:
  24.     key=value
  • 支持创建静态读写分离规则和动态读写分离规则
  • 动态读写分离规则依赖于数据库发现规则
  • loadBanlancerType 指定负载均衡算法类型，请参考 负载均衡算法
  • 重复的 ruleName 将无法被创建

示例

  1. // Static
  2. CREATE READWRITE_SPLITTING RULE ms_group_0 (
  3. WRITE_RESOURCE=write_ds,
  4. READ_RESOURCES(read_ds_0,read_ds_1),
  5. TYPE(NAME=random)
  6. );
  8. // Dynamic
  9. CREATE READWRITE_SPLITTING RULE ms_group_1 (
  10. AUTO_AWARE_RESOURCE=group_0,
  11. TYPE(NAME=random,PROPERTIES(read_weight='2:1'))
  12. );
  14. ALTER READWRITE_SPLITTING RULE ms_group_1 (
  15. WRITE_RESOURCE=write_ds,
  16. READ_RESOURCES(read_ds_0,read_ds_1,read_ds_2),
  17. TYPE(NAME=random,PROPERTIES(read_weight='2:0'))
  18. );
  20. DROP READWRITE_SPLITTING RULE ms_group_1;