SHOW READWRITE_SPLITTING RULE

描述

SHOW READWRITE_SPLITTING RULE 语法用于查询指定逻辑库中的指定读写分离规则。

语法

语法 铁路图

  1. ShowReadWriteSplittingRule::=
  2.   'SHOW' 'READWRITE_SPLITTING' ('RULE' ruleName | 'RULES') ('FROM' databaseName)?
  4. ruleName ::=
  5.   identifier  
  7. databaseName ::=
  8.   identifier

补充说明

  • 未指定 databaseName 时，默认是当前使用的 DATABASE。 如果也未使用 DATABASE 则会提示 No database selected。

返回值说明

列说明
name读写分离规则名称
auto_aware_data_source_name自动发现数据源名称（配置动态读写分离规则显示）
write_data_source_name写数据源名称
read_data_source_names读数据源名称列表
load_balancer_type负载均衡算法类型
load_balancer_props负载均衡算法参数

示例

  • 查询指定逻辑库中的读写分离规则
  1. SHOW READWRITE_SPLITTING RULES FROM readwrite_splitting_db;
  1. mysql> SHOW READWRITE_SPLITTING RULES FROM readwrite_splitting_db;
  2. +------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
  3. | name       | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
  4. +------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
  5. | ms_group_0 |                             | resource_1             | ds_0,ds_1              | random             |                     |
  6. +------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
  7. 1 row in set (0.01 sec)
  • 查询当前逻辑库中的读写分离规则
  1. SHOW READWRITE_SPLITTING RULES;
  1. mysql> SHOW READWRITE_SPLITTING RULES;
  2. +------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
  3. | name       | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
  4. +------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
  5. | ms_group_0 |                             | resource_1             | ds_0,ds_1              | random             |                     |
  6. +------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
  7. 1 row in set (0.01 sec)
  • 查询指定逻辑库中的指定读写分离规则
  1. SHOW READWRITE_SPLITTING RULE ms_group_0 FROM readwrite_splitting_db;
  1. mysql> SHOW READWRITE_SPLITTING RULE ms_group_0 FROM readwrite_splitting_db;
  2. +------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
  3. | name       | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
  4. +------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
  5. | ms_group_0 |                             | resource_1             | ds_0,ds_1              | random             |                     |
  6. +------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
  7. 1 row in set (0.01 sec)
  • 查询当前逻辑库中的指定读写分离规则
  1. SHOW READWRITE_SPLITTING RULE ms_group_0;
  1. mysql> SHOW READWRITE_SPLITTING RULE ms_group_0;
  2. +------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
  3. | name       | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
  4. +------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
  5. | ms_group_0 |                             | resource_1             | ds_0,ds_1              | random             |                     |
  6. +------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
  7. 1 row in set (0.01 sec)

保留字

SHOW、READWRITE_SPLITTING、RULE、RULES、FROM

相关链接