Method and device for database synchronization

A database and master database technology, applied in the database field, can solve the problems of increasing server maintenance costs, reducing service continuity, front-end business interruption, etc., achieving high data stability and high business continuity, ensuring data consistency, Avoid accidentally lost effects

Active Publication Date: 2019-05-21
BEIJING QIHOO TECH CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, data loss or crash may occur in the database at any point in time. The existing database system generally has a master-slave database architecture, including a master database and multiple slave databases. When the master database server fails, the slave database needs to be switched to For the master database, the switching process is more complicated. When the master-slave switch is not smooth, the data service may be suspended, resulting in the interruption of the front-end business and the reduction of service continuity; or provide a separate log backup module for each master database, but it is necessary to The database maintains its corresponding log backup module separately, the maintenance process is complicated, and the maintenance cost of the server is increased

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for database synchronization
  • Method and device for database synchronization
  • Method and device for database synchronization

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0083] Embodiments of the present invention are described in detail below, examples of which are shown in the drawings, wherein the same or similar reference numerals designate the same or similar elements or elements having the same or similar functions throughout. The embodiments described below by referring to the figures are exemplary only for explaining the present invention and should not be construed as limiting the present invention.

[0084] Those skilled in the art will understand that unless otherwise stated, the singular forms "a", "an", "said" and "the" used herein may also include plural forms. It should be further understood that the word "comprising" used in the description of the present invention refers to the presence of said features, integers, steps, operations, elements and / or components, but does not exclude the presence or addition of one or more other features, Integers, steps, operations, elements, components, and / or groups thereof. It will be unders...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention provides a database synchronizing method and apparatus. When a data operation request is received, the data operation request is analyzed, so a corresponding data operation instruction and corresponding data operation information can be acquired; the data operation request is determined whether comes from a second main database in a database system or outside the database system; if the data operation request comes from the second main database of the database system, synchronization data entry numbers from the second main database are recorded according to the data operation information; and the data operation instruction is executed. By the establishment of the database system with double-main databases, data real-time synchronization between the two main databases can be achieved; and yet-to-synchronized data can be timely supplemented after the two main databases restore communication, so data accidental loss can be avoided and data consistency after communication recovery can be greatly improved.

Description

technical field [0001] The present invention relates to the technical field of databases, in particular, the present invention relates to a database synchronization method and device. Background technique [0002] With the rapid development of network applications, people's requirements for the accuracy and timeliness of information are getting higher and higher. Database system is currently the most convenient and efficient means of storing data and retrieving information. Most enterprises store information in databases. The current trend of database systems is from miniaturization to large-scale, centralized to distributed. In distributed databases, data synchronization technology can ensure that data distributed in different locations is automatically updated synchronously, thereby ensuring data consistency. [0003] However, data loss or collapse may occur in the database at any point in time. The existing database system generally has a master-slave database architectu...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/27
CPCG06F16/27
Inventor 彭信东陈宗志杨挺杨艳杰
Owner BEIJING QIHOO TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products