读写分离

定义

  1. SHOW READWRITE_SPLITTING RULES [FROM schemaName]

说明

列说明
name规则名称
autoAwareDataSourceName自动发现数据源名称（配置动态读写分离规则显示）
writeDataSourceName写数据源名称
readDataSourceNames读数据源名称列表
loadBalancerType负载均衡算法类型
loadBalancerProps负载均衡算法参数

示例

静态读写分离规则

  1. mysql> show readwrite_splitting rules;
  2. +------------+-------------------------+---------------------+--------------------------+------------------+------------------------+
  3. | name       | autoAwareDataSourceName | writeDataSourceName | readDataSourceNames      | loadBalancerType | loadBalancerProps      |
  4. +------------+-------------------------+---------------------+--------------------------+------------------+------------------------+
  5. | ms_group_0 | NULL                    | ds_primary          |  ds_slave_0, ds_slave_1  | random           |                        |
  6. +------------+-------------------------+---------------------+--------------------------+------------------+------------------------+
  7. 1 row in set (0.00 sec)

动态读写分离规则

  1. mysql> show readwrite_splitting rules from readwrite_splitting_db;
  2. +-------+-------------------------+---------------------+---------------------+------------------+------------------------+
  3. | name  | autoAwareDataSourceName | writeDataSourceName | readDataSourceNames | loadBalancerType | loadBalancerProps      |
  4. +-------+-------------------------+---------------------+---------------------+------------------+------------------------+
  5. | pr_ds | ms_group_0              | NULL                |                     | random           |  read_weight=2:1}      |
  6. +-------+-------------------------+---------------------+---------------------+------------------+------------------------+
  7. 1 row in set (0.01 sec)

静态读写分离规则和动态读写分离规则

  1. mysql> show readwrite_splitting rules from readwrite_splitting_db;
  2. +-------+-------------------------+---------------------+------------------------+------------------+------------------------+
  3. | name  | autoAwareDataSourceName | writeDataSourceName | readDataSourceNames    | loadBalancerType | loadBalancerProps      |
  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)