Database service providing method and system

A database and primary database technology, applied in the computer field, can solve problems such as log loss, network instability, and logs that cannot be sent to the standby database in time, and achieve the effect of improving performance

Active Publication Date: 2021-01-08
ALIBABA GRP HLDG LTD
View PDF15 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] As can be seen from the above, in the prior art database service provision method, in the one-master-slave architecture, there will often occur between the master and the backup due to network instability (such as loss of data packets), network bottlenecks, or the performance of the backup library reaching performance. Bottlenecks (such as peak CPU utilization) that prevent logs from being sent to the standby database in time may lead to log loss

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
  • Database service providing method and system
  • Database service providing method and system
  • Database service providing method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0039] In order to make the purposes, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments It is a part of the embodiments of this application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.

[0040] In order to facilitate the understanding of the embodiments of the present application, the following will further explain and illustrate with specific embodiments in conjunction with the accompanying drawings, and the embodiments do not constitute a limitation to the embodiments of the present application.

[0041] figure 1 The database syste...

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

A service providing method and system for a database. The method comprises: when a master database server (301) receives a service providing request of a client, changing data in a database according to the service providing request, writing change information about the database into a first transaction log, and sending the first transaction log to a slave database server (302); and when a network connection between the master database server (301) and the slave database server (302) is disconnected or times out, or when the number of accumulated transaction logs, failing to be successfully sent, in the master database server (301) exceeds a pre-set value, or when the sending time of the first transaction log exceeds a pre-set time, the master database server (301) transmitting the first transaction log or information about an update object corresponding to the first transaction log to a buffer region (303). It can be seen therefrom that when a standby database temporarily cannot receive a log, a master database sends the log to the buffer region (303) so as to prevent the log from being lost.

Description

technical field [0001] This application relates to the field of computers, in particular to a database service providing method and system. Background technique [0002] Currently, database systems generally adopt a master-slave architecture of one master and one slave to provide high-availability services. Under normal circumstances, external services are provided by the main database server. If the process of the external service performs a change to the data, it will be written to the transaction log before writing the change to the database storage. Each log records the modification of a data record, which contains the primary key of the data record and the specific information of the update operation. The log generated by the master database server is continuously sent to the slave database server through the network connection. After the log is received from the database server, it is played back to synchronize its data with the main database server. For ease of de...

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 Patents(China)
IPC IPC(8): G06F16/23
CPCG06F16/2365H04L1/22
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

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