Method and equipment for achieving transaction commit in active-standby synchronization mode

A transaction submission and synchronization mode technology, applied in the computer field, can solve the problems of long submission completion time and transaction submission completion time, and achieve the effect of improving speed and optimizing user experience.

Active Publication Date: 2017-06-09
ALIBABA GRP HLDG LTD
View PDF4 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The purpose of this application is to provide a method and device for implementing transaction submission in the master-slave synchronization mode, so as to solve the problem that the transaction submission completion time is too long in the existing master-slave synchronization mode
[0005] In order to achieve the above purpose, according to one asp

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 equipment for achieving transaction commit in active-standby synchronization mode
  • Method and equipment for achieving transaction commit in active-standby synchronization mode
  • Method and equipment for achieving transaction commit in active-standby synchronization mode

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] The application will be described in further detail below in conjunction with the accompanying drawings.

[0035] In a typical configuration of the present application, the terminal, the device serving the network and the trusted party all include one or more processors (CPUs), input / output interfaces, network interfaces and memory.

[0036] Memory may include non-permanent storage in computer-readable media, in the form of random access memory (RAM) and / or nonvolatile memory, such as read-only memory (ROM) or flash memory (flashRAM). Memory is an example of computer readable media.

[0037] Computer-readable media, including both permanent and non-permanent, removable and non-removable media, can be implemented by any method or technology for storage of information. Information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), sta...

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 aims at providing a method and equipment for achieving transaction commit in an active-standby synchronization mode. Specifically, the method comprises the steps: sending a transaction number corresponding to a transaction and a former log number of a transaction commit request to a standby database when an active database receives the transaction commit request from a use; performing a transaction commit operation; detecting whether former log information corresponding to the transaction has been received by the standby database or not; sending a transaction commit finishing notification to the user if the former log information has been received. Compared with the prior art, the method and the equipment has the advantages that when the active database receives the transaction commit request from the user, the active database sends the transaction number corresponding to the transaction and the former log number of the transaction commit request to the corresponding standby database, performs the transaction commit operation, then, detects whether sent former log information has been received by the standby database or not and sends the transaction commit request finishing notification to the user if the former log information has been received by the standby database, so that the speed of transaction commit of databases and database performance are improved, and the user experience is optimized.

Description

technical field [0001] The present application relates to the computer field, and in particular to a technology for implementing transaction submission in a master-standby synchronization mode. Background technique [0002] With the advent of the era of big data, the surge in data processing has led to the development of databases. Generally, the primary database and the standby database are used to jointly ensure the high reliability of the database. Synchronous mode is used for data backup. In the prior art, when submitting a database transaction, the primary database server needs to send all logs of the transaction to the standby data server and the primary database server completes the database transaction submission only after the standby database server has received the feedback. and notify the user. [0003] However, in the prior art, when database transactions are submitted in the active-standby synchronization mode, there is often a network delay between the primar...

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): G06F11/14G06F17/30
CPCG06F11/1461G06F16/273
Inventor 张广舟林晓斌范孝剑周正中张文杰
Owner ALIBABA GRP HLDG 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