Supercharge Your Innovation With Domain-Expert AI Agents!

Data access method, database device and master-slave database instance system

A data access and database technology, applied in the field of database instances, which can solve problems such as inability to access the latest data

Active Publication Date: 2019-01-11
CHINANETCENT TECH
View PDF2 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The inventor found at least the following problems in the prior art: when the latest data has just been added to the master database instance, and the middleware randomly routes the data access request to the slave database instance, since the data between the master and slave database instances has not yet been synchronized , that is, the latest data has not been added from the database instance, resulting in inability to access the latest data

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
  • Data access method, database device and master-slave database instance system
  • Data access method, database device and master-slave database instance system
  • Data access method, database device and master-slave database instance system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention more clear, various implementation modes of the present invention will be described in detail below in conjunction with the accompanying drawings. However, those of ordinary skill in the art can understand that, in each implementation manner of the present invention, many technical details are provided for readers to better understand the present application. However, even without these technical details and various changes and modifications based on the following implementation modes, the technical solution claimed in this application can also be realized.

[0026] The first embodiment of the present invention relates to a data access method, which is applied to the middleware of the master-slave database instance system. The master-slave database instance system includes a master database instance and at least one slave database instance. Requests are routed to...

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 embodiment of the invention relates to the technical field of a database, and discloses a data access method, a database device and a master-slave database instance system. The data access methodis applied to a middleware of a master-slave database instance system, the master-slave database instance system comprising a master database instance and at least one slave database instance. The data access method comprises: when a data manipulation command is received, timing is started and a data manipulation command is routed to the master database instance; if the data query command is received before the timing ends, the data query command is routed to the master database instance, wherein the timing is longer than or equal to the maximum delay time for data synchronization between themaster and slave database instances. In the invention, when the data in the master database instance and the data in the slave database instance are inconsistent, the latest data in the master database instance can be accessed.

Description

technical field [0001] The embodiments of the present invention relate to the technical field of database instances, and in particular to a data access method, database equipment, and a master-slave database instance system. Background technique [0002] At present, based on the high availability and performance considerations of the database instance, the database instance will be expanded horizontally, and the master-slave synchronization architecture is generally adopted, for example, one master and one slave or one master and multiple slaves, and the master-slave database instances generally adopt asynchronous The way of replication, that is, the data in the slave database instance has different degrees of delay relative to the master database instance. In order to make full use of the resources of the secondary database instance and reduce the pressure on the primary database instance, data access is generally distributed randomly through the middleware, that is, the mi...

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/27
Inventor 闫颖颖
Owner CHINANETCENT TECH
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