How to restrict one user connections in cluster.?

krishnamraju

We want to limit the number of connections taken by a single user.
For example: user name called 'bob' needs to restrict for 2 connections in cluster.
we are using Vertica 7.2.3.

Regards,
Krishnam Raju

RaghavA

Hi KrishnamRaju,

This feature has already been implemented in Version Frontloader (8.0+) of Vertica.

This feature was till not available with older releases. Please see below an extract of vertica 8.0 's documentation describing the new feature :

======
User-based User Client Connections
Using the parameter MAXCONNECTIONS, HPE Vertica limits the number of concurrent connections a user can have to the server. These connection limits are enforced cluster-wide by default. This allows better management as connection limits do not change as the cluster grows.

You can also implement client connection limits at the node level. This tends to increase performance as it eliminates inter-node communication.

In addition, the parameter IDLESESSIONTIMEOUT limits the amount of time a client session can remain idle before the system automatically closes the session.

For more information see Managing Client Connections. =======

Here are also the relevant links for the new functionality for you to read on :

https://my.vertica.com/docs/8.0.x/HTML/index.htm#Authoring/AdministratorsGuide/ManagingClientConnections/OverviewClientConnections.htm

https://my.vertica.com/docs/8.0.x/HTML/index.htm#Authoring/SQLReferenceManual/Statements/ALTERUSER.htm

https://my.vertica.com/docs/8.0.x/HTML/index.htm#Authoring/AdministratorsGuide/ManagingClientConnections/SetClientConnections.htm

Regards,
Raghav Agrawal