ALTER READWRITE_SPLITTING RULE ENABLE/DISABLE
语法用于启用/禁用指定逻辑库中指定读写分离规则中的指定读数据存储单元。
AlterReadwriteSplittingRule ::=
'ALTER' 'READWRITE_SPLITTING' 'RULE' groupName ('ENABLE' | 'DISABLE') storageUnitName 'FROM' databaseName
groupName ::=
identifier
storageUnitName ::=
identifier
databaseName ::=
identifier
databaseName
时,默认是当前使用的 DATABASE
。 如果也未使用 DATABASE
则会提示 No database selected
。ALTER READWRITE_SPLITTING RULE ms_group_0 DISABLE read_ds_0 FROM sharding_db;
ALTER READWRITE_SPLITTING RULE ms_group_0 ENABLE read_ds_0 FROM sharding_db;
ALTER READWRITE_SPLITTING RULE ms_group_0 DISABLE read_ds_0;
ALTER READWRITE_SPLITTING RULE ms_group_1 ENABLE read_ds_0;
ALTER
、READWRITE_SPLITTING
、RULE
、ENABLE
、DISABLE