ALTER READWRITE_SPLITTING RULE ENABLE/DISABLE

Description

The ALTER READWRITE_SPLITTING RULE ENABLE/DISABLE syntax is used enable/disable a specified read source for specified readwrite splitting rule.

Syntax

Grammar Railroad diagram

  1. AlterReadwriteSplittingRule ::=
  2.   'ALTER' 'READWRITE_SPLITTING' 'RULE' groupName ('ENABLE' | 'DISABLE') storageUnitName 'FROM' databaseName
  4. groupName ::=
  5.   identifier
  7. storageUnitName ::=
  8.   identifier
  10. databaseName ::=
  11.   identifier

Supplement

  • When databaseName is not specified, the default is the currently used DATABASE. If DATABASE is not used, No database selected will be prompted.

Example

  • Disable a specified read source for specified readwrite splitting rule in specified database
  1. ALTER READWRITE_SPLITTING RULE ms_group_0 DISABLE read_ds_0 FROM sharding_db;
  • Enable a specified read source for specified readwrite splitting rule in specified database
  1. ALTER READWRITE_SPLITTING RULE ms_group_0 ENABLE read_ds_0 FROM sharding_db;
  • Disable a specified read source for specified readwrite splitting rule in current database
  1. ALTER READWRITE_SPLITTING RULE ms_group_0 DISABLE read_ds_0;
  • Enable a specified read source for specified readwrite splitting rule in current database
  1. ALTER READWRITE_SPLITTING RULE ms_group_1 ENABLE read_ds_0;

Reserved word

ALTER, READWRITE_SPLITTING, RULE, ENABLE, DISABLE