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