计算机工程与科学2023，Vol.45Issue(12)：2165-2174,10.DOI:10.3969/j.issn.1007-130X.2023.12.008
ShadowDB:基于SQL引擎的全链路压力测试分流系统
ShadowDB:A SQL engine based traffic-split system for full-link stress test
摘要
Abstract
Full-link stress test,as an emerging software testing technique,performs stress tests in the production system directly.It aims at evaluating the performance of online systems accurately.Traffic-split techniques based on shadow databases can guarantee the production data not to be polluted during the process of full-link stress test.Based on SQL engine,this paper designs and implements a complete open-source traffic-split system,named ShadowDB,for full-link stress test.The main idea of ShadowDB is to split the traffic of user requests through a SQL parser and a SQL router.Currently,ShadowDB can correctly distribute all SQL statements of six different kinds of relational database man-agement systems.Furthermore,it can support two traffic-split algorithms,i.e.,column-based shadow algorithm and hint-based shadow algorithm.ShadowDB implements all of the interfaces of JDBC,enab-ling online systems to incorporate it without any change.ShadowDB can be embedded in the application programs,thus it do not forward the requests through networks,which has the minimal impact on the request efficiency and guarantees the reliability of full-link stress test.Extensive experiments wire con-ducted based on two widely-used benchmarking tools.The experimental results show that ShadowDB performs much better than the comparing systems.关键词
全链路压力测试/SQL引擎/数据分流/影子库Key words
full-link stress test/SQL engine/traffic split/shadow database分类
信息技术与安全科学引用本文复制引用
姜俊,李文慧,张亮,王善民,李瑞远..ShadowDB:基于SQL引擎的全链路压力测试分流系统[J].计算机工程与科学,2023,45(12):2165-2174,10.基金项目
国家自然科学基金(62202070) （62202070）
中国博士后科学基金(2022M720567) （2022M720567）
