CN110427383A - Mysql cluster online data redistribution method and relevant device based on data redundancy - Google Patents
Mysql cluster online data redistribution method and relevant device based on data redundancy Download PDFInfo
- Publication number
- CN110427383A CN110427383A CN201910395268.2A CN201910395268A CN110427383A CN 110427383 A CN110427383 A CN 110427383A CN 201910395268 A CN201910395268 A CN 201910395268A CN 110427383 A CN110427383 A CN 110427383A
- Authority
- CN
- China
- Prior art keywords
- data
- copy
- data copy
- master
- master data
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1448—Management of the data involved in backup or backup restore
-
- 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
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Computer Security & Cryptography (AREA)
- Computing Systems (AREA)
- Quality & Reliability (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of mysql cluster online data redistribution method and relevant device based on data redundancy.The described method includes: receiving fast resampling request;It is requested according to the fast resampling by the first master data copy in first node, the first change application interruption synchronous for the data between data copy;Table space file is generated for the physical table space export of data copy by described first, the table space file is individually copied to the second master data copy of second node, second for data copy;Storage is to the incremental data difference increment synchronization in the first master data copy to the second master data copy, described second for data copy after the synchronous change application of data is interrupted.The method of the invention splices conversion without carrying out complicated sql, guarantees the data consistency of migration, while improving the efficiency of fast resampling.
Description
Technical field
The present invention relates to fields of communication technology, particularly relate to a kind of mysql cluster online data weight based on data redundancy
Location mode and relevant device.
Background technique
MySQL database cluster can carry out data storage comprising multiple mysql back end, when cluster needs to add newly
When node, it is necessary to carry out the online redistribution of data.The algorithm realization of common fast resampling has consistency HASH
With virtual map table etc., for solving how to carry out the redistribution of online data, i.e. which part data needs are moved from which node
Which node is moved, but current data move and generally use the mode of logic and carry out, as shown in Figure 1, looking into first by SQL
It askes the data to be moved of acquisition to copy logical data full dose, is then inserted into destination node in such a way that insert is inserted into
On, finally incremental data is extracted and is imported on destination node.
Data are carried out by way of logic moves main following points deficiency:
1. efficiency is lower.Because the process of logic needs first to check out data, this process is inherently
Mysql data store internal converts the data stored on disk to the process of readable text data, and there are the expenses of conversion;
Then splicing insert sentence needs to consume a large amount of cpu resource;Be finally inserted equally is to need mysql handle to the target phase
Readable text data is then converted to disk storage format and is stored, the process also need to generate additional transaction journal and
Binlog log expense.
2. data text conversion process is complicated, it is difficult to guarantee consistency.Splicing insert sentence process needs to consider character
Collection, spcial character, the translation binary data such as character and blob;Realization process is extremely complex and is easy to appear omission.It needs
It adds complicated check logic and checks the consistency that data are moved, this equally further decreases performance.
Summary of the invention
In view of this, the purpose of the embodiment of the present invention is to propose a kind of mysql cluster based on data redundancy in line number
According to redistribution method and relevant device, splices conversion without carrying out complicated sql, guarantee the data consistency of migration, mention simultaneously
The efficiency of high fast resampling.
Based on a kind of above-mentioned purpose mysql cluster online data weight based on data redundancy provided in an embodiment of the present invention
Location mode, comprising:
Receive fast resampling request;
According to the fast resampling request by first node the first master data copy, first for data copy it
Between the synchronous change application of data interrupt;
Table space file is generated for the physical table space export of data copy by described first, by the table space file
It is individually copied to the second master data copy of second node, second for data copy;
Storage after the synchronous disconnection of data is distinguished increment synchronization to the incremental data in the first master data copy to arrive
The second master data copy, described second are for data copy.
Optionally, the first master data copy by first node, first synchronize for data between data copy
While change application is interrupted, retain the synchronous synchronization log of data.
Optionally, described to store synchronous disconnect of data to the incremental data in the first master data copy point later
Other increment synchronization includes: to obtain number according to the synchronization log for data copy to the second master data copy, described second
The increment of the first master data copy is arrived according to storage during synchronous change application interruption and the table space file copy
The incremental data is synchronized to the second master data copy, described second for data copy by data.
Optionally, the acquisition modes of the incremental data include: by the first master data copy, described first standby
The duplication state conversion of data copy obtains the extraction position of the incremental data, according to the extraction position from described first
Master data copy extracts the incremental data.
Optionally, if the first master data copy breaks down, described first is promoted to for data copy new
First master data copy, specifically includes:
Interrupt the export and generating process of the table space file;
The first master data copy is arrived in storage after being interrupted the synchronous change application of data according to the synchronization log
In incremental data synchronization log be applied to described first for back end;
The first new master data copy is promoted to for back end by described first.
The another aspect of the embodiment of the present invention also provides a kind of mysql cluster online data based on data redundancy and divides again
Cloth apparatus, comprising:
Receiving module, redistribution is requested for receiving data;
Disconnect module, for according to the fast resampling request by first node the first master data copy, first
The change application that data between standby data copy synchronize is interrupted;
Module is copied, for generating table space file for described first for the physical table space export of data copy, by institute
It states table space file and is individually copied to the second master data copy of second node, second for data copy;
Import modul, for storage after interrupting the synchronous change application of data into the first master data copy
Incremental data difference increment synchronization to the second master data copy, described second for data copy.
Optionally, the first master data copy by first node, first synchronize for data between data copy
While change application is interrupted, retain the synchronous synchronization log of data.
Optionally, the import modul is also used to realize: by the first master data copy, described first for data
The duplication state conversion of copy obtains the extraction position of the incremental data, according to the extraction position from the described first main number
The incremental data is extracted according to copy.
A kind of electronic equipment is also provided in terms of the third of the embodiment of the present invention, comprising:
At least one processor;And
The memory being connect at least one described processor communication;Wherein,
The memory is stored with the instruction that can be executed by one processor, described instruction by it is described at least one
Processor execute so that at least one described processor be able to carry out as described in above-mentioned any one based on data redundancy
Mysql cluster online data redistribution method.
4th aspect of the embodiment of the present invention also provides a kind of non-transient computer storage medium, and the computer is deposited
Storage media is stored with computer executable instructions, the executable base as described in above-mentioned any one of the computer executable instructions
In the mysql cluster online data redistribution method of data redundancy.
From the above it can be seen that the mysql cluster online data provided in an embodiment of the present invention based on data redundancy
Redistribution method and relevant device realize Data Migration by standby data copy, that is, redundancy slave node, to the master of primary data node
The performance of data copy is without influence, so that nor affecting on master data copy externally provides service;By first for data copy object
Reason table space, which directly exports, to be generated table space file and copies second node to, and what it is due to progress is the straight of physical data files
Copy is connect, complicated sql splicing conversion is not carried out, copy procedure efficiently avoids complicated data pick-up conversion simultaneously very much
Process and consistency verification of data problem;Meanwhile multiple table space files can copy parallel, maximum speed can make net
Card, greatly improves operational efficiency.
Detailed description of the invention
Fig. 1 is the schematic diagram of fast resampling in the prior art;
Fig. 2 is the process of the mysql cluster online data redistribution method based on data redundancy described in the embodiment of the present invention
Figure;
Fig. 3 is the principle of the mysql cluster online data redistribution method based on data redundancy described in the embodiment of the present invention
Figure;
Fig. 4 is the structure of the mysql cluster online data redistribution device based on data redundancy described in the embodiment of the present invention
Schematic diagram;
Fig. 5 is that the embodiment of the present invention executes the mysql cluster online data redistribution method based on data redundancy
The structure chart of electronic equipment.
Specific embodiment
To make the objectives, technical solutions, and advantages of the present invention clearer, below in conjunction with specific embodiment, and join
According to attached drawing, the present invention is described in more detail.
It should be noted that all statements for using " first " and " second " are for distinguishing in the embodiment of the present invention
Two non-equal entities of same names or non-equal parameter, it is seen that " first " " second " only for statement convenience, no
It is interpreted as the restriction to the embodiment of the present invention, subsequent embodiment no longer illustrates this one by one.
Fig. 2 is the process of the mysql cluster online data redistribution method based on data redundancy described in the embodiment of the present invention
Figure.Fig. 3 is the schematic diagram sheet of the mysql cluster online data redistribution method based on data redundancy described in the embodiment of the present invention
Inventive embodiments provide a kind of mysql cluster online data redistribution method based on data redundancy, comprising:
Step 101, fast resampling request is received.
Step 102, it is requested according to the fast resampling by the first master data copy, the first standby number in first node
It is interrupted according to the synchronous change application of the data between copy.Wherein, the original back end of first node, that is, system, it includes
First master data copy and first for data copy, the first master data copy and first between data copy by synchronizing by force
Guarantee the consistency of data between the two, so as to the first master data copy break down when can be by first for data
Copy is promoted to the first new master data copy, to guarantee the safety of first node data.
Step 103, table space file is generated for the physical table space export of data copy by described first, by the table
Space file is individually copied to the second master data copy of second node, second for data copy.Wherein, second node is
Newly-increased node, newly-increased node can be one, or multiple.It, can be by table space file when newly-increased node is multiple
It is individually copied to master data copy, the standby data copy of all newly-increased nodes.
Step 104, it stores after the synchronous change application of data being interrupted to the increment in the first master data copy
Data distinguish increment synchronization to the second master data copy, described second for data copy.When newly-increased node is multiple,
Master data copy, standby data copy of the storage to all newly-increased nodes after the synchronous change application of data being interrupted.
Mysql cluster online data redistribution method described in the embodiment of the present invention based on data redundancy passes through standby data
Copy, that is, redundancy slave node realizes Data Migration, on the performance of the master data copy of primary data node without influence, thus also not shadow
It rings master data copy and service is externally provided;Generation table space file is directly exported by first for the physical table space of data copy
And copy second node to, due to progress be physical data files direct copying, do not carry out complicated sql splicing and turn
It changes, copy procedure efficiently avoids complicated data pick-up conversion process and consistency verification of data problem simultaneously very much;Meanwhile
Multiple table space files can copy parallel, and maximum speed can make network interface card, greatly improve operational efficiency.
In other embodiments of the invention, described in step 102 by first node the first master data copy,
First for the synchronous change application of data between data copy while interrupt, and retains the synchronous synchronization log of data.It is optional
, the synchronization log be binlog log, binlog log recording other than data query user to database manipulation
SQL statement information.Retain the synchronous synchronization log of data, on the one hand guarantees during fast resampling first for data pair
Originally effective, so that if the first master data copy goes wrong, the first synchronization day that can be synchronized based on data for data copy
Will restores the incremental data generated during the synchronous change application of data is interrupted and is promoted to new master data copy.It is another
Aspect can also be got by the synchronization log of reservation in the synchronous change application interruption of data and table space text
The incremental data that part stores during copying imports second node in order to extract the incremental data.
Optionally, in step 103 when copying table space file, multiple table space file in parallel can be copied, it is maximum
Speed can make network interface card, to greatly improve the efficiency of fast resampling.
Optionally, first master data is arrived in storage after interrupting the synchronous change application of data described in step 104
Increment synchronization to the second master data copy, described second includes: basis for data copy respectively for incremental data in copy
The synchronization log obtain the synchronous change application of data interrupt and the table space file copy during storage to described the
The incremental data is synchronized to the second master data copy, described second for data by the incremental data of one master data copy
Copy.It, can be in the synchronous change application of synchronization log identifying recording layer when the synchronous change application of data is interrupted and disconnected
Incremental data is synchronized to second node subsequent in this way or mentioned first for data copy by the information such as disconnected time, position
It can be arrived by acquisition of information such as time, the positions of the interruption marked on synchronization log when being upgraded to the first new master data copy
The position of incremental data, so that incremental data be extracted.It optionally, can also be in the second master data pair of second node
Originally, second for synchronized algorithm corresponding with incremental data in the synchronization log for directly executing data synchronization on data copy, thus
Realize the synchronization of incremental data on second node.
In another alternative embodiment, the acquisition modes of incremental data described in step 104 include: by described
First master data copy, described first obtain the extraction position of the incremental data, root for the duplication state conversion of data copy
The incremental data is extracted from the first master data copy according to the extraction position.
It is standby by described first if the first master data copy breaks down in other embodiments of the invention
Data copy is promoted to the first new master data copy, specifically includes the following steps:
Step 201, the export and generating process of the table space file are interrupted.
Step 202, storage is main to described first after being interrupted the synchronous change application of data according to the synchronization log
Incremental data synchronization log in data copy is applied to described first for back end.Specifically, above-mentioned implementation can be used
Incremental data is obtained based on synchronization log in example, or according to the first master data copy, first for the duplication state of data copy
Conversion show that the extraction position of the incremental data to get incremental data, is synchronized to first finally for back end.It can
Choosing, it can also be corresponding with incremental data same in the synchronous synchronization log of data for directly executing on back end first
Algorithm is walked, thus synchronization of the realization first for incremental data on back end.
Step 203, the first new master data copy is promoted to for back end by described first.To ensure that first
The safety and availability of node data.
The other side of the embodiment of the present invention proposes that a kind of mysql cluster online data based on data redundancy divides again
Cloth apparatus, as shown in Figure 4, comprising:
Receiving module 11, redistribution is requested for receiving data;
Disconnect module 12, for according to fast resampling request by first node the first master data copy, the
One interrupts for the synchronous change application of the data between data copy;
Module 13 is copied, it, will for generating table space file for described first for the physical table space export of data copy
The table space file is individually copied to the second master data copy of second node, second for data copy;
Import modul 14, for being stored synchronous disconnect of data later to the incremental number in the first master data copy
According to increment synchronization respectively to the second master data copy, described second for data copy.
Optionally, it is described disconnect module 12 in by first node the first master data copy, first for data copy it
Between the synchronous change application of data while interrupt, retain the synchronous synchronization log of data.
Optionally, the import modul 14 is also used to realize: obtaining the synchronous change of data according to the synchronization log and answers
The incremental data that the first master data copy is arrived with storage during interruption and the table space file copy, by the increasing
Amount data are synchronized to the second master data copy, described second for data copy.
Optionally, the import modul 14 is also used to realize: passing through the first master data copy, the first standby number
The extraction position that the incremental data is obtained according to the duplication state conversion of copy, it is main from described first according to the extraction position
Data copy extracts the incremental data.
Optionally, if the first master data copy breaks down, described first is promoted to for data copy new
First master data copy, specifically includes:
Interrupt the export and generating process of the table space file;
The first master data copy is arrived in storage after being interrupted the synchronous change application of data according to the synchronization log
In incremental data synchronization log be applied to described first for back end;
The first new master data copy is promoted to for back end by described first.
The embodiment of the device of mysql cluster online data redistribution method described in the realization based on data redundancy,
Its technical effect is same or similar with aforementioned any means embodiment.
In terms of the third of the embodiment of the present invention, proposes the mysql cluster based on data redundancy described in a kind of execution and exist
One embodiment of the device of line fast resampling method.As shown in figure 5, to be based on data described in execution provided by the invention
The hardware structural diagram of one embodiment of the device of the mysql cluster online data redistribution method of redundancy.
As shown in figure 5, described device includes:
One or more processors 901 and memory 902, in Fig. 5 by taking a processor 901 as an example.
The device of mysql cluster online data redistribution method described in the execution based on data redundancy can also wrap
It includes: input unit 903 and output device 904.
Processor 901, memory 902, input unit 903 and output device 904 can pass through bus or other modes
It connects, in Fig. 5 for being connected by bus.
Memory 902 is used as a kind of non-volatile computer readable storage medium storing program for executing, can be used for storing non-volatile software journey
Sequence, non-volatile computer executable program and module, based on data redundancy as described in the embodiment of the present application
Corresponding program instruction/the module of mysql cluster online data redistribution method is (for example, attached receiving module shown in Fig. 4 11, disconnected
It is opened block 12, copy module 13, import modul 14).Processor 901 is stored in non-volatile in memory 1002 by operation
Property software program, instruction and module are realized above-mentioned thereby executing the various function application and data processing of server
The mysql cluster online data redistribution method based on data redundancy of embodiment of the method.
Memory 902 may include storing program area and storage data area, wherein storing program area can store operation system
Application program required for system, at least one function;Storage data area can be stored according to the mysql cluster based on data redundancy
Online data redistribution device uses created data etc..In addition, memory 902 may include that high random access is deposited
Reservoir, can also include nonvolatile memory, a for example, at least disk memory, flush memory device or other are non-volatile
Property solid-state memory.In some embodiments, it includes the storage remotely located relative to processor 901 that memory 902 is optional
Device, these remote memories can pass through network connection to member user's behavior monitoring device.The example of above-mentioned network include but
It is not limited to internet, intranet, local area network, mobile radio communication and combinations thereof.
Input unit 903 can receive the number or character information of input, and generate and the mysql based on data redundancy
The related key signals input of the user setting and function control of cluster online data redistribution device.Output device 904 can wrap
It includes display screen etc. and shows equipment.
One or more of modules are stored in the memory 902, when by one or more of processors
When 901 execution, the mysql cluster online data redistribution side based on data redundancy in above-mentioned any means embodiment is executed
Method.The embodiment of the device of mysql cluster online data redistribution method described in the execution based on data redundancy, skill
Art effect is same or similar with aforementioned any means embodiment.
The embodiment of the invention provides a kind of non-transient computer storage medium, the computer storage medium is stored with
Computer executable instructions, the computer executable instructions can be performed in above-mentioned any means embodiment based on data redundancy
Mysql cluster online data redistribution method.The embodiment of the non-transient computer storage medium, technical effect is with before
It is same or similar to state any means embodiment.
It should be understood by those ordinary skilled in the art that: the discussion of any of the above embodiment is exemplary only, not
It is intended to imply that the scope of the present disclosure (including claim) is limited to these examples;Under thinking of the invention, above embodiments
Or can also be combined between the technical characteristic in different embodiments, step can be realized with random order, and be existed such as
Many other variations of the upper different aspect of the invention, for simplicity, they are not provided in details.
In addition, to simplify explanation and discussing, and in order not to obscure the invention, in provided attached drawing
It can show or can not show and be connect with the well known power ground of integrated circuit (IC) chip and other components.In addition,
Device can be shown in block diagram form, to avoid obscuring the invention, and this has also contemplated following facts, i.e.,
The details of embodiment about these block diagram arrangements be height depend on will implementing platform of the invention (that is, these are thin
Section should be completely within the scope of the understanding of those skilled in the art).Detail (for example, circuit) is being elaborated to describe
In the case where exemplary embodiment of the present invention, it will be apparent to those skilled in the art that can there is no these
Implement the present invention in the case where detail or in the case that these details change.Therefore, these descriptions should be recognized
To be illustrative rather than restrictive.
Although having been incorporated with specific embodiments of the present invention, invention has been described, according to retouching for front
It states, many replacements of these embodiments, modifications and variations will be apparent for those of ordinary skills.Example
Such as, discussed embodiment can be used in other memory architectures (for example, dynamic ram (DRAM)).
What the embodiment of the present invention was intended to cover fall within the broad range of appended claims all such replaces
It changes, modifications and variations.Therefore, all within the spirits and principles of the present invention, any omission for being made, modification, equivalent replacement,
Improve etc., it should all be included in the protection scope of the present invention.
Claims (10)
1. a kind of mysql cluster online data redistribution method based on data redundancy characterized by comprising
Receive fast resampling request;
According to fast resampling request by first node the first master data copy, first for the number between data copy
It is interrupted according to synchronous change application;
Table space file is generated for the physical table space export of data copy by described first, the table space file is copied respectively
Shellfish to the second master data copy of second node, second for data copy;
Storage distinguishes increment to the incremental data in the first master data copy after the synchronous change application of data is interrupted
The second master data copy, described second are synchronized to for data copy.
2. the method according to claim 1, wherein the first master data copy by first node,
One for the synchronous change application of data between data copy while interrupt, and retains the synchronous synchronization log of data.
3. according to the method described in claim 2, it is characterized in that, the change application that data are synchronous stores after interrupting
Increment synchronization is distinguished to the second master data copy, the second standby number to the incremental data in the first master data copy
It include: that the synchronous change application interruption of data and the table space file copy phase are obtained according to the synchronization log according to copy
Between storage arrive the first master data copy incremental data, by the incremental data be synchronized to the second master data copy,
Described second for data copy.
4. the method according to claim 1, wherein the acquisition modes of the incremental data include: by described
First master data copy, described first obtain the extraction position of the incremental data, root for the duplication state conversion of data copy
The incremental data is extracted from the first master data copy according to the extraction position.
5. according to the method described in claim 2, it is characterized in that, if the first master data copy breaks down, by institute
It states first and is promoted to the first new master data copy for data copy, specifically include:
Interrupt the export and generating process of the table space file;
Storage is into the first master data copy after being interrupted the synchronous change application of data according to the synchronization log
Incremental data synchronization log is applied to described first for back end;
The first new master data copy is promoted to for back end by described first.
6. a kind of mysql cluster online data redistribution device based on data redundancy characterized by comprising
Receiving module, redistribution is requested for receiving data;
Module is disconnected, for requesting according to the fast resampling by the first master data copy, the first standby number in first node
It is interrupted according to the synchronous change application of the data between copy;
Module is copied, for generating table space file for described first for the physical table space export of data copy, by the table
Space file is individually copied to the second master data copy of second node, second for data copy;
Import modul, for storage after interrupting the synchronous change application of data to the increment in the first master data copy
Data distinguish increment synchronization to the second master data copy, described second for data copy.
7. device according to claim 6, which is characterized in that the first master data copy by first node,
One for the synchronous change application of data between data copy while interrupt, and retains the synchronous synchronization log of data.
8. device according to claim 6, which is characterized in that the import modul is also used to realize: passing through described first
Master data copy, described first obtain the extraction position of the incremental data for the duplication state conversion of data copy, according to institute
It states and extracts position from the first master data copy extraction incremental data.
9. a kind of electronic equipment, comprising:
At least one processor;And
The memory being connect at least one described processor communication;Wherein,
The memory is stored with the instruction that can be executed by one processor, and described instruction is by least one described processor
Execute so that at least one described processor be able to carry out as described in claim 1-5 any one based on data redundancy
Mysql cluster online data redistribution method.
10. a kind of non-transient computer storage medium, the computer storage medium are stored with computer executable instructions, the meter
The executable mysql cluster based on data redundancy as described in claim 1-5 any one of calculation machine executable instruction is in line number
According to redistribution method.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910395268.2A CN110427383A (en) | 2019-05-13 | 2019-05-13 | Mysql cluster online data redistribution method and relevant device based on data redundancy |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910395268.2A CN110427383A (en) | 2019-05-13 | 2019-05-13 | Mysql cluster online data redistribution method and relevant device based on data redundancy |
Publications (1)
Publication Number | Publication Date |
---|---|
CN110427383A true CN110427383A (en) | 2019-11-08 |
Family
ID=68407540
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910395268.2A Pending CN110427383A (en) | 2019-05-13 | 2019-05-13 | Mysql cluster online data redistribution method and relevant device based on data redundancy |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110427383A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112115146A (en) * | 2020-09-15 | 2020-12-22 | 北京人大金仓信息技术股份有限公司 | Data redistribution method, device, equipment and storage medium of database |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1542652A (en) * | 2003-11-06 | 2004-11-03 | 北京四方继保自动化有限公司 | Application method and network system of fully distributed protected information processing system real-time database |
CN103198159A (en) * | 2013-04-27 | 2013-07-10 | 国家计算机网络与信息安全管理中心 | Transaction-redo-based multi-copy consistency maintaining method for heterogeneous clusters |
CN106843745A (en) * | 2015-12-03 | 2017-06-13 | 南京中兴新软件有限责任公司 | Capacity expansion method and device |
CN107547606A (en) * | 2016-06-29 | 2018-01-05 | 中兴通讯股份有限公司 | Data processing method, cluster manager dual system, explorer, data handling system |
CN107870829A (en) * | 2016-09-24 | 2018-04-03 | 华为技术有限公司 | A kind of distributed data restoration methods, server, relevant device and system |
US20180173596A1 (en) * | 2016-12-15 | 2018-06-21 | Palantir Technologies Inc. | Incremental backup of computer data files |
-
2019
- 2019-05-13 CN CN201910395268.2A patent/CN110427383A/en active Pending
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1542652A (en) * | 2003-11-06 | 2004-11-03 | 北京四方继保自动化有限公司 | Application method and network system of fully distributed protected information processing system real-time database |
CN103198159A (en) * | 2013-04-27 | 2013-07-10 | 国家计算机网络与信息安全管理中心 | Transaction-redo-based multi-copy consistency maintaining method for heterogeneous clusters |
CN106843745A (en) * | 2015-12-03 | 2017-06-13 | 南京中兴新软件有限责任公司 | Capacity expansion method and device |
CN107547606A (en) * | 2016-06-29 | 2018-01-05 | 中兴通讯股份有限公司 | Data processing method, cluster manager dual system, explorer, data handling system |
CN107870829A (en) * | 2016-09-24 | 2018-04-03 | 华为技术有限公司 | A kind of distributed data restoration methods, server, relevant device and system |
US20180173596A1 (en) * | 2016-12-15 | 2018-06-21 | Palantir Technologies Inc. | Incremental backup of computer data files |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112115146A (en) * | 2020-09-15 | 2020-12-22 | 北京人大金仓信息技术股份有限公司 | Data redistribution method, device, equipment and storage medium of database |
CN112115146B (en) * | 2020-09-15 | 2023-09-15 | 北京人大金仓信息技术股份有限公司 | Data redistribution method, device, equipment and storage medium of database |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107247619B (en) | Live migration of virtual machine method, apparatus, system, storage medium and equipment | |
CN102955845B (en) | Data access method, device and distributed data base system | |
CN111124277B (en) | Deep learning data set caching method, system, terminal and storage medium | |
EP2662771A1 (en) | Scheduling method, and multi-core processor system | |
CN106446159B (en) | A kind of method of storage file, the first virtual machine and name node | |
CN103946844A (en) | Synchronizing updates across cluster filesystems | |
CN104410681A (en) | Dynamic migration and optimization method of virtual machines based on remote direct memory access | |
CN104468734A (en) | Virtual cluster expanding method based on cloning | |
CN110347651A (en) | Method of data synchronization, device, equipment and storage medium based on cloud storage | |
CN109840166A (en) | Across the cluster object storage async backup methods, devices and systems of one kind | |
CN102710763A (en) | Method and system for pooling, slicing and fault transfer of distributed cache | |
CN104750741A (en) | Invalid link processing method and invalid link processing device | |
CN104423982A (en) | Request processing method and device | |
CN105320681A (en) | Database content combination method and device | |
CN104462342B (en) | database snapshot synchronization processing method and device | |
CN107273246A (en) | A kind of server system backup method and device | |
CN104517067A (en) | Method, device and system for data access | |
CN110196788B (en) | Data reading method, device and system and storage medium | |
CN103713952B (en) | Virtual disk distributed-memory method based on UFS (Universal Flash Storage) | |
CN110427383A (en) | Mysql cluster online data redistribution method and relevant device based on data redundancy | |
WO2016107219A1 (en) | Data recovery method and apparatus | |
CN108647112A (en) | The method, apparatus and distributing real time system system of data backup | |
CN109947592A (en) | A kind of method of data synchronization, device and relevant device | |
CN107463638A (en) | File sharing method and equipment between offline virtual machine | |
CN105760456B (en) | A kind of method and apparatus keeping data consistency |
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 |