ALTER TRAFFIC RULE

Description

The ALTER TRAFFIC RULE syntax is used to alter dual routing rule.

Syntax

Grammar Railroad diagram

  1. AlterTrafficRule ::=
  2.   'ALTER' 'TRAFFIC' 'RULE'  '(' 'LABELS' '(' lableName ')' ',' trafficAlgorithmDefinition ',' loadBalancerDefinition ')'
  4. lableName ::=
  5.   identifier
  7. trafficAlgorithmDefinition ::=
  8.   'TRAFFIC_ALGORITHM' '(' 'TYPE' '(' 'NAME' '=' trafficAlgorithmTypeName (',' propertiesDefinition)? ')' ')'
  10. loadBalancerDefinition ::=
  11.   'LOAD_BALANCER' '(' 'TYPE' '(' 'NAME' '=' loadBalancerName (',' propertiesDefinition)? ')' ')'
  13. propertiesDefinition ::=
  14.   'PROPERTIES' '(' key '=' value (',' key '=' value)* ')'
  16. trafficAlgorithmTypeName ::=
  17.   string
  19. loadBalancerTypeName ::=
  20.   string
  22. key ::= 
  23.   string
  25. value ::=
  26.   literal

Supplement

  • TRAFFIC_ALGORITHM support SQL_MATCH and SQL_HINT two types;

  • LOAD_BALANCER support RANDOM and ROUND_ROBIN two types.

Example

  • Alter dual routing rule
  1.  TRAFFIC RULE sql_match_traffic ( 
  2.   LABELS (OLTP),
  3.   TRAFFIC_ALGORITHM(TYPE(NAME="SQL_MATCH",PROPERTIES("sql" = "SELECT * FROM t_order WHERE order_id = 1; UPDATE t_order SET order_id = 5;"))),
  4.   LOAD_BALANCER(TYPE(NAME="RANDOM")));

Reserved word

ALTER, TRAFFIC, RULE, LABELS, TYPE, NAME, PROPERTIES, TRAFFIC_ALGORITHM, LOAD_BALANCER