CN111259020A - Method, system, equipment and medium for checking multi-storage-volume copy consistency - Google Patents
Method, system, equipment and medium for checking multi-storage-volume copy consistency Download PDFInfo
- Publication number
- CN111259020A CN111259020A CN202010026534.7A CN202010026534A CN111259020A CN 111259020 A CN111259020 A CN 111259020A CN 202010026534 A CN202010026534 A CN 202010026534A CN 111259020 A CN111259020 A CN 111259020A
- Authority
- CN
- China
- Prior art keywords
- storage volumes
- data
- copy
- database server
- storage
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Withdrawn
Links
- 238000000034 method Methods 0.000 title claims abstract description 46
- 238000013507 mapping Methods 0.000 claims abstract description 49
- 238000004590 computer program Methods 0.000 claims description 9
- 238000012795 verification Methods 0.000 abstract description 4
- 230000006870 function Effects 0.000 description 7
- 238000010586 diagram Methods 0.000 description 4
- 230000003287 optical effect Effects 0.000 description 4
- 230000000694 effects Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 230000001360 synchronised effect Effects 0.000 description 3
- 238000004422 calculation algorithm Methods 0.000 description 2
- 238000013461 design Methods 0.000 description 2
- 239000000835 fiber Substances 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000001680 brushing effect Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 230000014509 gene expression Effects 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computer Security & Cryptography (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method, a system, equipment and a storage medium for checking the copy consistency of a plurality of storage volumes, wherein the method comprises the following steps: respectively creating a first storage pool and a second storage pool; creating a plurality of primary storage volumes in a first storage pool, creating a plurality of copy storage volumes in a second storage pool in the same number as the primary storage volumes, and mapping the plurality of primary storage volumes to a database server; writing corresponding data into a plurality of main storage volumes, and recording the data in a database default table; copying the data in the plurality of primary storage volumes to a plurality of corresponding copy storage volumes in a full scale mode, and mapping the data to a database server by using the copy storage volumes to replace the primary storage volumes; and judging whether the data of the database is changed or not based on the new mapping relation and the default table of the database. The scheme provided by the invention realizes the consistency verification of a plurality of copy storage volumes by using the copy storage volumes to replace the mapping relation of the main storage volume, and improves the reliability and efficiency of the data consistency verification of the copy storage volumes.
Description
Technical Field
The present invention relates to the field of data copying, and more particularly, to a method, system, computer device, and readable medium for checking consistency of multiple storage volume copies.
Background
With the widespread use of new technologies such as storage and database applications, the security requirements for data are also increasing. In order to ensure data security, the data is often copied and backed up by means of volume copy on the storage side. When a plurality of storage volumes are provided for applications such as a database, whether data copying can meet the data copying requirements of various application levels and whether the data of the copied volume is consistent with the data of the original storage volume does not exist at present, and a simple and efficient testing process does not exist.
Disclosure of Invention
In view of this, an object of the embodiments of the present invention is to provide a method, a system, a computer device, and a computer-readable storage medium for checking consistency of multiple storage volume copies, in which cached data of a main storage volume is flushed under a database server side, and a mapping relationship between the main storage volume and the copy storage volume is replaced by the copy storage volume to implement consistency checking on multiple copy storage volumes, so as to improve reliability and efficiency of data consistency checking on the copy storage volume.
Based on the above object, an aspect of the embodiments of the present invention provides a method for checking consistency of multiple storage volume copies, including the following steps: respectively creating a first storage pool and a second storage pool; creating a plurality of primary storage volumes in the first storage pool, creating a plurality of copy storage volumes in the second storage pool in the same number as the primary storage volumes, and mapping the plurality of primary storage volumes to a database server; writing corresponding data into a plurality of main storage volumes, and recording the data in a database default table; copying the data in the plurality of the primary storage volumes to a corresponding plurality of the copy storage volumes, and mapping the data to the database server by using the copy storage volumes to replace the primary storage volumes; and judging whether the data of the database is changed or not based on the new mapping relation and the default table of the database.
In some embodiments, said writing corresponding data to a plurality of said primary storage volumes comprises: and configuring a plurality of main storage volumes into a table space, and writing corresponding data into the table space.
In some embodiments, the mapping to the database server in place of the primary storage volume with the copy storage volume comprises: the mapping between the plurality of primary storage volumes and the database server is broken, the plurality of copy storage volumes are mapped to the database server, and the tablespace is reconfigured on the database server to the plurality of copy storage volumes.
In some embodiments, said mapping a plurality of said primary storage volumes to a database server comprises: scanning the database server to identify a plurality of the primary storage volumes mapped to the database server.
In some embodiments, said mapping a plurality of said primary storage volumes to a database server further comprises: and formatting the main storage volumes into a file system which can be directly called by a database, and mounting the formatted main storage volumes to a specified directory.
In another aspect of the embodiments of the present invention, a system for checking copy consistency of multiple storage volumes is further provided, including: a storage module configured to create a first storage pool and a second storage pool, respectively; a creation module configured to create a plurality of primary storage volumes in the first storage pool, create a plurality of copy storage volumes in the same number as the primary storage volumes in the second storage pool, and map the plurality of primary storage volumes to a database server; the data module is configured to write corresponding data into the plurality of main storage volumes and record the data in a database default table; a mapping module configured to copy a total amount of data in the plurality of primary storage volumes to a corresponding plurality of copy storage volumes, and map the data to the database server using the copy storage volumes instead of the primary storage volumes; and the judging module is configured for judging whether the data of the database is changed or not based on the new mapping relation and the default table of the database.
In some embodiments, the data module is further configured to: and configuring a plurality of main storage volumes into a table space, and writing corresponding data into the table space.
In some embodiments, the mapping module is further configured to: the mapping between the plurality of primary storage volumes and the database server is broken, the plurality of copy storage volumes are mapped to the database server, and the tablespace is reconfigured on the database server to the plurality of copy storage volumes.
In another aspect of the embodiments of the present invention, there is also provided a computer device, including: at least one processor; and a memory storing computer instructions executable on the processor, the instructions when executed by the processor implementing the steps of the method as above.
In a further aspect of the embodiments of the present invention, a computer-readable storage medium is also provided, in which a computer program for implementing the above method steps is stored when the computer program is executed by a processor.
The invention has the following beneficial technical effects: the consistency verification of a plurality of copy storage volumes is realized by brushing the cache data of the main storage volume under the database server side and replacing the mapping relation of the main storage volume with the copy storage volume, so that the reliability and the efficiency of the data consistency verification of the copy storage volume are improved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other embodiments can be obtained by using the drawings without creative efforts.
FIG. 1 is a schematic diagram of an embodiment of a method for checking consistency of multiple storage volume copies according to the present invention;
fig. 2 is a schematic hardware structural diagram of an embodiment of a method for checking copy consistency of multiple storage volumes according to the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the following embodiments of the present invention are described in further detail with reference to the accompanying drawings.
It should be noted that all expressions using "first" and "second" in the embodiments of the present invention are used for distinguishing two entities with the same name but different names or different parameters, and it should be noted that "first" and "second" are merely for convenience of description and should not be construed as limitations of the embodiments of the present invention, and they are not described in any more detail in the following embodiments.
In view of the foregoing, a first aspect of the embodiments of the present invention provides an embodiment of a method for checking consistency of multiple storage volume copies. FIG. 1 is a schematic diagram illustrating an embodiment of a method for checking consistency of multiple storage volume copies according to the present invention. As shown in fig. 1, the embodiment of the present invention includes the following steps:
s1, respectively creating a first storage pool and a second storage pool;
s2, creating a plurality of primary storage volumes in a first storage pool, creating a plurality of copy storage volumes with the same number as the primary storage volumes in a second storage pool, and mapping the plurality of primary storage volumes to a database server;
s3, writing corresponding data into a plurality of main storage volumes and recording the data in a database default table;
s4, copying the data in the main storage volumes to a plurality of corresponding copy storage volumes, and mapping the data to a database server by using the copy storage volumes to replace the main storage volumes; and
and S5, judging whether the data of the database is changed or not based on the new mapping relation and the default table of the database.
A first storage pool and a second storage pool are created separately. Two RAID (redundant array of independent disks) groups or pools are created on the storage side, respectively: r1, R2, others are default configurations. R1 is referred to in this embodiment as the first storage pool and R2 is referred to as the second storage pool.
A plurality of primary storage volumes are created in a first storage pool, a plurality of copy storage volumes as many as the number of primary storage volumes are created in a second storage pool, and the plurality of primary storage volumes are mapped to a database server. This embodiment will be described by taking 7 volumes as an example. 7 LUNs (primary storage volumes) of 10G capacity can be created on the first storage pool: LUN1 to LUN7, the primary storage volume is mapped to the database server, and 7 copy storage volumes with 10G capacity are created on the second storage pool: LUN1 'to LUN 7'.
In some embodiments, said mapping a plurality of said primary storage volumes to a database server comprises: scanning the database server to identify a plurality of the primary storage volumes mapped to the database server. A primary storage volume mapped to a database server may be identified by executing a scan script.
In some embodiments, said mapping a plurality of said primary storage volumes to a database server further comprises: and formatting the main storage volumes into a file system which can be directly called by a database, and mounting the formatted main storage volumes to a specified directory. The primary storage volume may be formatted as an ext4 file system that the database may call directly and mount the formatted storage volume to a designated directory.
Corresponding data is written to a plurality of primary storage volumes and the data is recorded in a database default table. In some embodiments, said writing corresponding data to a plurality of said primary storage volumes comprises: and configuring a plurality of main storage volumes into a table space, and writing corresponding data into the table space. Installing a database on a database server, wherein 7 main storage volumes are respectively used as a system table space, a temporary table space, a tool table space, a user table space, a data table space, an index table space and a rollback table space; and performing operations such as inserting, searching, modifying and the like aiming at the default table of the database, and closing the database after the operations are completed.
The method includes copying a full amount of data in a plurality of primary storage volumes to a corresponding plurality of copy storage volumes, and mapping to a database server with the copy storage volumes in place of the primary storage volumes. In some embodiments, the mapping to the database server in place of the primary storage volume with the copy storage volume comprises: the mapping between the plurality of primary storage volumes and the database server is broken, the plurality of copy storage volumes are mapped to the database server, and the tablespace is reconfigured on the database server to the plurality of copy storage volumes. And the mapping between LUN 1-LUN 7 and the database server is disconnected, LUN1 '-LUN 7' is mapped to the database server, and the tablespace of the database is reconfigured to LUN1 '-LUN 7' on the database server. Data of LUN 1-LUN 7 in the cache of the database server can be printed on the tested device, and then the data of LUN 1-LUN 7 are respectively copied to LUN1 '-LUN 7' in full.
And judging whether the data of the database is changed or not based on the new mapping relation and the default table of the database. And restarting the database, and performing query operation aiming at the default table of the database to verify whether the database data is consistent with the original data, so that whether the data copied by the plurality of volumes is consistent can be simultaneously verified. For example, a database startup is normal and the table data is complete, the volume copy data can be considered consistent.
It should be particularly noted that, the steps in the embodiments of the method for checking consistency of multiple storage volume copies described above may be interleaved, replaced, added, or deleted, and therefore, these methods for checking consistency of multiple storage volume copies, which are reasonable permutations and combinations, should also fall within the scope of the present invention, and should not limit the scope of the present invention to the embodiments.
In view of the above object, a second aspect of the embodiments of the present invention provides a system for checking consistency of multiple storage volume copies, including: a storage module configured to create a first storage pool and a second storage pool, respectively; a creation module configured to create a plurality of primary storage volumes in the first storage pool, create a plurality of copy storage volumes in the same number as the primary storage volumes in the second storage pool, and map the plurality of primary storage volumes to a database server; the data module is configured to write corresponding data into the plurality of main storage volumes and record the data in a database default table; a mapping module configured to copy a total amount of data in the plurality of primary storage volumes to a corresponding plurality of copy storage volumes, and map the data to the database server using the copy storage volumes instead of the primary storage volumes; and the judging module is configured for judging whether the data of the database is changed or not based on the new mapping relation and the default table of the database.
In some embodiments, the data module is further configured to: and configuring a plurality of main storage volumes into a table space, and writing corresponding data into the table space.
In some embodiments, the mapping module is further configured to: the mapping between the plurality of primary storage volumes and the database server is broken, the plurality of copy storage volumes are mapped to the database server, and the tablespace is reconfigured on the database server to the plurality of copy storage volumes.
In some embodiments, the creation module is further configured to: scanning the database server to identify a plurality of the primary storage volumes mapped to the database server.
In some embodiments, the creation module is further configured to: and formatting the main storage volumes into a file system which can be directly called by a database, and mounting the formatted main storage volumes to a specified directory.
In view of the above object, a third aspect of the embodiments of the present invention provides a computer device, including: at least one processor; and a memory storing computer instructions executable on the processor, the instructions being executable by the processor to perform the steps of: s1, respectively creating a first storage pool and a second storage pool; s2, creating a plurality of primary storage volumes in a first storage pool, creating a plurality of copy storage volumes with the same number as the primary storage volumes in a second storage pool, and mapping the plurality of primary storage volumes to a database server; s3, writing corresponding data into a plurality of main storage volumes and recording the data in a database default table; s4, copying the data in the main storage volumes to a plurality of corresponding copy storage volumes, and mapping the data to a database server by using the copy storage volumes to replace the main storage volumes; and S5, judging whether the data of the database is changed based on the new mapping relation and the default table of the database.
In some embodiments, said writing corresponding data to a plurality of said primary storage volumes comprises: and configuring a plurality of main storage volumes into a table space, and writing corresponding data into the table space.
In some embodiments, the mapping to the database server in place of the primary storage volume with the copy storage volume comprises: the mapping between the plurality of primary storage volumes and the database server is broken, the plurality of copy storage volumes are mapped to the database server, and the tablespace is reconfigured on the database server to the plurality of copy storage volumes.
In some embodiments, said mapping a plurality of said primary storage volumes to a database server comprises: scanning the database server to identify a plurality of the primary storage volumes mapped to the database server.
In some embodiments, said mapping a plurality of said primary storage volumes to a database server further comprises: and formatting the main storage volumes into a file system which can be directly called by a database, and mounting the formatted main storage volumes to a specified directory.
Fig. 2 is a schematic hardware structural diagram of an embodiment of the method for checking the copy consistency of multiple storage volumes according to the present invention.
Taking the apparatus shown in fig. 2 as an example, the apparatus includes a processor 301 and a memory 302, and may further include: an input device 303 and an output device 304.
The processor 301, the memory 302, the input device 303 and the output device 304 may be connected by a bus or other means, and fig. 2 illustrates the connection by a bus as an example.
The memory 302 is a non-volatile computer-readable storage medium and can be used for storing non-volatile software programs, non-volatile computer-executable programs, and modules, such as program instructions/modules corresponding to the method for verifying the consistency of multiple storage volume copies in the embodiment of the present application. The processor 301 executes various functional applications and data processing of the server by running nonvolatile software programs, instructions and modules stored in the memory 302, namely, implements the method for checking consistency of multiple storage volume copies of the above method embodiment.
The memory 302 may include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function; the storage data area may store data created according to the use of a method of verifying the consistency of the multiple storage volume copies, and the like. Further, the memory 302 may include high speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid state storage device. In some embodiments, memory 302 optionally includes memory located remotely from processor 301, which may be connected to a local module via a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The input device 303 may receive information such as a user name and a password that are input. The output means 304 may comprise a display device such as a display screen.
Program instructions/modules corresponding to one or more methods of verifying consistency of multiple storage volume copies are stored in memory 302 and, when executed by processor 301, perform the method of verifying consistency of multiple storage volume copies of any of the above-described method embodiments.
Any embodiment of the computer device executing the method for checking the copy consistency of the multi-storage volume can achieve the same or similar effects as any corresponding embodiment of the method.
The invention also provides a computer readable storage medium storing a computer program which, when executed by a processor, performs the method as above.
Finally, it should be noted that, as one of ordinary skill in the art can appreciate that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program to instruct related hardware, and the program of the method for checking the consistency of the copies of the multiple storage volumes can be stored in a computer readable storage medium, and when executed, the program can include the processes of the embodiments of the methods described above. The storage medium of the program may be a magnetic disk, an optical disk, a Read Only Memory (ROM), a Random Access Memory (RAM), or the like. The embodiments of the computer program may achieve the same or similar effects as any of the above-described method embodiments.
Furthermore, the methods disclosed according to embodiments of the present invention may also be implemented as a computer program executed by a processor, which may be stored in a computer-readable storage medium. Which when executed by a processor performs the above-described functions defined in the methods disclosed in embodiments of the invention.
Further, the above method steps and system elements may also be implemented using a controller and a computer readable storage medium for storing a computer program for causing the controller to implement the functions of the above steps or elements.
Further, it should be appreciated that the computer-readable storage media (e.g., memory) herein can be either volatile memory or nonvolatile memory, or can include both volatile and nonvolatile memory. By way of example, and not limitation, nonvolatile memory can include Read Only Memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM), which can act as external cache memory. By way of example and not limitation, RAM is available in a variety of forms such as synchronous RAM (DRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), and Direct Rambus RAM (DRRAM). The storage devices of the disclosed aspects are intended to comprise, without being limited to, these and other suitable types of memory.
Those of skill would further appreciate that the various illustrative logical blocks, modules, circuits, and algorithm steps described in connection with the disclosure herein may be implemented as electronic hardware, computer software, or combinations of both. To clearly illustrate this interchangeability of hardware and software, various illustrative components, blocks, modules, circuits, and steps have been described above generally in terms of their functionality. Whether such functionality is implemented as software or hardware depends upon the particular application and design constraints imposed on the overall system. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the disclosed embodiments of the present invention.
The various illustrative logical blocks, modules, and circuits described in connection with the disclosure herein may be implemented or performed with the following components designed to perform the functions herein: a general purpose processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other programmable logic device, discrete gate or transistor logic, discrete hardware components, or any combination of these components. A general purpose processor may be a microprocessor, but in the alternative, the processor may be any conventional processor, controller, microcontroller, or state machine. A processor may also be implemented as a combination of computing devices, e.g., a combination of a DSP and a microprocessor, a plurality of microprocessors, one or more microprocessors in conjunction with a DSP, and/or any other such configuration.
The steps of a method or algorithm described in connection with the disclosure herein may be embodied directly in hardware, in a software module executed by a processor, or in a combination of the two. A software module may reside in RAM memory, flash memory, ROM memory, EPROM memory, EEPROM memory, registers, hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art. An exemplary storage medium is coupled to the processor such the processor can read information from, and write information to, the storage medium. In the alternative, the storage medium may be integral to the processor. The processor and the storage medium may reside in an ASIC. The ASIC may reside in a user terminal. In the alternative, the processor and the storage medium may reside as discrete components in a user terminal.
In one or more exemplary designs, the functions may be implemented in hardware, software, firmware, or any combination thereof. If implemented in software, the functions may be stored on or transmitted over as one or more instructions or code on a computer-readable medium. Computer-readable media includes both computer storage media and communication media including any medium that facilitates transfer of a computer program from one place to another. A storage media may be any available media that can be accessed by a general purpose or special purpose computer. By way of example, and not limitation, such computer-readable media can comprise RAM, ROM, EEPROM, CD-ROM or other optical disk storage, magnetic disk storage or other magnetic storage devices, or any other medium that can be used to carry or store desired program code in the form of instructions or data structures and that can be accessed by a general-purpose or special-purpose computer, or a general-purpose or special-purpose processor. Also, any connection is properly termed a computer-readable medium. For example, if the software is transmitted from a website, server, or other remote source using a coaxial cable, fiber optic cable, twisted pair, Digital Subscriber Line (DSL), or wireless technologies such as infrared, radio, and microwave, then the coaxial cable, fiber optic cable, twisted pair, DSL, or wireless technologies such as infrared, radio, and microwave are included in the definition of medium. Disk and disc, as used herein, includes Compact Disc (CD), laser disc, optical disc, Digital Versatile Disc (DVD), floppy disk, blu-ray disc where disks usually reproduce data magnetically, while discs reproduce data optically with lasers. Combinations of the above should also be included within the scope of computer-readable media.
The foregoing is an exemplary embodiment of the present disclosure, but it should be noted that various changes and modifications could be made herein without departing from the scope of the present disclosure as defined by the appended claims. The functions, steps and/or actions of the method claims in accordance with the disclosed embodiments described herein need not be performed in any particular order. Furthermore, although elements of the disclosed embodiments of the invention may be described or claimed in the singular, the plural is contemplated unless limitation to the singular is explicitly stated.
It should be understood that, as used herein, the singular forms "a", "an" and "the" are intended to include the plural forms as well, unless the context clearly supports the exception. It should also be understood that "and/or" as used herein is meant to include any and all possible combinations of one or more of the associated listed items.
The numbers of the embodiments disclosed in the embodiments of the present invention are merely for description, and do not represent the merits of the embodiments.
It will be understood by those skilled in the art that all or part of the steps for implementing the above embodiments may be implemented by hardware, or may be implemented by a program instructing relevant hardware, and the program may be stored in a computer-readable storage medium, and the above-mentioned storage medium may be a read-only memory, a magnetic disk or an optical disk, etc.
Those of ordinary skill in the art will understand that: the discussion of any embodiment above is meant to be exemplary only, and is not intended to intimate that the scope of the disclosure, including the claims, of embodiments of the invention is limited to these examples; within the idea of an embodiment of the invention, also technical features in the above embodiment or in different embodiments may be combined and there are many other variations of the different aspects of the embodiments of the invention as described above, which are not provided in detail for the sake of brevity. Therefore, any omissions, modifications, substitutions, improvements, and the like that may be made without departing from the spirit and principles of the embodiments of the present invention are intended to be included within the scope of the embodiments of the present invention.
Claims (10)
1. A method for checking the copy consistency of a plurality of storage volumes is characterized by comprising the following steps:
respectively creating a first storage pool and a second storage pool;
creating a plurality of primary storage volumes in the first storage pool, creating a plurality of copy storage volumes in the second storage pool in the same number as the primary storage volumes, and mapping the plurality of primary storage volumes to a database server;
writing corresponding data into a plurality of main storage volumes, and recording the data in a database default table;
copying the data in the plurality of the primary storage volumes to a corresponding plurality of the copy storage volumes, and mapping the data to the database server by using the copy storage volumes to replace the primary storage volumes; and
and judging whether the data of the database is changed or not based on the new mapping relation and the default table of the database.
2. The method of claim 1, wherein writing corresponding data to a plurality of the primary storage volumes comprises:
and configuring a plurality of main storage volumes into a table space, and writing corresponding data into the table space.
3. The method of claim 2, wherein the mapping to the database server in place of the primary storage volume with the copy storage volume comprises:
the mapping between the plurality of primary storage volumes and the database server is broken, the plurality of copy storage volumes are mapped to the database server, and the tablespace is reconfigured on the database server to the plurality of copy storage volumes.
4. The method of claim 1, wherein mapping the plurality of primary storage volumes to a database server comprises:
scanning the database server to identify a plurality of the primary storage volumes mapped to the database server.
5. The method of claim 1, wherein mapping the plurality of primary storage volumes to a database server further comprises:
and formatting the main storage volumes into a file system which can be directly called by a database, and mounting the formatted main storage volumes to a specified directory.
6. A system for verifying consistency of multiple storage volume copies, comprising:
a storage module configured to create a first storage pool and a second storage pool, respectively;
a creation module configured to create a plurality of primary storage volumes in the first storage pool, create a plurality of copy storage volumes in the same number as the primary storage volumes in the second storage pool, and map the plurality of primary storage volumes to a database server;
the data module is configured to write corresponding data into the plurality of main storage volumes and record the data in a database default table;
a mapping module configured to copy a total amount of data in the plurality of primary storage volumes to a corresponding plurality of copy storage volumes, and map the data to the database server using the copy storage volumes instead of the primary storage volumes; and
and the judging module is configured for judging whether the data of the database is changed or not based on the new mapping relation and the default table of the database.
7. The system of claim 6, wherein the data module is further configured to:
and configuring a plurality of main storage volumes into a table space, and writing corresponding data into the table space.
8. The system of claim 7, wherein the mapping module is further configured to:
the mapping between the plurality of primary storage volumes and the database server is broken, the plurality of copy storage volumes are mapped to the database server, and the tablespace is reconfigured on the database server to the plurality of copy storage volumes.
9. A computer device, comprising:
at least one processor; and
a memory storing computer instructions executable on the processor, the instructions when executed by the processor implementing the steps of the method of any one of claims 1 to 5.
10. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out the steps of the method according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010026534.7A CN111259020A (en) | 2020-01-10 | 2020-01-10 | Method, system, equipment and medium for checking multi-storage-volume copy consistency |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010026534.7A CN111259020A (en) | 2020-01-10 | 2020-01-10 | Method, system, equipment and medium for checking multi-storage-volume copy consistency |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111259020A true CN111259020A (en) | 2020-06-09 |
Family
ID=70952803
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010026534.7A Withdrawn CN111259020A (en) | 2020-01-10 | 2020-01-10 | Method, system, equipment and medium for checking multi-storage-volume copy consistency |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111259020A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111966288A (en) * | 2020-08-07 | 2020-11-20 | 苏州浪潮智能科技有限公司 | Method, system, device and medium for cleaning storage pool |
| WO2022151856A1 (en) * | 2021-01-13 | 2022-07-21 | 苏州浪潮智能科技有限公司 | Online takeover method and system for heterogeneous storage volumes, device, and medium |
-
2020
- 2020-01-10 CN CN202010026534.7A patent/CN111259020A/en not_active Withdrawn
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111966288A (en) * | 2020-08-07 | 2020-11-20 | 苏州浪潮智能科技有限公司 | Method, system, device and medium for cleaning storage pool |
| CN111966288B (en) * | 2020-08-07 | 2022-08-09 | 苏州浪潮智能科技有限公司 | Method, system, device and medium for cleaning storage pool |
| WO2022151856A1 (en) * | 2021-01-13 | 2022-07-21 | 苏州浪潮智能科技有限公司 | Online takeover method and system for heterogeneous storage volumes, device, and medium |
| US11972131B2 (en) | 2021-01-13 | 2024-04-30 | Inspur Suzhou Intelligent Technology Co., Ltd. | Online takeover method and system for heterogeneous storage volume, device, and medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20220413706A1 (en) | Data Storage Method, Apparatus and Storage System | |
| US7487385B2 (en) | Apparatus and method for recovering destroyed data volumes | |
| CN102929750A (en) | Nonvolatile media dirty region tracking | |
| CN107193871B (en) | Database recovering method and device | |
| KR20070003579A (en) | File system storing transaction recordes in flash-like media | |
| CN111090545B (en) | Method, device and medium for recovering failed CPLD | |
| JP2007012056A (en) | File system having authentication of postponed data integrity | |
| CN111240595A (en) | Method, system, equipment and medium for optimizing storage cache | |
| JP2007012054A (en) | Startup authentication of optimized file system integrity | |
| CN107766374B (en) | Optimization method and system for storage and reading of massive small files | |
| CN111045603A (en) | Bad block replacement method and device for solid state disk | |
| CN111581126A (en) | Method, device, equipment and medium for saving log data based on SSD | |
| CN111522702A (en) | Nonvolatile memory bandwidth detection method, device, equipment and readable medium | |
| CN111259020A (en) | Method, system, equipment and medium for checking multi-storage-volume copy consistency | |
| CN111338852A (en) | Method, system, equipment and medium for creating storage double live volume snapshot | |
| CN111857572A (en) | Data writing method, device and equipment of TLC solid state disk and storage medium | |
| CN111813346A (en) | Method, system, device and medium for establishing Ceph distributed storage based on cloud platform | |
| CN105630688A (en) | Aggregate file storage method and system as well as aggregate file compression method and system | |
| WO2022105442A1 (en) | Erasure code-based data reconstruction method and appratus, device, and storage medium | |
| CN103544254B (en) | A kind of data managing method and device | |
| CN111444114A (en) | Method, device and system for processing data in nonvolatile memory | |
| WO2021056798A1 (en) | Metadata repairing method, apparatus and device, and storage medium | |
| CN111737047A (en) | Volume synchronous remote copying method, device, equipment and readable medium | |
| CN111427756B (en) | Method, system, equipment and medium for carrying out mixed pressure test on single hard disk | |
| CN111309264A (en) | Method, system, device and medium for making directory quota compatible with snapshot |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20200609 |
|
| WW01 | Invention patent application withdrawn after publication |