The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

View the History of Connection Load Balance Operations

The Data Collector table DC_LOAD_BALANCE_OPERATIONS tracks the history of connection load balance operations.

Example:

[[email protected] ~]$ vsql -c "SELECT version();"
              version
------------------------------------
Vertica Analytic Database v9.2.1-4
(1 row)

dbadmin=> SELECT DISTINCT component, description FROM data_collector WHERE table_name = 'dc_load_balance_operations';
       component       |                  description
-----------------------+-----------------------------------------------
LoadBalanceOperations | History of connection load balance operations
(1 row)

dbadmin=> SELECT clear_data_collector('LoadBalanceOperations');
clear_data_collector
----------------------
CLEAR
(1 row)

[[email protected] ~]$ vsql -c "SELECT node_name, node_address FROM nodes;"
     node_name      | node_address
--------------------+---------------
v_test_db_node0001 | 172.16.61.176
v_test_db_node0002 | 172.16.61.177
v_test_db_node0003 | 172.16.61.178
(3 rows)

dbadmin=> \! vsql -Cc "SELECT local_node_name();"
  local_node_name
--------------------
v_test_db_node0001
(1 row)

dbadmin=> \! vsql -Cc "SELECT local_node_name();"
  local_node_name
--------------------
v_test_db_node0002
(1 row)

dbadmin=> \! vsql -Cc "SELECT local_node_name();"
  local_node_name
--------------------
v_test_db_node0003
(1 row)

[[email protected] ~]$ vsql -c "SELECT node_name, client_remote_address, status FROM dc_load_balance_operations ORDER BY time;"
     node_name      | client_remote_address |                             status
--------------------+-----------------------+----------------------------------------------------------------
v_test_db_node0001 | ::1                   | Success. Load balance redirect to: [172.16.61.176] port [5433]
v_test_db_node0001 | ::1                   | Success. Load balance redirect to: [172.16.61.177] port [5433]
v_test_db_node0001 | ::1                   | Success. Load balance redirect to: [172.16.61.178] port [5433]
(3 rows)

Helpful Links:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/ManagingClientConnections/LoadBalancing/ConnectionLoadBalancing.htm
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/Monitoring/Vertica/RetainingMonitoringInformation.htm

Have fun!

Sign In or Register to comment.