CN105302729A - Storage system testing method based on database application - Google Patents

Abstract

The invention discloses a storage system testing method based on database application, belonging to the field of storage system detection, and aiming at solving the technical problem that in the application of combining with a database, the storage system is abnormal, which is very likely to cause data loss, and huge loss, namely storage system stability is caused. The technical scheme is as follows: the method comprises the following steps: (1) building a database application environment: the storage system to be tested is used, a specific database application environment is built, and the actual implementation environment of a user is simulated, so that the stability problem of the storage system can be exposed as soon as possible under the complex application environment; (2) writing an sql script independently: the test script comprises the steps of creating new users in batches, creating tables in batches, exporting and importing in batches, and verifying the data consistency of the storage system under the application pressure of the database by running the script and observing an Oracle log; (3) a swingbench testing tool; (4) and outputting a test result.

Description

A Storage System Testing Method Based on Database Application

technical field

The present invention relates to the field of storage system testing, specifically a storage system testing method based on database applications.

Background technique

With the continuous expansion of key data volumes in different industries, the combination of database applications and storage systems has gradually attracted people's attention. Among them, Oracle is favored by users in key industries because of its RAC, DataGuard cluster high availability and RMAN backup functions. In the application combined with the database, the abnormality of the storage system is very likely to cause data loss and cause huge losses. Therefore, the test of the stability of the storage system and data consistency in this implementation is particularly important.

Stability problems of the storage system are more likely to occur under high pressure and long-term running conditions. Therefore, in the test, we need to simulate this kind of environment and test the IO characteristics of database read and write, which is precisely difficult to achieve.

Contents of the invention

The technical task of the present invention is to provide a storage system testing method based on database applications to solve the problem of storage system stability that is very likely to cause data loss and cause huge losses when combined with database applications.

The technical solution adopted by the present invention to solve the technical problem is: a storage system testing method based on database application, comprising the following steps:

(1) Build a database application environment: Use the storage system to be tested to build a specific database application environment, simulate the actual implementation environment of the user, and make the storage system expose its stability problems as much as possible in a complex application environment;

(2) Independently write sql scripts: the test scripts include creating new users in batches, creating tables in batches, exporting and importing in batches, and verifying the data consistency of the storage system under the pressure of database applications by running the above scripts and observing Oracle logs;

(3) swingbench test tool: run swingbench, simulate actual business, conduct 7*24h long-term stability test, and verify the stability of the storage system under the pressure of database application;

(4) Output the test result: Start the smart restart machine to start the test, at this time, the power-off delay time starts counting down according to the set value.

Preferably, the database application environment is RAC or Dataguard.

Compared with the prior art, a storage system testing method based on database application of the present invention has the following beneficial effects:

1. The traditional test method is mainly to test with test tools such as Iometer, which cannot completely simulate the IO characteristics of database applications. The present invention is a storage system test method for database applications, that is, to build a real environment, and to conduct a comprehensive and automatic test on the data consistency and stability of the storage system through the combination of sql script and swingbench, thereby avoiding the traditional test method. Match the shortcomings of database application IO characteristics.

2. The present invention is a storage system testing method. Through an automated testing method, manpower is saved, work efficiency is improved, the actual application scene of the storage system is simulated, and a simple method is provided for its testing. Ultimately, the purpose of improving the reliability of the storage system is achieved.

The invention has the characteristics of reasonable design, simple structure and convenient use, and thus has very good popularization and use value.

detailed description

The present invention will be further described below by specific examples.

A storage system testing method based on a database application of the present invention, a storage system testing method based on a database application comprises the following steps:

(1) Build an OracleRAC application environment or a DataGuard application environment; build a corresponding test system for a specific application environment. Make sure the data files are stored on a logical volume that is mapped to the host. The specific topology is as close as possible to the actual application.

(2) Write test scripts, execute script automation tests; write sql scripts, including data batch insertion scripts, user batch creation scripts, batch export scripts, and batch import scripts. By running scripts, it can automate batch operations and verify the data consistency of the system.

(3) Configure swingbench, execute swingbench simulation business test; run swingbench, simulate actual business, and conduct 7*24h long-term stability test.

(4) Output the test result; start the smart restart machine to start the test, at this time, the power-off delay time starts counting down according to the set value.

Specific work process: First, simulate the actual application environment and build a test environment based on database applications;

Then, write a sql script, taking batch insertion of data as an example:

declare

sTablenamevarchar2(60);

v_sqlvarchar2(1000);

begin

sTablename:='abctest';

foriin1..10000loop

v_sql:='createtable'||sTablename||to_char(i)||'asselect*fromdba_objects';

executeimmediatev_sql;

end loop;

end;

/

Then, the script creates 10,000 tables in batches by copying dba_objects, which can verify data stability during the batch creation process, and these newly created data can be used as source data for subsequent tests;

Then, run swingbench for a long time, maintain a high number of concurrent users, and run 7*24h;

Finally, output the detection result.

Through the above specific implementation manners, those skilled in the technical field can easily realize the present invention. However, it should be understood that the present invention is not limited to the specific embodiments described above. On the basis of the disclosed embodiments, those skilled in the art can arbitrarily combine different technical features to achieve different technical solutions.

Claims (2)

1. a storage system testing method based on database application, is characterized in that: comprise the steps: (1) Build a database application environment: Use the storage system to be tested to build a specific database application environment, simulate the actual implementation environment of the user, and make the storage system expose its stability problems as much as possible in a complex application environment; (2) Independently write sql scripts: the test scripts include creating new users in batches, creating tables in batches, exporting and importing in batches, and verifying the data consistency of the storage system under the pressure of database applications by running the above scripts and observing Oracle logs; (3) swingbench test tool: run swingbench, simulate actual business, conduct 7*24h long-term stability test, and verify the stability of the storage system under the pressure of database application; (4) Output the test result: Start the smart restart machine to start the test, at this time, the power-off delay time starts counting down according to the set value. 2. A storage system testing method based on database application according to claim 1, characterized in that: said database application environment is RAC or Dataguard.