Connection Load Balancing

Jim_KnicelyJim_Knicely Employee, Registered User, VerticaExpert
edited August 28 in Vertica Tips

Each client connection to a host in the Vertica cluster requires a small overhead in memory and processor time. If many clients connect to a single host, this overhead can begin to affect the performance of the database. You can attempt to spread the overhead of client connections by dictating that certain clients connect to specific hosts in the cluster. However, this manual balancing becomes difficult as new clients and hosts are added to your environment.

Vertica to the rescue!

"Native connection load balancing" is a feature built into the Vertica Analytic Database server and client libraries as well as vsql.

Example:

[[email protected] ~]$ vsql -c "SELECT currentclientbalancingpolicy FROM vs_global_settings;"
 currentclientbalancingpolicy
------------------------------
 roundrobin
(1 row)

[[email protected] ~]$ vsql -C
Welcome to vsql, the Vertica Analytic Database interactive terminal.

Type:  \h or \? for help with vsql commands
       \g or terminate with semicolon to execute query
       \q to quit

INFO: Connected using a load-balanced connection.
INFO: Connected to 192.168.56.102 at port 5433.

dbadmin=> \q

[[email protected] ~]$ vsql -C
Welcome to vsql, the Vertica Analytic Database interactive terminal.

Type:  \h or \? for help with vsql commands
       \g or terminate with semicolon to execute query
       \q to quit

INFO: Connected using a load-balanced connection.
INFO: Connected to 192.168.56.103 at port 5433.

dbadmin=> \q

[[email protected] ~]$ vsql -C
Welcome to vsql, the Vertica Analytic Database interactive terminal.

Type:  \h or \? for help with vsql commands
       \g or terminate with semicolon to execute query
       \q to quit

INFO: Connected using a load-balanced connection.
INFO: Connected to 192.168.56.104 at port 5433.

dbadmin=> \q

[[email protected] ~]$ vsql -C
Welcome to vsql, the Vertica Analytic Database interactive terminal.

Type:  \h or \? for help with vsql commands
       \g or terminate with semicolon to execute query
       \q to quit

INFO: Connected using a load-balanced connection.
INFO: Connected to 192.168.56.102 at port 5433.
Sign In or Register to comment.