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