Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method for hot standby of dual database servers

A dual-machine hot backup and database technology, applied in the field of database systems, can solve the problems of not being able to find the main and standby databases in time, inconsistency, and not being able to give alarms and processing in time, so as to achieve both data access reliability and data access performance, Achieve completeness and consistency, improve the effect of data consolidation

Inactive Publication Date: 2013-05-01
BEIJING JIAXUN FEIHONG ELECTRIC CO LTD
View PDF4 Cites 35 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] In addition, the above-mentioned schemes often cannot detect the inconsistency of the primary and standby databases in time, so they cannot give alarms and handle them in time

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 for hot standby of dual database servers
  • Method for hot standby of dual database servers
  • Method for hot standby of dual database servers

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0044] The invention provides a method for realizing dual-computer hot backup of database servers. Between the active database server and the standby database server, regular handshake, master-slave negotiation, master-standby switchover, data access and data synchronization are performed through the synchronization network port. The business network port of the database server uses a virtual IP address to provide database services externally. The database client uses the virtual IP address to access the primary database server using the TCP protocol.

[0045] The preferred embodiments will be described in detail below in conjunction with the accompanying drawings.

[0046] Such as figure 1 Shown is a dual-machine hot standby system including a data access client, a primary database server, and a standby database server.

[0047] (1) The regular handshake and master-standby switchover process between the master and standby machines are as follows:

[0048] a) The host uses ...

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 method for the hot standby of dual database servers in the technical field of database systems. A system comprises an active database server and a standby database server. The two servers perform regular handshake, master-slave negotiation, data access and data synchronization through a synchronization network port. A server network port of the active database server employs a virtual Internet protocol (IP) address to externally provide server service, and a service network port of the standby database server does not externally provide database service. A database client accesses the active database server through the virtual IP address by adopting a transmission control protocol (TCP). A flexibly selectable real-time / quasi-real-time database synchronization mechanism, a comprehensive data consistency detection method for the active and standby database servers and a selectable data consistency recovery means are provided by the invention.

Description

technical field [0001] The invention belongs to the technical field of database systems, and in particular relates to a method for dual-machine hot backup of database servers. Background technique [0002] There are currently several types of database dual-machine hot backup technologies: [0003] (1) Dual-machine hot backup technology based on the shared storage device of the main and standby servers [0004] The disadvantage of this solution is that it is not convenient to realize physical disaster recovery and backup because of the shared storage device. [0005] (2) Log-based primary and standby database replication technology [0006] Although this scheme can realize the replication and backup of the database, it cannot guarantee the consistency of the database, nor can it detect the data inconsistency in the main and standby databases in time. [0007] (3) Database redundancy backup technology based on cluster technology [0008] Although this solution is relativel...

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
IPC IPC(8): G06F17/30H04L12/703H04L29/08H04L29/12H04L12/24H04L45/28
Inventor 单洪政
Owner BEIJING JIAXUN FEIHONG ELECTRIC CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products