Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Distributed cache method and system based on mysql binlog

A distributed cache and database technology, applied in the field of information processing, can solve problems such as mysql performance bottlenecks, user access request delays, and mysql pressure, and achieve the effects of reducing pressure, reducing request delays, and ensuring timeliness

Inactive Publication Date: 2017-03-08
BEIJING GEO POLYMERIZATION TECH
View PDF6 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If there are a large number of users accessing the application, and the data requested by these users is not in the distributed cache, at this time, a large number of user accesses can only query mysql, which will cause a lot of pressure on mysql, and mysql will become the performance of the entire application Bottleneck, a large amount of delay in user access requests, which seriously affects the user experience

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
  • Distributed cache method and system based on mysql binlog

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0016] Such as figure 1 As shown, this distributed cache method based on mysql binlog includes the following steps:

[0017] (1) Enable the binary log file binlog of the mysql database;

[0018] (2) When the data is directly written into the mysql database, the updated data is written to the binlog file at the same time;

[0019] (3) Parse the binlog file, and write the data changed in the database to the distributed cache in real time;

[0020] (4) When the user accesses (the application program), the data is directly obtained from the distributed cache.

[0021] The present invention realizes real-time data caching through binlog, which ensures the timeliness of distributed cache data; when users access, they can directly obtain data from distributed cache, and no longer need to visit mysql, which reduces the pressure on mysql database; all user requests apply All programs can be obtained through the distributed cache, which reduces the request delay and improves the user...

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 discloses a distributed cache method based on mysql binlog. The method guarantees promptness of distributed cache data, reduces pressure of a mysql database, lowers a request delay and improves user experience. The method includes: (1) starting using a binary log file binlog of the mysql database; (2) when data is directly written in the mysql database, writing updated data in the binlog file synchronously; (3) parsing the binlog file, and writing changing data of the database in real time in distributed cache; and (4) when a user accesses, directly acquiring the data from the distributed cache. The invention also discloses a distributed cache system based on mysql binlog.

Description

technical field [0001] The present invention relates to the technical field of information processing, in particular to a distributed cache method based on mysql binlog and a distributed cache system based on mysql binlog. Background technique [0002] Existing technical solutions: When a user accesses an application, the application first obtains cached data from the distributed cache according to the key. If there is no cached data corresponding to the key in the distributed cache, the application queries the data from mysql and returns to the user, while updating the data to the distributed cache. If there are a large number of users accessing the application, and the data requested by these users is not in the distributed cache, at this time, a large number of user accesses can only query mysql, which will cause a lot of pressure on mysql, and mysql will become the performance of the entire application Bottlenecks, user access requests experience a large amount of delay...

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 Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/24552G06F16/25
Inventor 张书凡张翼温宗臣何良均冯森林李冰范卫卫
Owner BEIJING GEO POLYMERIZATION TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com