Retro Eye care Haitian Deep Dark Default

SHOW READWRITE_SPLITTING RULE

Description

The SHOW READWRITE_SPLITTING RULE syntax is used to query specified readwrite splitting rules for specified database.

Syntax

ShowReadWriteSplittingRule::=
  'SHOW' 'READWRITE_SPLITTING' ('RULE' ruleName | 'RULES') ('FROM' databaseName)?

ruleName ::=
  identifier  

databaseName ::=
  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.

Return value description

Column Description
name Readwrite splitting rule name
auto_aware_data_source_name Auto-Aware discovery data source name (Display configuration dynamic readwrite splitting rules)
write_data_source_name Write data source name
read_data_source_names Read data source name list
load_balancer_type Load balance algorithm type
load_balancer_props Load balance algorithm parameter

Example

  • Query readwrite splitting rules for specified database.
SHOW READWRITE_SPLITTING RULES FROM readwrite_splitting_db;

mysql> SHOW READWRITE_SPLITTING RULES FROM readwrite_splitting_db;
+------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
| name       | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
+------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
| ms_group_0 |                             | resource_1             | ds_0,ds_1              | random             |                     |
+------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
1 row in set (0.01 sec)
  • Query readwrite splitting rules for current database.
SHOW READWRITE_SPLITTING RULES;

mysql> SHOW READWRITE_SPLITTING RULES;
+------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
| name       | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
+------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
| ms_group_0 |                             | resource_1             | ds_0,ds_1              | random             |                     |
+------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
1 row in set (0.01 sec)
  • Query specified readwrite splitting rule for specified database.
SHOW READWRITE_SPLITTING RULE ms_group_0 FROM readwrite_splitting_db;

mysql> SHOW READWRITE_SPLITTING RULE ms_group_0 FROM readwrite_splitting_db;
+------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
| name       | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
+------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
| ms_group_0 |                             | resource_1             | ds_0,ds_1              | random             |                     |
+------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
1 row in set (0.01 sec)
  • Query specified readwrite splitting rule for current database.
SHOW READWRITE_SPLITTING RULE ms_group_0;

mysql> SHOW READWRITE_SPLITTING RULE ms_group_0;
+------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
| name       | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
+------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
| ms_group_0 |                             | resource_1             | ds_0,ds_1              | random             |                     |
+------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
1 row in set (0.01 sec)

Reserved word

SHOW, READWRITE_SPLITTING, RULE, RULES, FROM