| The diversity of master-slave database cluster architectures makes test scenarios and test tasks more complex,and the challenges of automated test systems are growing.The existing automated test system is still lacking in the automatic deployment of database nodes and the diversification of support scenarios,and can not meet the changing requirements of the database system.Therefore,designing and implementing a universal master-slave database automated test system is of great value.Based on the analysis of the common master-slave database test scenario and the characteristics of the test process,a semi-automated test system for the master-slave database is designed.The system consists of test management,monitoring and test result processing.Test management includes multi-node automation management and test plan customization that supports diversified test scenarios,and the execution of test tasks takes into account the possibility of database node failures and provides a solution to the failure.Monitoring implements real-time monitoring and feedback of the load and operating status of the database nodes,providing a basis for performance analysis.The test result processing uses data extraction,graphing and other methods to organize the test results and generate a complete performance test report.The master-slave database semi-automatic test system is implemented by module.The experimental scheme is designed to verify and analyze the modularization of the system.Choose the typical one-master-one-slave test scenario as test.Experimental results verify the correctness and functional completeness of each module.The experimental results show that the system can meet the following test requirements: monitoring of master and slave databases,customization of test schemes supporting diversified test scenarios,automatic management of multiple nodes,and sorting of test results.Thus,the semi-automatic deployment and testing of master and slave database can be realized. |