/ Case introduction / Project background Every year before major promotions (such as "double 11"), banks will evaluate the performance and capacity of databases related to online banking and mobile phones, and need to conduct stress tests on databases. However, the stress tests of each database are time-consuming and labor-consuming, resulting in a great waste of manpower and high requirements for personnel skills. Not only that,Each test must enter the ECC machine room for operation, which not only increases the management and resource consumption of the ECC machine room, but also adds a security risk.
It has become an urgent need to realize the automation of high simulation test and improve the test efficiency. / Customer pain points 1. There are too many high imitation test databases, especially the databases related to "double 11", and it takes 7 days for one person to test one database.
2.The high simulation test has to go to ECC for operation every time, which conflicts with the management of "no or less ECC".
3. The test report needs to be written manually, and many data can be found by themselves. / Solution 1. What are the difficulties in realizing one key high imitation2.1. What are the difficulties in realizing one key high imitation? A high simulation test involves multi center and multi system cooperation, and the test is carried out in the high simulation environment, which is isolated from the production environment;Traffic acquisition and database recovery also need to open a special network.The main difficulties in realizing one key high imitation are as follows:
     1) How to conduct cross center and cross network control high simulation test?
     2) How to automatically flow from production to quasi production drill environment?
     3) How to control the whole process?
     4) How to realize the operation control of office network?
     5) How to realize large-scale elastic deployment? 2. “"Total score" structure The general control service is deployed in the production environment and opens the access rights of the sub control service of the scheme high simulation environment, so that the general control can control the sub control of packet capture and high simulation test. 3. Database backup and recovery, cross center collaboration2.3. Database backup and recovery, cross center collaboration The unified backup storage center is adopted, and the production data is backed up to the backup center at a unified fixed point. The high imitation exercise environment can use the backup files of the center for database high imitation reply, and the whole process is controlled by the same sub control service and reported to the general control. 4. Automatic flow from production to quasi production drill environment2.4. Automatic flow from production to quasi production drill environment Network storage is used for the transmission of traffic packets. The network storage can be accessed in both high imitation environment and production environment. The production traffic can be automatically transmitted to the network storage, and the high imitation test can be automatically downloaded to complete the production traffic transmission. 5. High imitation drill and office environment operation2.5. High imitation drill and office environment operation The high imitation exercise environment is isolated from the office network on the network and cannot be operated directly in the office environment. The data in the exercise environment is production data, and access is prohibited. One click high imitation uses the network agent to make the general control web service accessible in the office environment. The web only provides process control and does not involve sensitive data. 6. Flexible deployment With more and more high simulation test tasks of the database, it is necessary to complete the test deployment more quickly, conduct the test more simply, and switch the test tasks more quickly. One click high simulation adopts multi system collaborative operation, which can quickly obtain the production flow required for the test, control all test processes, and automatically select the playback server and database server;The interface is easy to operate. Only the database related information needs to be configured. All processes are completed by the background, and the interface provides process status and progress. / Program advantages       1. Database test coverage increased by more than 2 times: Before using one key high imitation, the annual double 11 needs to be tested 4 months in advance, and 10-15 sets of database tests can be completed. After using one key high imitation, the tests only need to be tested 2 months in advance, and 30-50 sets of database tests can be completed (if resources are sufficient, all database tests in the bank can be completed in a short time)       2. Save 90% manpower investment: To realize one click high imitation, it only needs DBA or other high imitation testers to input the relevant test data in the web interface to realize one click test. The test report can be viewed after the test is completed. The whole process does not need human intervention, reducing the number of special testers.       3. Reduced requirements for human skills: When one click high imitation is not used, testers need the operation skills of packet capture, FTP, database recovery and high imitation system. After realizing high imitation, these processes are automated, and these skills are not needed.       4. Annual test database data improvement: To achieve one click high imitation, as long as there are enough servers in the high imitation environment, you can test as many libraries as you want, and you don't need to invest extra manpower.       5. 0 access to ECC machine room: Realize one key high imitation, only need to operate on the office network, and there is no need to enter the ECC machine room for operation.       6. More flexible testing: Realize one key high imitation, which can be carried out at any time, whether it is pressure test, upgrade or fault recurrence.