Readwrite-Splitting

Syntax

  1. SHOW READWRITE_SPLITTING RULES [FROM schemaName]

Return Value Description

ColumnDescription
nameRule name
auto_aware_data_source_nameAuto-Aware discovery data source name（Display configuration dynamic readwrite splitting rules）
write_data_source_nameWrite data source name
read_data_source_namesRead data source name list
load_balancer_typeLoad balance algorithm type
load_balancer_propsLoad balance algorithm parameter

Example

Static 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 | NULL                        | ds_primary             | ds_slave_0, ds_slave_1 | random             |                     |
  6. +------------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
  7. 1 row in set (0.00 sec)

Dynamic Readwrite Splitting Rules

  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. | pr_ds | ms_group_0                  | NULL                   |                        | random             | read_weight=2:1     |
  6. +-------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
  7. 1 row in set (0.01 sec)

Static Readwrite Splitting Rules And Dynamic Readwrite Splitting Rules

  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. | pr_ds | ms_group_0                  | write_ds               | read_ds_0, read_ds_1   | random             | read_weight=2:1     |
  6. +-------+-----------------------------+------------------------+------------------------+--------------------+---------------------+
  7. 1 row in set (0.00 sec)