CN106611001A - Method, device and system for checking consistency of data in database tables in virtual machines - Google Patents

Method, device and system for checking consistency of data in database tables in virtual machines Download PDF

Info

Publication number
CN106611001A
CN106611001A CN201510702295.1A CN201510702295A CN106611001A CN 106611001 A CN106611001 A CN 106611001A CN 201510702295 A CN201510702295 A CN 201510702295A CN 106611001 A CN106611001 A CN 106611001A
Authority
CN
China
Prior art keywords
data
verified
sig
database table
checking
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
Application number
CN201510702295.1A
Other languages
Chinese (zh)
Inventor
王志刚
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
ZTE Corp
Original Assignee
ZTE Corp
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by ZTE Corp filed Critical ZTE Corp
Priority to CN201510702295.1A priority Critical patent/CN106611001A/en
Priority to PCT/CN2016/091749 priority patent/WO2017071337A1/en
Publication of CN106611001A publication Critical patent/CN106611001A/en
Pending legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • 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)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computer Security & Cryptography (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Data Exchanges In Wide-Area Networks (AREA)

Abstract

The invention provides a method, device and system for checking the consistency of data in database tables in virtual machines. The process, executed on a VM<SLB> side, of the method for checking the consistency of the data in the database tables in the virtual machines comprises the steps of carrying out summary calculation on data which need to be checked in an initial database table in a local database to obtain summary information; transmitting a check request comprising the summary information to signaling processing virtual machines VM<SIG> for checking whether to-be-checked data in corresponding database tables in the databases stored in the VM<SIG> are consistent with the data which need to be checked in the initial database table or not according to the summary information by the VM<SIG>; and receiving a table data synchronization request transmitted from the VM<SIG> under the condition that the to-be-checked data are not consistent with the data which need to be checked, and then transmitting the initial database table to the corresponding VM<SIG> for updating the corresponding database table by the VM<SIG> according to the initial database table. The method is easy to implement and wide in application range.

Description

Method, device and system for checking data consistency of database table of virtual machine
Technical Field
The invention relates to the technical field of network function virtualization, in particular to a method, a device and a system for checking the data consistency of a database table of a virtual machine.
Background
After the Network Function is Virtualized, a VNF (Virtualized Network Function) generally includes multiple VMs (Virtual machines) to provide conventional Network services. One of the most important and core functions in the VNF is an SLB (Service Load Balancer), which monitors the Load of each virtual machine in the VNF in real time, adjusts the number of signaling connections and traffic allocated to each virtual machine in time, and performs flexible scaling (i.e., increasing or decreasing the number of virtual machines) of the VNF if necessary.
Taking MGCF (Media Gateway Control Function) as an example, when a user configures a series of coupling resources in omc (operation and Maintenance centre), SLB needs to uniformly share the coupling resources to multiple signaling processing virtual machines (VM for short)SIGVirtual machine) and recorded in a database table (we assume the table name as table _ sctp). When individual VMSIGWhen the virtual machine is down or stopped, the SLB also needs to migrate the coupled resources in the virtual machine to other normally operating VMsSIGThe corresponding database tables also need to be adjusted synchronously. That is, in SLB virtual machine (we simply called VM)SLB)、VMSIGThe virtual machines all have a database table _ sctp, the contents of which are provided by the VMSLBThe virtual machine is maintained and synchronized to other VMs in real timeSIGOn the virtual machine. It can be seen that the database table _ sctp exists in a plurality of independent virtual machines at the same time, and how to ensure the consistency of database table data in each virtual machine becomes a problem that needs to be considered. Therefore, a method, an apparatus and a system for checking the database table data consistency of a virtual machine are needed to solve the above technical problems in the prior art.
Disclosure of Invention
The invention provides a method, a device and a system for checking the data consistency of a database table of a virtual machine, which are easy to realize and wide in application range.
The technical scheme adopted by the invention is as follows:
a method for checking data consistency of database table of virtual machine in virtual machine VM with service load balancing functionSLBA process performed by a side, comprising: performing summary calculation on data needing to be checked in an initial database table in a local database to obtain summary information; sending a check table data request containing summary information to a signaling processing Virtual Machine (VM)SIGSupply the VMSIGChecking the VM according to the summary informationSIGData to be verified corresponding to a database table in a stored database and the databaseWhether the data of the initial database table needing to be checked are consistent or not is judged; receiving the VM under the condition that the data to be verified is inconsistent with the data to be verifiedSIGAfter the sent synchronous table data request, the initial database table is sent to the VMSIGFor the VMSIGAnd updating the corresponding database table according to the initial database table.
Preferably, the summary calculation of the data to be checked of the initial database table in the local database to obtain summary information specifically includes: and calculating the MD5 value of the data needing to be checked by adopting a message digest algorithm fifth version MD5, and taking the MD5 value as the digest information to comprise the MD5 value.
Preferably, the synchronization table data request includes a name of the corresponding database table; sending the initial database table to the VMSIGThe method specifically comprises the following steps: after the initial database table is obtained according to the name of the corresponding database table, the initial database table is sent to the VMSIG。
Preferably, the sending of the check table data request containing the summary information to the signaling processing virtual machine VMSIGThe method specifically comprises the following steps: directly sending the check table data request to any VMSIGPerforming the following steps; or sending the check table data request to any VMSIGSo that said check table data request is made by said any one VMSIGBegin forwarding to the remaining VMsSIGUntil all VMsSIGAnd receiving the check table data request.
The invention also provides a method for checking the data consistency of the database table of the virtual machine, which processes the VM in the signaling processSIGA process performed by a side, comprising: receiving a VMSLBThe transmitted check table data request containing the summary information; checking whether the data to be verified of the corresponding database table in the database stored by the database is consistent with the data needing to be verified of the initial database table or not according to the summary information; if the data to be verified is not consistent with the data to be verified, sending synchronous table dataRequest to the VMSLBTo make the VMSLBSending the initial database table to the VMSIG(ii) a Receive and rely on the VMSIGAnd updating the corresponding database table by the sent initial database table.
Preferably, the check table data request includes a name of the database table and a total number of records of the data to be checked, and the summary information includes an MD5 value; the checking whether the data to be verified of the corresponding database table in the database stored by the database is consistent with the data to be verified of the initial database table according to the summary information specifically comprises: finding a corresponding database table in a self-storage database according to the name of the database table; checking whether the total number of records of the data to be verified of the corresponding database table is consistent with the total number of records of the data to be verified, and if the total number of records of the data to be verified is consistent with the total number of records of the data to be verified, further checking whether the MD5 value of the data to be verified is the same as the MD5 value of the data to be verified; correspondingly, if the data to be verified is inconsistent with the data to be verified, a synchronization table data request is sent to the VMSLBThe method specifically comprises the following steps: if the total number of records of the data to be verified is not consistent with the total number of records of the data to be verified, or the MD5 value of the data to be verified is not the same as the MD5 value of the data to be verified, sending the synchronization table data request to the VMSLB。
The invention also provides a device for checking the data consistency of the database table of the virtual machine, which is arranged in the VMSLBThe apparatus comprises: the abstract calculation module is used for carrying out abstract calculation on data needing to be checked in an initial database table in a local database so as to obtain abstract information; a checking table data request sending module for sending the checking table data request containing the summary information to the signaling processing virtual machine VMSIGSupply the VMSIGChecking the VM according to the summary informationSIGWhether the data to be verified of the corresponding database table in the stored database is consistent with the data needing to be verified of the initial database table or not is judged; first stageA starting database table sending module, configured to receive the VM under a condition that the data to be verified is inconsistent with the data to be verifiedSIGAfter the sent synchronous table data request, the initial database table is sent to the VMSIGFor the VMSIGAnd updating the corresponding database table according to the initial database table.
Preferably, the summary calculation module is further configured to: and calculating the MD5 value of the data needing to be checked by adopting a message digest algorithm fifth version MD5, and taking the MD5 value as the digest information.
Preferably, the check table data request sending module is further configured to: directly sending the check table data request to any VMSIGPerforming the following steps; or sending the check table data request to any VMSIGSo that said check table data request is made by said any one VMSIGBegin forwarding to the remaining VMsSIGUntil all VMsSIGAnd receiving the check table data request.
The invention also provides a device for checking the data consistency of the database table of the virtual machine, which is arranged in the VMSIGA side, comprising: a receiving module for receiving the VMSLBThe transmitted check table data request containing the summary information; the checking module is used for checking whether the data to be checked in the database table corresponding to the database table stored by the checking module is consistent with the data needing to be checked in the initial database table or not according to the summary information; a sending module, configured to send a synchronization table data request to the VM if the data to be verified is inconsistent with the data to be verifiedSLBTo make the VMSLBSending the initial database table to the VMSIG(ii) a An update module to receive and to be in accordance with the VMSIGAnd updating the corresponding database table by the sent initial database table.
Preferably, the check table data request includes a name of the database table and a total number of records of the data to be checked, the summary information includes an MD5 value, and the check module is further configured to:finding a corresponding database table in a self-storage database according to the name of the database table; checking whether the total number of records of the data to be verified of the corresponding database table is consistent with the total number of records of the data to be verified, and if the total number of records of the data to be verified is consistent with the total number of records of the data to be verified, further checking whether the MD5 value of the data to be verified is the same as the MD5 value of the data to be verified; correspondingly, the sending module is further configured to: if the total number of records of the data to be verified is not consistent with the total number of records of the data to be verified, or the MD5 value of the data to be verified is not the same as the MD5 value of the data to be verified, sending the synchronization table data request to the VMSLB。
In addition, the present invention also provides a virtual network communication system comprising the VM according to the above arrangementSLBA side checking device.
In addition, the present invention also provides a virtual network communication system comprising the VM according to the above arrangementSIGA side checking device.
By adopting the technical scheme, the invention at least has the following effects:
the method for checking the data consistency of the database table of the virtual machine has wide application range, the method can be adopted among various virtual machines to check the data consistency of the database table, and the data needing to be checked is not limited to a whole table of a coupled data table, but also can be partial fields in the table. The verification method is easy to implement, and particularly, the adopted summary information comprises an MD5 value which is only 16 bytes, so that the load influence on message transmission between the virtual machines is greatly reduced.
Drawings
FIG. 1 is a flowchart of a method for checking database table data consistency of a virtual machine according to a first embodiment of the present invention;
FIG. 2 is a flowchart illustrating a method for checking database table data consistency of a virtual machine according to a second embodiment of the present invention;
FIG. 3 is a flow chart of a preferred embodiment of the verification method shown in FIG. 2;
FIG. 4 is a flow chart of another preferred embodiment of the verification method shown in FIG. 2;
FIG. 5 is a flowchart illustrating a method for checking database table data consistency of a virtual machine according to a third embodiment of the present invention;
FIG. 6 is a flowchart illustrating a method for checking database table data consistency of a virtual machine according to a fourth embodiment of the present invention;
FIG. 7 is a diagram of a checking apparatus for database table data consistency of a virtual machine according to a fifth embodiment of the present invention;
fig. 8 is a schematic diagram of a checking apparatus for database table data consistency of a virtual machine according to a sixth embodiment of the present invention.
Detailed Description
To further explain the technical means and effects of the present invention adopted to achieve the intended purpose, the present invention will be described in detail with reference to the accompanying drawings and preferred embodiments.
The method for checking the data consistency of the database table of the virtual machine can realize the consistency of the table data among the virtual machines, and the method for checking the data consistency of the database table of the virtual machine and each step thereof are described in detail below.
First embodiment
As shown in fig. 1, the method for checking data consistency of a database table of a virtual machine according to this embodiment is applied to a virtual machine VM with a service load balancing functionSLBA process performed by a side, comprising: step S10: performing summary calculation on data needing to be checked of initial database table in local databaseTo derive summary information. Step S20: sending a check table data request containing summary information to a signaling processing Virtual Machine (VM)SIGFor VMSIGChecking VM according to summary informationSIGAnd whether the data to be verified of the corresponding database table in the stored database is consistent with the data needing to be verified of the initial database table or not is judged. Step S30: receiving the VM under the condition that the data to be verified is inconsistent with the data needing to be verifiedSIGAfter the sent synchronous table data request, the initial database table is sent to the VMSIGFor VMSIGAnd updating the corresponding database table according to the initial database table. Whereby VM can be realizedSIGThe stored corresponding database table is synchronized to the VMSLBAn initial database table is stored. As shown in fig. 3 and 4, in VMSLBThe side can set the time period T by using the timer intervalcheckAfter the summary calculation is carried out on the data needing to be checked of the initial database table, the data is sent to the VMSIGSending a check table data request to ensure the VMSIGDatabase table data and VMSLBThe consistency of the database table data improves the high reliability and the self-recovery capability of the virtual network communication system.
As a preferred embodiment, in step S10: the summary calculation is performed on the data needing to be checked in the initial database table in the local database to obtain summary information, and the summary calculation specifically includes: and calculating an MD5 value of data needing to be checked by adopting a message digest algorithm fifth version MD5, and taking the MD5 value as the digest information to comprise the MD5 value.
The MD5 algorithm is adopted to ensure the integrity and consistency of information transmission between virtual machines. Since the digest information of two identical pieces of data after digest calculation is necessarily the same, even if two different pieces of data differ by only one bit, the digest information after digest calculation, especially the digest information after MD5 calculation, may be very different. If the data at the two ends are different, the probability that the summary information obtained after the MD5 calculation is the same is very low. More importantly, the MD5 is simple and convenient to calculate, the length of the obtained summary information is fixed, and the method is suitable for a virtual network communication system with high efficiency requirement.
In addition, the data to be checked may be full table data of the database table _ sctp, or may be one field thereof, and is determined according to the importance of the data. The step of calculating the MD5 value includes:
1) and sequencing all records in the database table _ sctp according to a unique key of the database table, such as a record number.
2) Taking out the data needing to be checked from the database table, and storing the serial of the data needing to be checked into an array needCheck [ ] of an unknown char type, wherein the following table shows that the serial of the data needing to be checked takes an int type as an example, and a storage schematic diagram is given.
Watch 1
3) The MD5 calculation is performed for the valid bytes in the array needCheck [ ] resulting in an MD5 value containing 16 bytes as summary information.
Further, the above-mentioned synchronization table data request includes the name of the corresponding database table, and thus is sending the initial database table to the VMSIGThe method specifically comprises the following steps: after the initial database table is obtained according to the name of the corresponding database table, the initial database table is sent to the VMSIG。
Second embodiment
As shown in fig. 2, in the present embodiment, based on the first embodiment, step S10: sending a check table data request containing summary information to a signaling processing Virtual Machine (VM)SIGThe method specifically comprises the following steps: step 200: directly sending check table data request to any VMSIGThis is the first transmission method. Or sending a check table data request to any VMSIGSo that the check list data request is made by said any one VMSIGBegin forwarding to the remaining VMsSIGUntil all VMsSIGReceivingThis is the second way to send to a request for check table data.
For the checking method adopting the first transmission mode, the checking method is called star checking, and the shape checking is characterized in that the VM (virtual machine) performs the checkingSLBTo all VMs simultaneouslySIGA request for verification table data is sent, as described fully below in connection with fig. 3 for a star verification.
As shown in fig. 3, VMSLBIs provided with a timer TCheckPeriodically checking the database table data for consistency is carried out, and the duration of the timer can be set to be 30 seconds. When the timer is over time, VMSLBCalculate MD5 value of data to be checked using MD5, and send check list data request 101 to all VMsSIG. Preferably, the message needs to carry both the name of the original database table and the total number of records that need to be checked for data.
Then, VMSIGAfter receiving a data request 101 of a check table, positioning and finding a corresponding database table, firstly checking whether the total number of records of data to be checked and data to be checked is the same or not, and if the total number of records is different, determining that a secondary VM is required againSLBThe synchronized table data is retrieved. If the total number of records is the same, the MD5 values of the two records are further checked, and if the total number of records is the same, the table data representing the two records are consistent and are not used for the VMSLBAny response is replied, and the verification is finished.
If a certain VMSIGIf the data to be verified is different from the total number of records or the value of MD5, the VM is startedSIGActively sending a synchronization Table data request 102 to a VMSLBAnd requesting to resynchronize all data of the database table data, wherein the message needs to carry the name of the database table.
VMSLBUpon receipt of the Sync Table data request 102, the VM is redirected via a Sync Table data message 103SIGThe entire contents of the initial database table sctp are sent.
VMSIGUpon receipt of the synchronization table data message 103, the corresponding database table is first clearedAnd (4) data, then replacing all the contents of the received initial database table into corresponding coupling information, and finishing the verification.
The second checking method, called chain check, features VMSLBTo only one of the VMsSIGSending a request for checking the table data, by the VMSIGTo the next VMSIGForwarding check list data request until all VMsSIGReceiving the request for check table data, the following is a detailed description of the overall flow of chain checking in conjunction with FIG. 4.
As shown in fig. 4, VMSLBSetting a timer TCheckTo periodically check the database table data for consistency, the timer may be set to 30 seconds in duration. When the timer is over time, VMSLBMD5 is used to calculate the MD5 value of the data to be checked and to send a check list data request 101 to one of the VMsSIGMay be in a VMSLBAll VMs of storageSLBThe smallest middle number is sent to the VM in the figure firstSIG1. It should be noted that the check table data request also needs to carry the name of the original database table and the total number of records that need to check the data.
VMSIG1 after receiving a checking table data request 101, firstly sending the checking table data request to a VM with a small numberSIG2. Then, the virtual machine is checked: locating and finding a corresponding database table, respectively checking whether the total number of records of the data to be verified and the data to be verified is the same as the MD5 value, if so, representing that the table data is consistent without giving the VMSLBAny response is replied, and the verification is finished.
If a certain VMSIGThe data to be verified stored in the memory is different from the total number of records or MD5 value of the data to be verified, such as VM in FIG. 4SIG2, it is necessary to actively send a synchronization Table data request 102 to the VMSLBThe contents of the database table data are requested to be resynchronized, and likewise, the name of the corresponding database table needs to be carried in the synchronization table data request 102.
VMSLBUpon receipt of the synchronization table data request 102, the corresponding VM is redirected via a synchronization table data message 103SIGThe entire contents of the initial database table sctp are sent.
VMSIGAnd when the synchronization table data message 103 is received, firstly clearing the data in the corresponding database table, then replacing all the received contents of the initial database table into the corresponding database table, and ending the verification.
Compared with the star check, the chain check is that each VMSIGTo the next VMSIGSending check table data requests, not by the VMSLBUniformly send to all VMsSIGThus when VMSIGWhen the quantity is large, chain type verification can reduce VMSLBThe load of messaging.
Third embodiment
As shown in fig. 5, the verification method for database table data consistency of the virtual machine provided by this embodiment is implemented in the VMSIGA process performed by a side, comprising: step S40: receiving a VMSLBAnd sending a check list data request containing the summary information. Step S50: and checking whether the data to be verified of the corresponding database table in the database stored by the database is consistent with the data needing to be verified of the initial database table or not according to the summary information. Step S60: if the data to be verified is not consistent with the data to be verified, sending a synchronization table data request to the VMSLBTo make VMSLBSending an initial database table to the VMSIG. Step S70: receive and rely on a VMSIGThe sent initial database table updates the corresponding database table.
Fourth embodiment
As shown in fig. 6, in this embodiment, on the basis of the third embodiment, the check table data request includes the name of the database table and the total number of records of the data to be checked, and the summary information includes the MD5 value, further, step S50: checking the data to be checked of the corresponding database table in the database stored by the database according to the summary information and the required correction of the initial database tableWhether the data are consistent or not is checked, and the method specifically comprises the following steps: step S500: and finding out a corresponding database table in the self-storage database according to the name of the database table. Step S501: and checking whether the total number of records of the data to be verified corresponding to the database table is consistent with the total number of records of the data to be verified, and if the total number of records of the data to be verified is consistent with the total number of records of the data to be verified, further checking whether the MD5 value of the data to be verified is the same as the MD5 value of the data to be verified. Correspondingly, step S60: if the data to be verified is not consistent with the data to be verified, sending a synchronization table data request to the VMSLBThe method specifically comprises the following steps: step S600: if the total number of records of the data to be verified is not consistent with the total number of records of the data to be verified, or the MD5 value of the data to be verified is not the same as the MD5 value of the data to be verified, sending a synchronization table data request to the VMSLB。
Fifth embodiment
As shown in fig. 7, the checking apparatus for data consistency of database tables of a virtual machine provided in this embodiment is disposed in a VMSLBThe apparatus includes: and the abstract calculation module 10 is used for performing abstract calculation on the data needing to be checked in the initial database table in the local database to obtain abstract information. A checking table data request sending module 20, configured to send a checking table data request containing summary information to the signaling processing virtual machine VMSIGFor VMSIGChecking VM according to summary informationSIGAnd whether the data to be verified of the corresponding database table in the stored database is consistent with the data needing to be verified of the initial database table or not is judged. An initial database table sending module 30, configured to receive the VM under the condition that the data to be verified is inconsistent with the data to be verifiedSIGAfter the sent synchronous table data request, the initial database table is sent to the VMSIGFor VMSIGAnd updating the corresponding database table according to the initial database table.
Preferably, the digest calculation module 10 is further configured to: and calculating the MD5 value of the data needing to be checked by adopting a message digest algorithm fifth version MD5, wherein the digest information comprises the MD5 value.
Further onThe check table data request sending module 20 is further configured to: directly sending check table data request to any VMSIGIn (1). Or sending a check table data request to any VMSIGSo that the check table data request is made by the any one VMSIGBegin forwarding to the remaining VMsSIGUntil all VMsSIGA request for verification table data is received.
Sixth embodiment
As shown in fig. 8, the checking apparatus for data consistency of database tables of a virtual machine provided in this embodiment is disposed in a VMSIGThe apparatus includes: a receiving module 40 for receiving the VMSLBAnd sending a check list data request containing the summary information. And the checking module 50 is configured to check whether the data to be checked in the database table corresponding to the database table stored in the checking module per se is consistent with the data to be checked in the initial database table according to the summary information. A sending module 60, configured to send a synchronization table data request to the VM if the data to be verified is inconsistent with the data to be verifiedSLBTo make VMSLBSending an initial database table to the VMSIG. An update module 70 for receiving and updating the VMSIGThe sent initial database table updates the corresponding database table.
Further, the check table data request includes a name of the database table and a total number of records of the data to be checked, and the summary information includes an MD5 value, wherein the check module 50 is further configured to: finding out a corresponding database table in a self-storage database according to the name of the database table; checking whether the total number of records of the data to be verified corresponding to the database table is consistent with the total number of records of the data to be verified, and if the total number of records of the data to be verified is consistent with the total number of records of the data to be verified, further checking whether the MD5 value of the data to be verified is the same as the MD5 value of the data to be verified; correspondingly, the sending module 60 is further configured to: if the total number of records of the data to be verified is not consistent with the total number of records of the data to be verified, or the MD5 value of the data to be verified is not the same as the MD5 value of the data to be verified, sending a synchronization table data request to the VMSLB。
Seventh embodiment
In addition, the present invention also provides a virtual network communication system comprising the VM according to the above arrangementSLBA side checking device.
Eighth embodiment
In addition, the present invention also provides a virtual network communication system comprising the VM according to the above arrangementSIGA side checking device.
While the invention has been described in connection with specific embodiments thereof, it is to be understood that it is intended by the appended drawings and description that the invention may be embodied in other specific forms without departing from the spirit or scope of the invention.

Claims (13)

1. A method for checking data consistency of a virtual machine database table is characterized in that a virtual machine VM with a service load balancing functionSLBA process performed by a side, comprising:
performing summary calculation on data needing to be checked in an initial database table in a local database to obtain summary information;
sending a check table data request containing summary information to a signaling processing Virtual Machine (VM)SIGSupply the VMSIGChecking the VM according to the summary informationSIGCorresponding data in a stored databaseWhether the data to be verified of the database table is consistent with the data needing to be verified of the initial database table or not is judged;
receiving the VM under the condition that the data to be verified is inconsistent with the data to be verifiedSIGAfter the sent synchronous table data request, the initial database table is sent to the VMSIGFor the VMSIGAnd updating the corresponding database table according to the initial database table.
2. The verification method according to claim 1, wherein the performing summary calculation on the data to be verified of the initial database table in the local database to obtain summary information specifically includes:
and calculating the MD5 value of the data needing to be checked by adopting a message digest algorithm fifth version MD5, and taking the MD5 value as the digest information.
3. Checking method according to claim 1 or 2, wherein said synchronization table data request comprises the name of said corresponding database table;
sending the initial database table to the VMSIGThe method specifically comprises the following steps:
after the initial database table is obtained according to the name of the corresponding database table, the initial database table is sent to the VMSIG。
4. Checking method according to any of claims 1 to 3, characterized in that said sending of a request for checking table data containing summary information to the signalling virtual machine VMSIGThe method specifically comprises the following steps:
directly sending the check table data request to any VMSIGPerforming the following steps; or,
sending the check table data request to any VMSIGSo that said check table data request is made by said any one VMSIGBegin forwarding to the remaining VMsSIGUntil all VMsSIGReceiving the data request of the check tableAnd (6) obtaining.
5. A method for checking data consistency of a virtual machine database table is characterized in that a virtual machine VM is processed in a signaling mannerSIGA process performed by a side, comprising:
receiving a VMSLBThe transmitted check table data request containing the summary information;
checking whether the data to be verified of the corresponding database table in the database stored by the database is consistent with the data needing to be verified of the initial database table or not according to the summary information;
if the data to be verified is not consistent with the data to be verified, sending a synchronization table data request to the VMSLBTo make the VMSLBSending the initial database table to the VMSIG；
Receive and rely on the VMSIGAnd updating the corresponding database table by the sent initial database table.
6. The verification method of claim 5, wherein the verification table data request comprises a name of the database table and a total number of records of the data to be verified, and the summary information comprises an MD5 value;
the checking whether the data to be verified of the corresponding database table in the database stored by the database is consistent with the data to be verified of the initial database table according to the summary information specifically comprises:
finding a corresponding database table in a self-storage database according to the name of the database table;
checking whether the total number of records of the data to be verified of the corresponding database table is consistent with the total number of records of the data to be verified, and if the total number of records of the data to be verified is consistent with the total number of records of the data to be verified, further checking whether the MD5 value of the data to be verified is the same as the MD5 value of the data to be verified;
correspondingly, if the data to be verified is inconsistent with the data to be verified, a synchronization table data request is sent to the VMSLBThe method specifically comprises the following steps: if the total number of records of the data to be verified is not consistent with the total number of records of the data to be verified, or the MD5 value of the data to be verified is not the same as the MD5 value of the data to be verified, sending the synchronization table data request to the VMSLB。
7. A checking device for data consistency of a virtual machine database table is characterized in that the checking device is arranged in a VMSLBThe apparatus comprises:
the abstract calculation module is used for carrying out abstract calculation on data needing to be checked in an initial database table in a local database so as to obtain abstract information;
a checking table data request sending module for sending the checking table data request containing the summary information to the signaling processing virtual machine VMSIGSupply the VMSIGChecking the VM according to the summary informationSIGWhether the data to be verified of the corresponding database table in the stored database is consistent with the data needing to be verified of the initial database table or not is judged;
an initial database table sending module, configured to receive the VM under a condition that the data to be verified is inconsistent with the data to be verifiedSIGAfter the sent synchronous table data request, the initial database table is sent to the VMSIGFor the VMSIGAnd updating the corresponding database table according to the initial database table.
8. The verification apparatus of claim 7, wherein the digest calculation module is further configured to:
and calculating the MD5 value of the data needing to be checked by adopting a message digest algorithm fifth version MD5, and taking the MD5 value as the digest information.
9. The verification apparatus according to claim 7 or 8, wherein the verification table data request sending module is further configured to:
directly sending the check table data request to any VMSIGPerforming the following steps; or,
sending the check table data request to any VMSIGSo that said check table data request is made by said any one VMSIGBegin forwarding to the remaining VMsSIGUntil all VMsSIGAnd receiving the check table data request.
10. The utility model provides a check-up device of virtual machine database table data uniformity which characterized in that sets up in VMSIG side, the device includes:
the receiving module is used for receiving a check table data request containing summary information sent by the VMSLB;
the checking module is used for checking whether the data to be checked in the database table corresponding to the database table stored by the checking module is consistent with the data needing to be checked in the initial database table or not according to the summary information;
a sending module, configured to send a synchronization table data request to the VM if the data to be verified is inconsistent with the data to be verifiedSLBTo make the VMSLBSending the initial database table to the VMSIG；
An update module to receive and to be in accordance with the VMSIGAnd updating the corresponding database table by the sent initial database table.
11. The verification apparatus of claim 10, wherein the verification table data request includes a name of the database table and a total number of records of the data to be verified, the summary information includes an MD5 value, and the verification module is further configured to:
finding a corresponding database table in a self-storage database according to the name of the database table;
checking whether the total number of records of the data to be verified of the corresponding database table is consistent with the total number of records of the data to be verified, and if the total number of records of the data to be verified is consistent with the total number of records of the data to be verified, further checking whether the MD5 value of the data to be verified is the same as the MD5 value of the data to be verified;
correspondingly, the sending module is further configured to: if the total number of records of the data to be verified is not consistent with the total number of records of the data to be verified, or the MD5 value of the data to be verified is not the same as the MD5 value of the data to be verified, sending the synchronization table data request to the VMSLB。
12. Virtual network communication system, characterized in that it comprises a device according to any of claims 7 to 9 arranged in said VMSLBA side checking device.
13. Virtual network communication system, comprising a device according to claim 10 or 11, arranged in said VMSIGA side checking device.
CN201510702295.1A 2015-10-26 2015-10-26 Method, device and system for checking consistency of data in database tables in virtual machines Pending CN106611001A (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
CN201510702295.1A CN106611001A (en) 2015-10-26 2015-10-26 Method, device and system for checking consistency of data in database tables in virtual machines
PCT/CN2016/091749 WO2017071337A1 (en) 2015-10-26 2016-07-26 Database table data management method, apparatus and system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201510702295.1A CN106611001A (en) 2015-10-26 2015-10-26 Method, device and system for checking consistency of data in database tables in virtual machines

Publications (1)

Publication Number Publication Date
CN106611001A true CN106611001A (en) 2017-05-03

Family

ID=58613850

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201510702295.1A Pending CN106611001A (en) 2015-10-26 2015-10-26 Method, device and system for checking consistency of data in database tables in virtual machines

Country Status (2)

Country Link
CN (1) CN106611001A (en)
WO (1) WO2017071337A1 (en)

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108804561A (en) * 2018-05-22 2018-11-13 北京科东电力控制系统有限责任公司 Method of data synchronization and device
CN109582683A (en) * 2018-11-14 2019-04-05 泰康保险集团股份有限公司 Data consistency checking method, device and equipment
CN114339765A (en) * 2021-11-25 2022-04-12 国网河南省电力公司电力科学研究院 Differential protection data interactive chain type verification method and system based on 5G communication
CN117251460A (en) * 2023-08-10 2023-12-19 上海栈略数据技术有限公司 Data consistency check system for graph database and relational database

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110162461B (en) * 2019-04-16 2023-08-15 平安科技（深圳）有限公司 Data synchronization verification method and device and computer equipment
CN111125063B (en) * 2019-12-20 2023-09-26 无线生活（杭州）信息科技有限公司 Method and device for rapidly checking data migration among clusters
CN116069775B (en) * 2023-04-06 2023-08-22 上海二三四五网络科技有限公司 Data quality verification system and method for data warehouse

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5758355A (en) * 1996-08-07 1998-05-26 Aurum Software, Inc. Synchronization of server database with client database using distribution tables
CN101009516B (en) * 2006-01-26 2011-05-04 华为技术有限公司 A method, system and device for data synchronization
CN103312669A (en) * 2012-03-09 2013-09-18 广州从兴电子开发有限公司 ddata consistence protection
CN104021132B (en) * 2013-12-08 2017-08-22 郑州正信科技发展股份有限公司 Master/slave data storehouse data consistency verifies backup method and its system

Cited By (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108804561A (en) * 2018-05-22 2018-11-13 北京科东电力控制系统有限责任公司 Method of data synchronization and device
CN108804561B (en) * 2018-05-22 2021-10-15 北京科东电力控制系统有限责任公司 Data synchronization method and device
CN109582683A (en) * 2018-11-14 2019-04-05 泰康保险集团股份有限公司 Data consistency checking method, device and equipment
CN114339765A (en) * 2021-11-25 2022-04-12 国网河南省电力公司电力科学研究院 Differential protection data interactive chain type verification method and system based on 5G communication
CN114339765B (en) * 2021-11-25 2024-01-19 国网河南省电力公司电力科学研究院 Differential protection data interactive chain type verification method and system based on 5G communication
CN117251460A (en) * 2023-08-10 2023-12-19 上海栈略数据技术有限公司 Data consistency check system for graph database and relational database
CN117251460B (en) * 2023-08-10 2024-04-05 上海栈略数据技术有限公司 Data consistency check system for graph database and relational database

Also Published As

Publication number Publication date
WO2017071337A1 (en) 2017-05-04

Similar Documents

Publication Publication Date Title
CN106611001A (en) Method, device and system for checking consistency of data in database tables in virtual machines
CN111539726B (en) Block chain consensus system and method
WO2018177190A1 (en) Method and device for synchronizing blockchain data
CN108173691B (en) Cross-device aggregation method and device
CN102012944B (en) Distributed NOSQL (not only structured query language) database capable of providing replication property
US8930547B2 (en) Techniques for achieving storage and network isolation in a cloud storage environment
CN109547512A (en) A kind of method and device of the distributed Session management based on NoSQL
CN108696581A (en) Caching method, device, computer equipment and the storage medium of distributed information
CN105208058A (en) Information exchange system based on web session sharing
CN106445528A (en) Method and device for configuring SETUP options of BIOS quickly
CN110727738B (en) Global routing system based on data fragmentation, electronic equipment and storage medium
WO2016177231A1 (en) Dual-control-based active-backup switching method and device
CN107070752B (en) Testing method and testing system for long connection capacity
WO2021136233A1 (en) Service upgrading method, device and system
WO2010091624A1 (en) Flow tracking method, apparatus and system
CN106850724A (en) Data push method and device
CN114285695B (en) Communication method, device, apparatus, system and storage medium
CN106888110B (en) Configuration data synchronization method and device
CN103229480A (en) Data processing method, device and client in distributed storage system
US10853892B2 (en) Social networking relationships processing method, system, and storage medium
CN100423514C (en) Data synchronization method in distributed equipment according to address resolution protocol
CN112243139B (en) Program distribution synchronization method and system of multimedia terminal
CN104079663A (en) Distributed type real-time synchronizing network system and data annunciating method thereof
CN105141687B (en) A kind of method for producing message
WO2018010448A1 (en) File transmission method and apparatus

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
WD01 Invention patent application deemed withdrawn after publication

Application publication date: 20170503

WD01 Invention patent application deemed withdrawn after publication