Supercharge Your Innovation With Domain-Expert AI Agents!

Replication for on-line hot-standby database

A database and duplicator technology, applied in the field of duplicators, can solve problems such as the increased risk of fatal errors, and achieve the effect of fast transmission speed

Active Publication Date: 2016-02-17
INT BUSINESS MASCH CORP
View PDF3 Cites 21 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If the backup node cannot catch up to the primary node after the first failure, the risk of fatal errors in the future increases

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
  • Replication for on-line hot-standby database
  • Replication for on-line hot-standby database
  • Replication for on-line hot-standby database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0046] refer to figure 1 , describes a deployment diagram of a preferred embodiment in the hot standby database system 10 . The hot standby database system 10 is operable with numerous other general purpose or special purpose computing system environments or configurations. Examples of known computer processing systems, environments and / or configurations suitable for use with the hot standby database system 10 include, but are not limited to: personal computer systems, server computer systems, thin clients, fat clients, handheld or portable devices, multi Processor systems, microprocessor-based systems, set-top boxes, programmable consumer electronic devices, network computer systems, microcomputer systems, mainframe computer systems, and distributed cloud computing environments including any of the foregoing.

[0047] Hot standby database system 10 may be described in the general context of computer system executable instructions, such as program modules, being executed by a...

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

This invention relates to a system, method and computer program product for replicating a database image from an operational primary node to a backup node in a distributed database environment, said method comprising: defining a checkpoint image of the primary node including a database structure and a plurality of database pages; creating a replica database on a backup node by initiating a backup node and saving the defined structure on the initiated backup node; sending each database page of the checkpoint image for saving on the backup node; saving, after creation of a checkpoint image is started, every transaction on the primary node and creating a corresponding REDO transaction for sending to the backup node; identifying each data page operated on by each REDO transaction; sending, in parallel with the sending of the database pages, each created REDO transaction to the backup node in the order in which the corresponding transaction occurred so that the backup node can replicate the transactions in the correct order; and prioritizing each identified database page so that it arrives at the backup node before or substantially at the same time as a corresponding REDO transaction whereby the corresponding REDO transaction operates on the identified database page without waiting for every database page to be saved on the backup node.

Description

technical field [0001] The invention relates to a duplicator method and device for online hot backup database. Background technique [0002] In a hot standby (HSB) database, transactions are committed in two phases, and both the primary and backup nodes must successfully endorse changes before the transaction is considered properly committed. This is a two-phase commit (2PC) protocol that guarantees that the databases at both nodes always have the same state. 2PC is the Atomic Commit Protocol (ACP), and is a specialized type of consensus protocol for coordinating whether all processes participating in a distributed atomic transaction commit or abort (rollback) the transaction. Some HSB databases offer users the option to trade consistency of performance by offering more relaxed transactions. Such transactions are defined in the Two-Stage Safe Receive (2SR) protocol, where the primary node agrees as long as the backup node agrees that it has received all log records for the...

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
CPCG06F16/27G06F16/273G06F11/1446G06F11/1471G06F16/275
Inventor V·T·拉迪卡J·林德斯托姆K·莱胡J·帕金恩
Owner INT BUSINESS MASCH CORP
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com