SHOW TRAFFIC RULE

描述

SHOW TRAFFIC RULE 语法用于查询指定的双路由规则

语法

语法 铁路图

  1. ShowTrafficRule ::=
  2.   'SHOW' 'TRAFFIC' ('RULES' | 'RULE' ruleName)?
  4. ruleName ::=
  5.   identifier

补充说明

  • 未指定 ruleName 时，默认查询所有双路由规则

返回值说明

列说明
name双路由规则名称
labels计算节点标签
algorithm_type双路由算法类型
algorithm_props双路由算法参数
load_balancer_type负载均衡器类型
load_balancer_props负载均衡器参数

示例

  • 查询指定双路由规则
  1. SHOW TRAFFIC RULE sql_match_traffic;
  1. mysql> SHOW TRAFFIC RULE sql_match_traffic;
  2. +-------------------+--------+----------------+--------------------------------------------------------------------------------+--------------------+---------------------+
  3. | name              | labels | algorithm_type | algorithm_props                                                                | load_balancer_type | load_balancer_props |
  4. +-------------------+--------+----------------+--------------------------------------------------------------------------------+--------------------+---------------------+
  5. | sql_match_traffic | OLTP   | SQL_MATCH      | sql=SELECT * FROM t_order WHERE order_id = 1; UPDATE t_order SET order_id = 5; | RANDOM             |                     |
  6. +-------------------+--------+----------------+--------------------------------------------------------------------------------+--------------------+---------------------+
  7. 1 row in set (0.00 sec)
  • 查询所有双路由规则
  1. SHOW TRAFFIC RULES;
  1. mysql> SHOW TRAFFIC RULES;
  2. +-------------------+--------+----------------+--------------------------------------------------------------------------------+--------------------+---------------------+
  3. | name              | labels | algorithm_type | algorithm_props                                                                | load_balancer_type | load_balancer_props |
  4. +-------------------+--------+----------------+--------------------------------------------------------------------------------+--------------------+---------------------+
  5. | sql_match_traffic | OLTP   | SQL_MATCH      | sql=SELECT * FROM t_order WHERE order_id = 1; UPDATE t_order SET order_id = 5; | RANDOM             |                     |
  6. +-------------------+--------+----------------+--------------------------------------------------------------------------------+--------------------+---------------------+
  7. 1 row in set (0.04 sec)

保留字

SHOW、TRAFFIC、RULE、RULES

相关链接