Method, system and equipment for realizing consistency of database and cache and storage medium

A database and consistent technology, applied in the field of artificial intelligence training, can solve problems such as resource consumption, data inconsistency, and complex deployment, and achieve the effect of ensuring continuity and timeliness

Pending Publication Date: 2022-05-24
SUZHOU LANGCHAO INTELLIGENT TECH CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For the scheme of updating the cache by monitoring binlog changes, the open source canal is often used, but canal adopts the client-server (client-server) mode, which is more complicated to deploy and requires additional resource consumption and maintenance overhead. And canal is a complete and independent package, which cannot be directly integrated with springboot
In addition, when updating the cache by monitoring binlog changes, the cache update is generally performed by directly monitoring the change content of the binlog. In this way, when the database is deployed in a cluster, if it involves failover between nodes, data inconsistency will occur.

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, system and equipment for realizing consistency of database and cache and storage medium
  • Method, system and equipment for realizing consistency of database and cache and storage medium
  • Method, system and equipment for realizing consistency of database and cache and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] In order to make the objectives, technical solutions and advantages of the present invention more clearly understood, the embodiments of the present invention will be further described in detail below with reference to the specific embodiments and the accompanying drawings.

[0027] It should be noted that all expressions using "first" and "second" in the embodiments of the present invention are for the purpose of distinguishing two entities with the same name but not the same or non-identical parameters. It can be seen that "first" and "second" It is only for the convenience of expression and should not be construed as a limitation to the embodiments of the present invention, and subsequent embodiments will not describe them one by one.

[0028] In a first aspect of the embodiments of the present invention, an embodiment of a method for implementing database and cache coherency is provided. figure 1 Shown is a schematic diagram of an embodiment of the method for implem...

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 provides a method, a system and equipment for realizing consistency of a database and a cache, and a storage medium. The method comprises the following steps: configuring a log file synchronization tool; configuring a user name and a password of a database monitored by the log file synchronization tool to establish connection between the log file synchronization tool and the database; configuring an address and a port number of a Redis cluster butted with the log file synchronization tool so as to establish connection between the log file synchronization tool and the Redis cluster; and mapping the update content in the database to the corresponding cache data to be updated. According to the method and the device, the change of the database log file can be monitored under the condition of not invading a business system code, and meanwhile, the monitoring can be carried out under the condition that node fault switching occurs in the database, so that the monitoring continuity is ensured.

Description

technical field [0001] The present invention relates to the field of artificial intelligence training, and more particularly, to a method, system, device and storage medium for realizing database and cache consistency. Background technique [0002] In the design and development process of the artificial intelligence training platform, in consideration of reducing the pressure on the database in a high concurrency environment, a distributed cache is introduced, which is used to add a layer of cache before the database when a large number of read and write operations flock to the database, thereby Improve the response speed of the system and reduce the pressure on the database. However, due to the introduction of the cache and the complexity of the system design, the first thing to consider is how to ensure the data consistency between the database and the cache. In a distributed situation, whether the database is updated first or the cache is updated first, there will be tim...

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/18G06F16/178G06F16/172G06F16/17G06F16/23G06F16/25
CPCG06F16/1815G06F16/178G06F16/172G06F16/1734G06F16/23G06F16/25Y02D10/00
Inventor李世刚
OwnerSUZHOU LANGCHAO INTELLIGENT TECH CO LTD