SHOW READWRITE_SPLITTING RULE 语法用于查询指定逻辑库中的指定读写分离规则。
ShowReadWriteSplittingRule::=
'SHOW' 'READWRITE_SPLITTING' ('RULE' ruleName | 'RULES') ('FROM' databaseName)?
ruleName ::=
identifier
databaseName ::=
identifier
databaseName 时，默认是当前使用的 DATABASE。 如果也未使用 DATABASE 则会提示 No database selected。| 列 | 说明 |
|---|---|
| name | 读写分离规则名称 |
| write_data_source_name | 写数据源名称 |
| read_data_source_names | 读数据源名称列表 |
| transactional_read_query_strategy | 事务内读请求路由策略 |
| load_balancer_type | 负载均衡算法类型 |
| load_balancer_props | 负载均衡算法参数 |
SHOW READWRITE_SPLITTING RULES FROM readwrite_splitting_db;
mysql> SHOW READWRITE_SPLITTING RULES FROM readwrite_splitting_db;
+------------+-------------------------+-------------------------+-----------------------------------+--------------------+---------------------+
| name | write_storage_unit_name | read_storage_unit_names | transactional_read_query_strategy | load_balancer_type | load_balancer_props |
+------------+-------------------------+-------------------------+-----------------------------------+--------------------+---------------------+
| ms_group_0 | write_ds | read_ds_0,read_ds_1 | DYNAMIC | random | |
+------------+-------------------------+-------------------------+-----------------------------------+--------------------+---------------------+
1 row in set (0.01 sec)
SHOW READWRITE_SPLITTING RULES;
mysql> SHOW READWRITE_SPLITTING RULES;
+------------+-------------------------+-------------------------+-----------------------------------+--------------------+---------------------+
| name | write_storage_unit_name | read_storage_unit_names | transactional_read_query_strategy | load_balancer_type | load_balancer_props |
+------------+-------------------------+-------------------------+-----------------------------------+--------------------+---------------------+
| ms_group_0 | write_ds | read_ds_0,read_ds_1 | DYNAMIC | random | |
+------------+-------------------------+-------------------------+-----------------------------------+--------------------+---------------------+
1 row in set (0.01 sec)
SHOW READWRITE_SPLITTING RULE ms_group_0 FROM readwrite_splitting_db;
mysql> SHOW READWRITE_SPLITTING RULE ms_group_0 FROM readwrite_splitting_db;
+------------+-------------------------+-------------------------+-----------------------------------+--------------------+---------------------+
| name | write_storage_unit_name | read_storage_unit_names | transactional_read_query_strategy | load_balancer_type | load_balancer_props |
+------------+-------------------------+-------------------------+-----------------------------------+--------------------+---------------------+
| ms_group_0 | write_ds | read_ds_0,read_ds_1 | DYNAMIC | random | |
+------------+-------------------------+-------------------------+-----------------------------------+--------------------+---------------------+
1 row in set (0.01 sec)
SHOW READWRITE_SPLITTING RULE ms_group_0;
mysql> SHOW READWRITE_SPLITTING RULE ms_group_0;
+------------+-------------------------+-------------------------+-----------------------------------+--------------------+---------------------+
| name | write_storage_unit_name | read_storage_unit_names | transactional_read_query_strategy | load_balancer_type | load_balancer_props |
+------------+-------------------------+-------------------------+-----------------------------------+--------------------+---------------------+
| ms_group_0 | write_ds | read_ds_0,read_ds_1 | DYNAMIC | random | |
+------------+-------------------------+-------------------------+-----------------------------------+--------------------+---------------------+
1 row in set (0.01 sec)
SHOW、READWRITE_SPLITTING、RULE、RULES、FROM