CN109241036A

CN109241036A - A kind of migratory system and moving method of physical data

Info

Publication number: CN109241036A
Application number: CN201810987616.0A
Authority: CN
Inventors: 贾伟; 郭锋
Original assignee: Zhengzhou Yunhai Information Technology Co Ltd
Current assignee: Zhengzhou Yunhai Information Technology Co Ltd
Priority date: 2018-08-28
Filing date: 2018-08-28
Publication date: 2019-01-18

Abstract

The invention discloses a kind of migratory system of physical data and methods, comprising: the identical physical disk of multiple interface types, and identical database is mounted in each physical disk, identical database table is mounted in each database；Each physical disk is used to continue the physical data of storage server；Each physical disk, which marks, label, when being migrated in order to the physical data to the server, the physical disk that the physical data of migration in need is stored by the default label lookup, the physical disk of the physical data for the storage migration in need of choosing.The migratory system and moving method of physical data provided by the present invention, improve the efficiency of Data Migration.

Description

A kind of migratory system and moving method of physical data

Technical field

The present invention relates to server admin technical fields, migratory system and migration side more particularly to a kind of physical data Method.

Background technique

With the development of technology, the rise of big data, artificial intelligence, data volume be it is increasing, had reached surprising TB, PB, and the migration of the data of database save it is difficult, such as: due to data volume cause greatly Data Migration speed it is slow, Data Migration the problems such as time-consuming.

In summary as can be seen that the transport efficiency for how providing Data Migration is current problem to be solved.

Summary of the invention

The object of the present invention is to provide a kind of migratory system of physical data and methods, are moved with solving data in the prior art Move the problem of speed is slow, time-consuming.

In order to solve the above technical problems, the present invention provides a kind of migratory system of physical data, comprising: multiple interface types Identical physical disk, and identical database is mounted in each physical disk, it is mounted in each database identical Database table；Each physical disk is used to continue the physical data of storage server；Each physical disk is marked Note has default label, and when migrating in order to the physical data to the server, being stored with by the default label lookup is needed The physical disk for the physical data to be migrated, the physical disk of the physical data for the storage migration in need of choosing.

Preferably, each physical disk is specifically used for:

When the data storage capacity of present physical disk has reached default memory capacity, choose it is any have it is remaining can memory capacity Physical disk is docked with the present physical disk, in order to the lasting storage physical data.

Preferably, each physical disk marks and has, in order to need the physics to the server When Data Migration, the physical disk for storing the physical data of migration in need is determined by the time tag, described deposit of choosing Contain the physical disk for needing the physical data migrated.

It preferably, include time field in the database table.

Preferably, the database table of establishing includes:

Create initial data base table；After the primary key and the constraint condition that determine the database table, the number is checked and modified According to the structure of library table, to determine target database table.

Preferably, the interface type of the physical disk is scsi interface.

The present invention also provides a kind of moving methods of physical data, comprising:

The physical data of server is persistently stored in multiple physical disks of interface type having the same；It is described each Physical disk is mounted on same database, and foundation has identical database table in database；Using default label to described Each physical disk is marked, and when migrating in order to the physical data to the server, passes through the default label lookup The physical disk for storing the physical data of migration in need, the physics magnetic of the physical data for the storage migration in need of choosing Disk.

Preferably, the physical data by server is persistently stored in multiple physics magnetic of interface type having the same Disk includes:

Preferably, each physical disk is marked using default label and includes:

It is marked using each physical disk described in time tag, in order to need the physical data to the server When migration, the physical disk for storing the physical data of migration in need is determined by the time tag, described be stored with of choosing The physical disk for the physical data for needing to migrate.

Preferably, the database table of establishing includes:

The migratory system of physical data provided by the present invention, including the identical physical disk of multiple interface types, and it is each It is mounted on identical database in a physical disk, identical database table is installed in each database, thus entity pair The lasting storage of the physical data of server.The label that each physical disk marks, in order to need to institute When stating physical data and being migrated, the physical disk of the physical data of migration in need is stored according to the label lookup, is chosen The physical disk of the physical data of the storage migration in need.The migratory system of physical data provided by the present invention, evades The data copy and migration of software view carries out Data Migration using the method that whole consolidation takes, improves moving for physical data Speed is moved, the time needed for reducing Data Migration improves the efficiency of Data Migration；And migration system provided by the present invention System can also avoid passing through data copy and carry out the problem that time-consuming, error-prone when Data Migration.

Detailed description of the invention

It, below will be to embodiment or existing for the clearer technical solution for illustrating the embodiment of the present invention or the prior art Attached drawing needed in technical description is briefly described, it should be apparent that, the accompanying drawings in the following description is only this hair Bright some embodiments for those of ordinary skill in the art without creative efforts, can be with root Other attached drawings are obtained according to these attached drawings.

Fig. 1 is a kind of structure chart of the migratory system of physical data provided by the present invention；

Fig. 2 is a kind of flow chart of specific embodiment of the moving method of physical data provided by the present invention.

Specific embodiment

Core of the invention is to provide the migratory system and method for a kind of physical data, improves the efficiency of Data Migration.

In order to enable those skilled in the art to better understand the solution of the present invention, with reference to the accompanying drawings and detailed description The present invention is described in further detail.Obviously, described embodiments are only a part of the embodiments of the present invention, rather than Whole embodiments.Based on the embodiments of the present invention, those of ordinary skill in the art are not making creative work premise Under every other embodiment obtained, shall fall within the protection scope of the present invention.

Referring to FIG. 1, Fig. 1 is a kind of structure chart of the migratory system of physical data provided by the present invention.The present embodiment The migratory system of provided physical data includes the identical physical disk of multiple interface types, and is pacified in each physical disk Equipped with identical database, identical database table is mounted in each database.

In the present embodiment, the capacity of each physical disk is not defined.The migration of the physical data In system, the capacity of each physical disk can be different, may be set to be it is identical can memory capacity physical disk.

Using the physical data of the physical disk storage server, if the data in magnetic disk that present physical disk has reached When amount of storage has reached default memory capacity, choose it is any have it is remaining can memory capacity physical disk and the present physical disk Docking, in order to the lasting storage physical data.It can specify that the quantity amount of storage in physical disk has reached total storage and holds The default accounting of amount, such as when 90 percent, 95 percent, physical data no longer is stored into the physical disk.? Can be when the data storage capacity in physical disk reach the maximum storage capacity of the physical disk, selection is any to have residue that can deposit The physical disk of storage capacity is docked with the present physical disk.

In the present embodiment, each physical disk, which marks, label, in order to the object to the server When managing Data Migration, the physical disk of the physical data of migration in need is stored by the default label lookup, is chosen described Store the physical disk of the physical data of migration in need.

Each physical disk can be marked by time tag, in order to need the object to the server When managing Data Migration, the physical disk for storing the physical data of migration in need is determined by the time tag, is chosen described Store the physical disk of the physical data of migration in need.Each physical disk is marked using the time disk When, it include time field in the database table in physical disk.Each physical disk can also be encoded, using to service The sequencing that the physical data of device is stored, is marked.

In the database table established in each physical disk, initial data base table is created first；Then the number is determined After the primary key and constraint condition of library table, the structure of the database table is checked and modifies, to determine target database table.

There are many kinds of the interface types of physical disk, such as: IDE, SATA, SCSI, optical-fibre channel and five kinds of SAS.IDE connects Mouth hard disk is chiefly used in household products, and also certain applications are then mainly used in server city in server, the hard disk of scsi interface , and optical-fibre channel is in high-end server, it is expensive.SATA is kind of a newborn hard-disk interface type, is also in city The field stage of popularization, there is extensive prospect in household application market.Under the big classification of IDE and SCSI, and a variety of tools can be separated The interface type of body, and respectively possess different technical specifications, have different transmission speeds, such as ATA100 and SATA； Ultra160SCSI and Ultra320SCSI represents a kind of specific hard-disk interface, and respective speed difference is also larger.

Have a wide range of application since scsi interface has, multitask, with roomy, CPU usage be low and hot plug etc. is excellent Point can choose the interface of each physical disk in migratory system of the scsi interface as the physical data in the present embodiment Type.

In the present embodiment, each physical disk can be basic disk, or dynamic disk.Due to basic Disk is easily managed, therefore in the present embodiment, sets basic disk for the physical disk.Basic disk may include up to Four main partitions or three main partitions add the extension subregion with multiple logical drives.

The migratory system of physical data provided by the present embodiment has been evaded the data copy migration of software view, has been passed through The physical data of multiple physical disk storage servers, when needing to migrate physical data, according to each physical disk The label lookup physical disk that needs the physical data that migrates to be stored, choose the physical disk directly to reach physics number According to migration, solve that when realizing physical data migration by copy to physical data in the prior art, it is error-prone that time-consuming The problems such as；Data Migration is realized using the thought taken to the whole consolidation of physical disk, improves the efficiency of Data Migration and can be performed Property.

Referring to FIG. 2, Fig. 2 is a kind of process of specific embodiment of the moving method of physical data provided by the present invention Figure；Specific steps are as follows:

Step S201: the physical data of server is persistently stored in multiple physics magnetic of interface type having the same Disk；Each physical disk is mounted on same database, and foundation has identical database table in database；

Step S202: each physical disk is marked using default label, in order to the server When physical data migrates, the physical disk of the physical data of migration in need is stored by the default label lookup, institute of choosing State the physical disk for storing the physical data of migration in need.

The moving method of the physical data of the present embodiment moves for realizing data in the migratory system of physical data above-mentioned It moves and operates, therefore the moving method of the visible physical data hereinbefore of specific embodiment in the moving method of physical data Embodiment part, details are not described herein.

Each embodiment in this specification is described in a progressive manner, the highlights of each of the examples are with it is other The difference of embodiment, same or similar part may refer to each other between each embodiment.For being filled disclosed in embodiment For setting, since it is corresponded to the methods disclosed in the examples, so being described relatively simple, related place is referring to method part Explanation.

The migratory system and method for physical data provided by the present invention are described in detail above.It answers herein With a specific example illustrates the principle and implementation of the invention, the explanation of above example is only intended to help to manage Solve method and its core concept of the invention.It should be pointed out that for those skilled in the art, not departing from , can be with several improvements and modifications are made to the present invention under the premise of the principle of the invention, these improvement and modification also fall into this hair In bright scope of protection of the claims.

Claims

1. a migration system of physical data, is characterized in that, comprises:

Multiple physical disks with the same interface type, and each physical disk is installed with the same database, and each database is installed with the same database table; the physical disks are used to continuously store the physical data of the server;

Each of the physical disks is marked with a preset label, so that when migrating the physical data of the server, the physical disk that stores the physical data that needs to be migrated is searched through the preset label, and the storage that needs to be migrated is extracted. Physical disk for physical data.

2. The migration system according to claim 1, wherein each physical disk is specifically used for:

When the data storage capacity of the current physical disk has reached the preset storage capacity, any physical disk with remaining storable capacity is selected to be connected to the current physical disk, so as to continuously store the physical data.

3. The migration system according to claim 2, wherein each physical disk is marked with a time stamp, so that when the physical data of the server needs to be migrated, it is determined by the time stamp that the storage needs to be migrated. For the physical disk of the physical data, extract the physical disk that stores the physical data that needs to be migrated.

4. The migration system of claim 3, wherein the database table includes a time field.

5. The migration system according to claim 1, wherein the establishing a database table comprises:

Create initial database tables;

After determining the main code and constraint conditions of the database table, check and modify the structure of the database table, so as to determine the target database table.

6. The migration system according to claim 1, wherein the interface type of the physical disk is a SCSI interface.

7. A method for migrating physical data, comprising:

The physical data of the server is continuously stored in multiple physical disks with the same interface type; the physical disks are installed with the same database, and the same database table is established in the database;

The physical disks are marked with preset labels, so that when the physical data of the server is migrated, the physical disks that store the physical data that need to be migrated can be searched for through the preset labels, and the physical disks that need to be migrated can be extracted from the storage. The physical disk of the physical data.

8. The migration method according to claim 7, wherein the continuously storing the physical data of the server on multiple physical disks with the same interface type comprises:

9 . The migration method according to claim 8 , wherein marking the respective physical disks with a preset label comprises: 10 .

Each physical disk is marked with a time stamp, so that when the physical data of the server needs to be migrated, the physical disk storing the physical data to be migrated is determined by the time stamp, and the physical disk storing the physical data that needs to be migrated is extracted. Physical disk for data.

10. The migration method of claim 7, wherein the establishing a database table comprises:

Create initial database tables;