View the History of Connection Load Balance Operations
Jim_Knicely
- Select Field - Administrator
The Data Collector table DC_LOAD_BALANCE_OPERATIONS tracks the history of connection load balance operations.
Example:
[dbadmin@SE-Sandbox-26-node1 ~]$ 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)
[dbadmin@SE-Sandbox-26-node1 ~]$ 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)
[dbadmin@SE-Sandbox-26-node1 ~]$ 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!
0