Retro Eye care Haitian Deep Dark Default

SHOW READWRITE_SPLITTING RULES

Description

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

Syntax

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

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_query_enabled All read data source are offline, write data source whether the data source is responsible for read traffic
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 sharding_db;
mysql> SHOW READWRITE_SPLITTING RULES FROM sharding_db;
+------------+-----------------------------+---------------------------------+------------------------+------------------------+--------------------+---------------------+
| name       | auto_aware_data_source_name | write_data_source_query_enabled | 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_query_enabled | 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, RULES, FROM