CREATE ROUTING RULE
Creates a load balancing routing rule that directs incoming client connections from an IP address range to a group of Vertica nodes. This group of Vertica nodes is defined by a load balance group. Once you create a routing rule, any client connection originating from the rule's IP address range is redirected to one of the nodes in the load balance group if the client opts into load balancing.
Syntax
CREATE ROUTING RULE rule_name ROUTE 'address_range' TO group_name
Arguments
rule_name |
A name for the routing rule. |
'address_range' |
The IP address range of incoming client connections to redirect. This range must be in CIDR format. |
group_name | The name of the load balance group to handle the client connections from the address range. You create this group using the CREATE LOAD BALANCE GROUP statement. |
Privileges
The user must be a superuser.
Examples
The following example creates a routing rule that routes all client connections from 192.168.1.0 to 192.168.1.255 to a load balance group named internal_clients:
=> CREATE ROUTING RULE internal_clients ROUTE '192.168.1.0/24' TO group_internal; CREATE ROUTING RULE
See Also
- About Connection Load Balancing Policies
- ALTER LOAD BALANCE GROUP
- ALTER NETWORK ADDRESS
- ALTER ROUTING RULE
- CREATE LOAD BALANCE GROUP
- CREATE NETWORK ADDRESS
- CREATE ROUTING RULE
- DESCRIBE_LOAD_BALANCE_DECISION
- DROP LOAD BALANCE GROUP
- DROP NETWORK ADDRESS
- DROP ROUTING RULE
- LOAD_BALANCE_GROUPS
- NETWORK_ADDRESSES