Method and device for synchronizing database

A database and master database technology, applied in the database field, can solve problems such as large delays in database synchronization operations and aggravate database server operating loads, and achieve the effect of reducing operation delays and operating loads

Active Publication Date: 2015-08-12
GUANGDONG EFLYCLOUD COMPUTING CO LTD
View PDF6 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The disadvantage of using diary records at present is that the existing database needs to be configured to generate corresponding log records; if the database operation is frequent, this method will generate a large number of log records, because the database first executes the operation after Go write the log record
This will significantly increase the operating load of the database server, causing the operation delay of the database synchronization operation to be too large

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 synchronizing database
  • Method and device for synchronizing database
  • Method and device for synchronizing database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0025] This embodiment provides a technical solution of a database synchronization method. The database synchronization method is implemented by a database synchronization device. The database synchronization device is integrated in a database proxy server, and the database proxy server is usually deployed between the client used by the user and the database server, and is connected to the client and the database server respectively for Performs a synchronization operation on the database on the database server.

[0026] see figure 1 , the database synchronization method includes: step 11 to step 14.

[0027] In step 11, the user instruction input by the user is read.

[0028] The user will send user instructions to the main database through the client connected to the database agent. The user commands include read commands and write commands. The read instruction refers to a user instruction that only reads the data stored in the database without changing the stored cont...

Embodiment 2

[0041] This embodiment further provides another technical solution of the database synchronization method based on the foregoing embodiments of the present invention. In this technical solution, before sending the user instruction to the main database for execution, it also includes: judging whether the user instruction is a read instruction or a write instruction; if the user instruction is a write instruction, sending the user instruction Give backup database.

[0042] see figure 2 , in this embodiment, the database synchronization method includes: Step 21 to Step 26.

[0043] In step 21, user instructions input by the user are read.

[0044] In step 22, it is judged whether the user instruction is a read instruction or a write instruction.

[0045] In this embodiment, the database agent is not only connected to the main database through the network, but also connected to a backup database through the network. The backup database is used to back up the data stored in th...

Embodiment 3

[0055] Based on the foregoing embodiments of the present invention, this embodiment further provides another technical solution of a database synchronization method. In this technical solution, after sending the user instruction to the backup database, it further includes: reading the backup result returned by the backup database after executing the user instruction; and forwarding the backup return result to the user.

[0056] see image 3 , in this embodiment, the database synchronization method includes: Step 31 to Step 38.

[0057] In step 31, user instructions input by the user are read.

[0058] In step 32, it is judged whether the user instruction is a read instruction or a write instruction.

[0059] In step 33, if the user instruction is a write instruction, send the user instruction to the backup database.

[0060] In step 34, the result returned by the backup after the backup database executes the user instruction is read.

[0061] After the backup database exec...

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 embodiment of the invention provides a method and a device for synchronizing a database. The method for synchronizing the database comprises the following steps of reading a user instruction inputted by a user; sending the user instruction to a main database to execute; reading the return result after the main database executes the user instruction; forwarding the return result of the main database to the user. The method and the device for synchronizing the database provided by the embodiment have the advantage that the delay of synchronizing of the database is obviously reduced.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a database synchronization method and device. Background technique [0002] With the development of information technology and market, data management is no longer just storing and managing data, but has transformed into various data management methods required by users. In computer system applications, the database is the core of the current application system processing, and the requirements for data security are extremely high. Database is a common tool for data persistence, so many technical issues need to be studied, such as data synchronization, data security, data backup, and data recovery. [0003] Existing database disaster recovery and recovery technologies are usually realized by means of database synchronization. At present, the most used method is to use diary records. For example, the database generates a diary record after writing a record, and the backup databa...

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 Applications(China)
IPC IPC(8): G06F17/30
Inventor 麦剑史伟闵宇梁润强李坤祥叶浩斌
Owner GUANGDONG EFLYCLOUD COMPUTING 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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap