Techniques for scaling and managing database query processing

A non-transitory computer readable medium having stored thereon instructions for causing a processing circuitry to execute a process, the process comprising:

• determining at least one change in a number of virtualized nodes to be implemented based on service data related to servicing of requests by the virtualized nodes;
• adjusting capacities of at least one of the virtualized nodes based on the service data, wherein the capacities are defined with respect to connection limits, wherein adjusting the capacities includes modifying at least a portion of the connection limits;
• and
• implementing the at least one determined change by modifying the number of virtualized nodes, wherein the at least one determined change in the modified number of virtualized nodes includes terminating a first virtual node of virtualized nodes, wherein terminating the first virtualized node includes:
• preventing subsequent queries from arriving at the first virtualized node
• monitoring for completion of existing queries by the first virtualized node;
• and
• terminating the first virtualized node when all existing queries have been completed by the first virtualized node.

A system for scaling management, comprising:

• a processing circuitry;
• and
• a memory, the memory containing instructions that, when executed by the processing circuitry, configure the system to:
• determine at least one change in a number of virtualized nodes to be implemented based on service data related to servicing of requests by the virtualized nodes;
• adjust capacities of at least one of the virtualized nodes based on the service data, wherein the capacities are defined with respect to connection limits, wherein adjusting the capacities includes modifying at least a portion of the connection limits;
• and
• implement the at least one determined change by modifying the number of virtualized nodes, wherein the at least one determined change in the modified number of virtualized nodes includes terminating a first virtual node of the virtualized nodes, wherein the system is further configured to:
• prevent subsequent queries from arriving at the first virtualized node;
• monitor for completion of existing queries by the first virtualized node;
• and
• terminate the first virtualized node when all existing queries have been completed by the first virtualized node.