LOAD_BALANCE_GROUPS
NAME | VARCHAR | The name of the load balance group |
POLICY | VARCHAR |
The policy that sets how the group chooses the node for a connection. Contains one of the following:
|
FILTER | VARCHAR | The IP address range in CIDR format to select the members of a fault group that are included in the load balance group. This coliumn only has a value if the TYPE column is 'Fault Group.' |
TYPE | VARCHAR |
The type of object contained in the load balance group. This value is one of:
|
OBJECT_NAME | VARCHAR | The name of the fault group or network address included in the load balance group. This column is NULL if the groupcontains no objects. |
Example
=> 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 | group_all | ROUNDROBIN | | Network Address Group | node01 group_all | ROUNDROBIN | | Network Address Group | node02 group_all | ROUNDROBIN | | Network Address Group | node03 group_fault_1 | RANDOM | 0.0.0.0/0 | Fault Group | fault_1 (7 rows)
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