ALTER LOAD BALANCE GROUP
Syntax
ALTER LOAD BALANCE GROUP group_name { RENAME TO new_name | SET FILTER TO 'ip_cidr_addr' | SET POLICY TO 'policy' | [[ADD ADDRESS add_address_list] [DROP ADDRESS drop_address_list ]] | [[ADD FAULT GROUP add_group_list] [DROP FAULT GROUP drop_group_list]] }
Parameters
group_name | Name of an existing load balance group to change. |
RENAME TO new_name | Renames the group to new_name. |
SET FILTER TO 'ip_cidr_addr' | Changes the IP address filter that selects which members of a fault group or groups are included in the load balance group. This setting is only valid if the load balance group contains fault groups. |
SET POLICY TO 'policy' |
Changes the policy the load balance group uses to select the target node for the incoming connection. One of:
See CREATE LOAD BALANCE GROUP for details. |
ADD ADDRESS add_address_list | A comma-delimited list of network addresses to add to the load balance group. Only valid for load balance groups that contain network addresses or are empty. |
DROP ADDRESS drop_address_list | A comma-delimited list of network addresses to drop from the load balance group. Only valid for load balance groups that contain network addresses or are empty. |
ADD FAULT GROUP add_group_list | A comma-delimited list of fault groups to add to the load balance group. Only valid for load balance groups that contain fault groups or are empty. |
DROP FAULT GROUP drop_group_list | A comma-delimited list of fault groups to remove from the load balance group. Only valid for load balance groups that contain fault groups or are empty. |
Privileges
Example
Remove an address from the load balance group named group_2.
=> SELECT * FROM LOAD_BALANCE_GROUPS; name | policy | filter | type | object_name ---------+------------+--------+-----------------------+------------- group_1 | ROUNDROBIN | | Network Address Group | node01 group_1 | ROUNDROBIN | | Network Address Group | node02 group_2 | ROUNDROBIN | | Network Address Group | node03 (3 rows) => ALTER LOAD BALANCE GROUP group_2 DROP ADDRESS node03; ALTER LOAD BALANCE GROUP => SELECT * FROM LOAD_BALANCE_GROUPS; name | policy | filter | type | object_name ---------+------------+--------+-----------------------+------------- group_1 | ROUNDROBIN | | Network Address Group | node01 group_1 | ROUNDROBIN | | Network Address Group | node02 group_2 | ROUNDROBIN | | Empty Group | (3 rows)
The following example adds three network addresses to the group named group_2:
=> ALTER LOAD BALANCE GROUP group_2 ADD ADDRESS node01,node02,node03; ALTER LOAD BALANCE GROUP => SELECT * FROM load_balance_groups WHERE name = 'group_2'; -[ RECORD 1 ]---------------------- name | group_2 policy | ROUNDROBIN filter | type | Network Address Group object_name | node01 -[ RECORD 2 ]---------------------- name | group_2 policy | ROUNDROBIN filter | type | Network Address Group object_name | node02 -[ RECORD 3 ]---------------------- name | group_2 policy | ROUNDROBIN filter | type | Network Address Group object_name | node03
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