【会议论文】负载均衡策略中基于对数据库查询统计的节点负载率计算方法

SOONG, CHINGTSING

April 14, 2024

41 views

No comments

1965 words

科学研究

> 于2024年4月14日在IPEC 2024会议中报告并即将发表IPEC论文集（EI检索）中。

##Title

Node Load Rate Calculation Method based on Database Query Statistics in Load Balancing Strategy

## Author

**Qingqing Song **
Faculty of Applied Mathematics and Computer Science 
Belarusian State University 
Minsk, Belarus
fpm.sunC@bsu.by
 
**Zhen Wu**
Nanjing University of Aeronautics and Astronautics
Nanjing, China
13wuzhen@sina.com
 
**Shaoliang Xia**
Faculty of Applied Mathematics and Computer Science 
Belarusian State University 
Minsk, Belarus
fpm.sya@bsu.by

## Abstract

The calculation of node load rate has a crucial impact on the quality of load balancing strategies in distributed systems. The existing commonly used methods for calculating node load rates do not fully consider the current state of nodes, leading to a discrepancy between their calculation results and reality. This paper focuses on distributed information systems, taking databases as the starting point, and proposes a node load rate calculation method based on database query statistics to be used in load balancing strategies. It adopts a method of combining theoretical calculation data with benchmark performance testing data for analysis, fully considering the impact of factors such as data volume in distributed information system databases, peak database access periods, and data table indexes on calculation results. While ensuring the accuracy of node load rate calculation results, it minimizes the need for repetitive testing, conserves computer performance and energy resources, and reduces the time and economic expenses associated with node load rate calculation. The validation results of the algorithm indicate that the average error rate between the calculated database seconds per query (SPQ) and the actual values is as low as 1.7%. (Abstract)

## Additional Keywords and Phrases

Load Balancing Strategy, Node Load, Load Analysis, Information Systems, Database Load

【会议论文】负载均衡策略中基于对数据库查询统计的节点负载率计算方法

SOONG, CHINGTSING • 2024 年 04 月 14 日

【会议论文】负载均衡策略中基于对数据库查询统计的节点负载率计算方法

Leave a Comment Cancel reply
使用cookie技术保留您的个人信息以便您下次快速评论，继续评论表示您已同意该条款

【吉他谱】Aloha Heja He 指弹

【吉他谱】打上花火指弹版

【吉他谱】城南花已开指弹版

【吉他谱】Take Me Hand 指弹版

【吉他谱】溯指弹版

Windows 系统服务器远程端口爆破解决方案

【Java】Static{……}静态代码块的作用

【系分】FIFO、LRU、OPT这三种置换算法的缺页次数

Spring Boot 框架下配置定时任务（服务）的流程及注意事项

Node.JS 多版本管理框架NVM (Node.js Version Manager)

【会议论文】负载均衡策略中基于对数据库查询统计的节点负载率计算方法

Leave a Comment Cancel reply 使用cookie技术保留您的个人信息以便您下次快速评论，继续评论表示您已同意该条款

【会议论文】负载均衡策略中基于对数据库查询统计的节点负载率计算方法

Leave a Comment Cancel reply
使用cookie技术保留您的个人信息以便您下次快速评论，继续评论表示您已同意该条款