Master-standby redundancy replication method based on SQLite databases

A replication method and database technology, which are applied in the computer field to reduce the risk of failure, ensure data consistency and security, and meet the needs of redundant backup.

Active Publication Date: 2013-02-27
NARI TECH CO LTD
View PDF5 Cites 39 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the active / standby redundancy mechanism of the database requires each database to be deployed on different servers in the system, and to shield the influence of multiple databases and multiple hosts on the application program through unified management. Therefore, according to the existing SQLite database mode, there is no effective method to Implement SQLite-based master-slave redundancy mechanism

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
  • Master-standby redundancy replication method based on SQLite databases
  • Master-standby redundancy replication method based on SQLite databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] In order to make the technical means, creative features, goals and effects achieved by the present invention easy to understand, the present invention will be further described below in conjunction with specific embodiments.

[0020] Such as figure 2 Shown, the present invention is a kind of active-standby redundant replication method based on SQLite database, deploys a plurality of database service machines in its system, is configured into a master many standby mode, all has SQLite database and its corresponding SQLite service process on every server , the master and backup machines are configurable and expandable. The database service on the primary database receives the database modification request from the application, the SQLite service on the standby database receives the request from the primary database service, and the SQLite service processes on the primary and standby databases know their status through configuration files. On the basis of SQLite, the dat...

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 relates to a master-standby redundancy replication method based on SQLite databases. The method includes that database management service processes are packaged on the SQLite database and are responsible for monitoring states of the SQLite databases and receiving a database manipulation request sent by an application layer; an SQLite database synchronizing function is packaged in the SQLite service to achieve the master-standby redundancy replication of the SQLite database; master-standby databases can perform automatic shift according to states of the SQLite databases, only service processes on the master databases receive applied database modification requests, and the master databases are synchronized to the standby databases; and the service processes are also responsible for monitoring states of the SQLite databases and providing dump functions of SQLite data files to process recovery of failure databases, and the service processes compare differences of the SQLite data files on the databases and dump inconformity portions to a corresponding sever to guarantee uniformity of data of the databases. According to the master-standby redundancy replication method, on the basis of SQLite, the master-standby redundancy functions of the databases are achieved, the uniformity of the data of the databases is guaranteed, and stability and reliability of the online system data are guaranteed.

Description

technical field [0001] The invention belongs to the technical field of computers, in particular to an SQLite database-based active-standby redundant replication method. Background technique [0002] For online systems, it is becoming more and more important to maintain the reliability and security of system data, and the database service layer needs to provide complete disaster recovery and fault handling capabilities. The database architecture with one master and multiple backups can effectively meet this requirement, and it is one of the key technologies to provide complete, accurate and reliable basic data. [0003] Active-standby redundant replication refers to reflecting the modification of the primary database to the standby database in the running database system to ensure the data consistency of the primary and standby databases. Due to the characteristics of the SQLite database itself, the server and client of the database run in the same process, so the SQLite da...

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): G06F11/14G06F17/30
Inventor 史浩秋季学纯李昊王玉军
Owner NARI 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