Development of Load Balancer and Parallel Database Management Module
Ruslan Farshatovich Gibadullin, Igor S. Vershinin, R. Sh. Minyazev · 2018
The article discusses main development aspects of the load balancer for the cluster. The goal is to increase the speed of queries processing to a database running with PostgreSQL DBMS on the Windows operating system. The developed balancing method was chosen by performance and reliability criteria. The software module distributes evenly the load between 4 cluster nodes depending on how much CPU is used on each of the work nodes. The dynamic load balancer processes SQL queries in parallel. The parallel database management module performs encryption of the queries results. The work speed of the developed balancing software module has been studied on a representative set of queries, the obtained results were compared with the work of load balancing configuration consisting of 2 work nodes, and with parallel and sequential processing of the representative set of queries on a single node.