Operating and maintaining method and system of database in testing environment

Abstract

The invention provides an operating and maintaining method and system of a database in the testing environment. The method comprises the steps that the application information, submitted by a user, of the database is stored into a storage unit through an interaction unit; a machine is selected from a machine resource pool through a machine allocating unit according to the application information, and the host name and the interface number of the selected machine are sent to a database setting unit; a database installation package, the application information and an installation order are sent to a corresponding machine through the database setting unit according to the host name and the interface number of the selected machine, the database installation package operates through the corresponding machine, and the database is installed according to the application information; on-line actual data are synchronized to the database set on the machine through a data synchronization unit. By means of the technical scheme, the deployment of the database in the testing environment can be efficiently and automatically carried out.

Description

【Technical field】 [0001] The invention relates to a test technology for Internet applications, in particular to a database operation and maintenance method and system in a test environment. 【Background technique】 [0002] Current Internet products use databases as persistent data storage devices. When testing Internet products, testers not only need to deploy the code of the test case, but also need to deploy the database in the test environment; when maintaining the test environment, they also need to The database needs to be operated and maintained at the same time. The operation and maintenance of the database in the test environment mainly includes: selecting a suitable machine, building a database on the selected machine, preparing test data in the database, collecting test results from the database, and dealing with database problems. [0003] At present, in the testing of Internet products, the operation and maintenance method of the database in the test environment ...

AI Technical Summary

Problems solved by technology

[0004] 1. The testers of each Internet product need to manually deploy the database on the machine, which often makes only one test case deployed on a machine. If the number of visits to the test case is very small, the utilization rate of the machine will be greatly reduced

[0005] 2. When testers build the database in the test environment, if they are not proficient in operation or the topology of the database cluster is complex, they will spend a lot of time; when the database is abnormal, if the tester is not very familiar with database technology, they need to seek help from database management Therefore, the cost of communication is high. If online data is used as test data, the approval process of copying data needs to be executed, which takes a lot of time; therefore, the efficiency of deploying the database in the test environment is very low, and a lot of manpower is wasted. material resources

[0006] 3. When testing the performance of Internet products, it is necessary to simulate the actual online environment, so that the reliability of the test results is relatively high, but the number of machines deployed by the testers is difficult to be consistent with the actual online environment, and the database built The topology of the cluster is also very simple, which leads to low reliability of the performance test results of Internet products

Images