Readwrite-Splitting

Syntax

  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.               [, loadBalancerDefinition])
  11. staticReadwriteSplittingRuleDefinition:
  12.     WRITE_RESOURCE=writeResourceName, READ_RESOURCES(resourceName [, resourceName] ... )
  14. dynamicReadwriteSplittingRuleDefinition:
  15.     AUTO_AWARE_RESOURCE=resourceName [, WRITE_DATA_SOURCE_QUERY_ENABLED=writeDataSourceQueryEnabled]
  17. loadBalancerDefinition:
  18.     TYPE(NAME=loadBalancerType [, PROPERTIES([algorithmProperties] )] )
  20. algorithmProperties:
  21.     algorithmProperty [, algorithmProperty] ...
  23. algorithmProperty:
  24.     key=value
  26. writeDataSourceQueryEnabled:
  27.     TRUE | FALSE

Parameters Explained

nameDateTypeDescription
ruleNameIDENTIFIERRule name
writeResourceNameIDENTIFIERWrite data source name
readResourceNameIDENTIFIERRead data source name
autoAwareResourceNameIDENTIFIERDatabase discovery logic data source name
writeDataSourceQueryEnabledBOOLEANAll read data source are offline, write data source whether the data source is responsible for read traffic
loadBalancerTypeSTRINGLoad balancing algorithm type

Notes

  • Support the creation of static readwrite-splitting rules and dynamic readwrite-splitting rules
  • Dynamic readwrite-splitting rules rely on database discovery rules
  • loadBalancerType specifies the load balancing algorithm type, please refer to Load Balance Algorithm
  • Duplicate ruleName will not be created

Example

  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. WRITE_DATA_SOURCE_QUERY_ENABLED=false,
  12. TYPE(NAME="random",PROPERTIES(write_ds=2,read_ds_0=2,read_ds_1=2,read_ds_2=1))
  13. );
  15. ALTER READWRITE_SPLITTING RULE ms_group_1 (
  16. WRITE_RESOURCE=write_ds,
  17. READ_RESOURCES(read_ds_0,read_ds_1,read_ds_2),
  18. TYPE(NAME="random",PROPERTIES(write_ds=2,read_ds_0=2,read_ds_1=2,read_ds_2=1))
  19. );
  21. DROP READWRITE_SPLITTING RULE ms_group_1;