View the History of Connection Load Balance Operations

Posted August 9, 2019 by Jim Knicely, Vertica Principal Solution Architect

Hand holding old-fashioned brass balance scale on a black background
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-4https://www.vertica.com/wp-admin/post.php?post=999145387&action=edit#edit_timestamp (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/latest/HTML/Content/Authoring/AdministratorsGuide/ManagingClientConnections/LoadBalancing/ConnectionLoadBalancing.htm https://www.vertica.com/docs/latest/HTML/Content/Authoring/AdministratorsGuide/Monitoring/Vertica/RetainingMonitoringInformation.htm

Have fun!