摘要
在大规模云生产环境中在线评估数据库效能,对云厂商进一步优化云成本至关重要。为了评估云数据库的使用效能,提出了一种数据驱动的、基于计算与存储指标融合的云数据库效能评估方法CDES。该方法根据云数据库实例负载行为和性能画像,从计算和存储两方面选取影响云数据库成本与效能的主要指标,再结合云监控平台采集的数据,评估云数据库实例与集群的线上实际使用效能。基于CDES评估结果,进一步提出了云数据库效能优化的治理方案,提供效能优化建议,引导用户减少闲置资源。CDES已被部署在某大型互联网企业生产环境中,并用于其OLTP云数据库产品的效能评价。实验结果表明,所提方法能有效评估超过5000个云数据库实例的集群的效能并引导治理,单位业务量下实例最高能节省40.74%的成本。
Evaluating database efficiency in a large-scale cloud production environment is crucial for cloud vendors to optimize the cloud cost.In order to evaluate the use efficiency of cloud database,this paper proposes CDES,a data-driven cloud database efficiency evaluation method based on the fusion of computing and storage indicators.According to the load behavior and perfor-mance profile of the cloud database instance,this method selects the main metrics that affect the cost and efficiency of the cloud database from two aspects of computing and storage,and then combines the data collected by the cloud monitoring platform to evaluate the efficiency of the cloud database instance and cluster.Based on the evaluation results of CDES,the governance scheme of cloud database efficiency is further proposed,together with the governance optimization suggestions to guide users to improve the efficiency of resource utilization and reduce idle resources.Finally,CDES has been deployed in the production environment of a large Internet enterprise and used for the performance evaluation of the cloud OLTP database product.The results show that the proposed method can effectively evaluate the efficiency and guide governance of the cluster with more than 5000 cloud database instances,and the governance results can save 46.15%of the instance cost at most.
作者
韩宇捷
徐志杰
杨定裕
黄波
郭健美
HAN Yujie;XU Zhijie;YANG Dingyu;HUANG Bo;GUO Jianmei(School of Data Science and Engineering,East China Normal University,Shanghai 200062,China;Alibaba Group,Hangzhou 311121,China)
出处
《计算机科学》
CSCD
北大核心
2024年第6期111-117,共7页
Computer Science
基金
国家自然科学基金面上项目(62272167)。
关键词
云计算
云数据库
效能评估
云成本优化
Cloud computing
Cloud database
Efficiency evaluation
FinOps
