Main and standby database delay time processing method and device, medium and electronic equipment

A delay time and processing method technology, applied in the computer field, can solve the problems of not being able to set different read and write delay timeout times, unable to modify the read and write delay timeout time in real time and respond immediately, unable to read and write delay alarms, etc., to save manpower and material resources. Cost, system development is simple and convenient, and the effect of a wide range of applications

Inactive Publication Date: 2019-07-16
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF5 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, there are the following problems in the current related technology using the database MySQL-Proxy plug-in to write Lua scripts, for example, it is not possible to set different read and write delay timeo

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
  • Main and standby database delay time processing method and device, medium and electronic equipment
  • Main and standby database delay time processing method and device, medium and electronic equipment
  • Main and standby database delay time processing method and device, medium and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0056] Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete and will fully convey the concept of example embodiments to those skilled in the art. The described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments.

[0057] Furthermore, the drawings are merely schematic illustrations of the present disclosure and are not necessarily drawn to scale. The same reference numerals in the drawings denote the same or similar parts, and thus repeated descriptions thereof will be omitted. Some of the block diagrams shown in the drawings are functional entities and do not necessarily correspond to physically or logically separate entities. These functional entities ...

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 main and standby database delay time processing method and device, a storage medium and electronic equipment. The method comprises the following steps: monitoring a preset operation method of a data access object DAO layer, and judging the category of the preset operation method according to a preset annotation carried by the preset operation method; when it is judged that the preset operation method is a query operation, obtaining a delay data difference threshold value corresponding to the query operation from a preset annotation, wherein the delay data differencethreshold value is in direct proportion to the read-write delay time; obtaining the maximum first data record ID in the current main database and the standby database, and calculating the difference between the two obtained maximum first data record IDs; and comparing the difference value with a delay data difference threshold, and if the difference value is greater than or equal to the delay datadifference threshold, routing the corresponding query operation to the main database. According to the invention, different read-write delay times can be set for different service scenes, the application range is wide, the scheme development is simple and convenient, and the manpower and material resource cost is saved.

Description

technical field [0001] The present disclosure relates to the field of computer technology, and in particular to a delay time processing method for active and standby databases, a delay time processing device for active and standby databases, and a computer-readable storage medium and electronic equipment for implementing the delay time processing method for active and standby databases. Background technique [0002] At present, in order to alleviate the pressure on database servers, many companies such as large Internet companies often use databases with read-write separation between active and standby. The principle of master-slave read-write separation is to route the operations of modifying data to the primary database for execution, and route the operations of querying data to the standby database for execution, and then use the master-slave replication function of the database to synchronize the operations of the primary database to the standby database. database to ens...

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): G06F16/23G06F16/27
CPCG06F16/2365G06F16/275
Inventor 肖竹
Owner BEIJING JINGDONG SHANGKE INFORMATION 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

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