Unlock instant, AI-driven research and patent intelligence for your innovation.

Method for highly concurrently accessing database based on mysql

A technology of database and incoming data, which is applied in the information field to achieve the effect of reducing the number of queries, promoting the application value, and avoiding cache avalanche

Inactive Publication Date: 2021-02-12
SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
View PDF4 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

With the passage of time and development, large-scale high-concurrency access and corresponding deployment architectures that need to be solved are also applied, such as mysql cluster deployment, redis cluster deployment, mysql+redis, etc. There are different usages in different scenarios, and too many deployments at the same time Although the service has many benefits, it is still a big problem for data synchronization

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 for highly concurrently accessing database based on mysql

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0020] The method for accessing the database based on mysql high concurrency in the present invention adds a redis cache on the mysql, and performs cache processing first when reading and writing, and accesses the database if the cache fails, wherein multiple redis nodes are used, and the master and slave nodes are used together.

[0021] Add multiple memory queues when incoming data, and adjust dynamically to achieve load balancing. Use the hash algorithm to perform hash remainder on the id value of the incoming data, and select a specific queue. When writing, write directly to the memory queue. For read operations, the cache is accessed. The cache loop takes out the read command from the queue. If it is a write command, delete the cache first, write it to the database, and synchronize redis after writing the database, and delete the update command in the queue. When the read operation queries the cache, if the cache is found, it will be returned to the client directly. If ...

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 method for highly concurrently accessing a database based on mysql, and belongs to the technical field of information. According to the method for accessing the database in the high concurrency mode based on mysql, redis cache is added to mysql, cache processing is conducted firstly during reading and writing, if the cache fails, the database is accessed, and a pluralityof redis nodes and master and slave nodes are used in cooperation. According to the mysql-based high-concurrency database access method, the problems of cache avalanche, cache penetration, cache breakdown and the like can be effectively avoided, an effect of synchronizing the data with the database can be achieved, and the method has good popularization and application values.

Description

technical field [0001] The invention relates to the field of information technology, and specifically provides a method for accessing a database with high concurrency based on mysql. Background technique [0002] Internet of everything, data first. In this Internet era of information explosion, information is the most important. As the number of users continues to grow, the corresponding data access and storage volume will increase exponentially. For the mysql database, when there are enough parallel visits, the database may not be able to support it, so the mysql master-slave distributed cluster deployment is introduced. When active users at the same time start to interact with information on a certain platform at the same time, the back-end data access will increase sharply, so it may not be realistic to solve this problem only by relying on the mysql database, so redis is introduced, and redis is stored in memory A kind of database in , the data reading speed is very f...

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): G06F16/2455G06F16/23
CPCG06F16/24552G06F16/23
Inventor 张咏雪魏金雷储佳祥杨继伟徐士强
Owner SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
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

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

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