数据库集群系统多指标动态负载均衡技术研究  

Multi-index dynamic load balancing technology in database cluster system

作　　者：刘倍雄 骆金维 陈孟祥 LIU Bei-xiong;LUO Jin-wei;CHEN Meng-xiang(Department of Mechanical and Electrical Engineering,Guangdong Environmental Protection Engineering Vocational College,Foshan 528216,China;School of Information Engineering,Guangdong Innovative Technical College,Dongguan 523960,China)

机构地区：[1]广东环境保护工程职业学院机电工程系,广东佛山528216 [2]广东创新科技职业学院信息工程学院,广东东莞523960

出　　处：《电子设计工程》2018年第22期19-22,31,共5页Electronic Design Engineering

基　　金：2015年广东省高等学校优秀青年教师培养资助项(YQ2015236;YQ2015237)

摘　　要：数据库分发客户的请求海量增加,致使集群系统的响应能力大幅度下降。当前方法不能克服集群系统存在的瓶颈,不能增强集群系统相应的能力。为此,提出一种基于改进的多指标动态负载均衡方法。过程中建立要求用户模型,分类不同服务质量,依据动态负载均衡指示,结合网络平均负载,得出联合优化函数。利用多指标节点的性能与计算的资源,依据集群系统的动态负载平衡的度量值进行的任务分配,将任务的分配适合节点,使集群系统的动态负载逐渐均衡,提高了集群系统的多指标节点的利用率。完成对数据库集群系统多指标动态负载均衡的技术研究。实验的结果表明,该方法减少了集群系统存在的瓶颈,增强了集群系统的响应能力。The request of the database distribution customers has increased greatly,and the response ability of the cluster system has been greatly reduced.The current method can not overcome the bottleneck of the cluster system,and can not enhance the corresponding capability of the cluster system.To this end,a new dynamic load balancing method based on improved multi index is proposed.In the process,we establish user request model and classify different service quality.According to the dynamic load balancing instruction,combined with the average load of network,we get the joint optimization function.The performance and calculation of multi index node resources,based on the dynamic cluster system load measurement task allocation value balance,the task allocation for nodes,the dynamic load balancing cluster system gradually,improve the utilization of multi index node cluster system rate.The technical research on multi index dynamic load balancing of the database cluster system is completed.The experimental results show that this method reduces the bottleneck of the cluster system and enhances the response capability of the cluster system.

关 键 词：数据库 集群系统 多指标 动态 负载均衡 

分 类 号：TP393[自动化与计算机技术—计算机应用技术]