Vertica Analytics Platform Version 10.0.x Documentation

LOAD_BALANCE_GROUPS

Lists the objects contained by all load balance groups. Each row in this table represents a single object that is a member of a load balance group. If a load balance group does not contain any objects, it appears once in this table with its type column set to 'Empty Group.'

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:

  • ROUNDROBIN
  • RANDOM
  • NONE
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:

  • 'Fault Group'
  • 'Network Address Group'
  • 'Empty Group'
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