Design And Implementation Of A Tool For Transactional Database Stability Testing With Interference Scenarios Enhanced

With the digital transformation of enterprises and the development of digital economy,transactional database management systems have increasingly become an important part of the data infrastructure in the national economy and people's livelihood industry with their high real-time response performance and safe and reliable transaction processing characteristics.If there is unstable performance or sudden collapse in its operation,it will cause huge losses and serious consequences to enterprises or people's livelihood infrastructure.In response to this problem,a set of testing tools is designed and implemented,which can test the runtime stability of transactional databases.The testing tool focus on enhancing interference scenarios.In view of the interference caused by the physical hardware resources of the same server service process when the database is running,the controllable generation and loading methods of processor occupation interference,disk I/O occupation interference and memory occupation interference are designed by studying the TPC-E transaction processing performance benchmark specification and the GNU/Linux kernel operating system library functions.According to the requirements of software stability testing,multi-level testing types are designed,including basic testing,expansion testing,and interference testing,which are used to cover the real production and operation load scenarios of transactional databases to meet the needs of stability testing.The tool is divided into a test terminal and a proxy server.The test terminal is composed of a test user graphic window module,an interference module,a load module,a user module,and a test control module.The proxy server is composed of an interference execution module and a real-time data acquisition module.The load module adopts multithreading and ODBC database connection technology to solve the problem of parallel sending and receiving of transaction load sequence;the interference execution module adopts a programming method combining multi-process and multi-thread to solve the problem of real-time running interference simulation.The transactional database stability testing tool designed and implemented to enhance interference scenarios is used to conduct three levels of stability tests for PostgreSQL and MySQL.The results show that the stability indexes of PostgreSQL and MySQL database fluctuate within the normal range in the multi-level stability tests.PostgreSQL has better scalability performance under the multi-process model,while MySQL has better stability performance under the multi-thread model.