{"title":"Research and Application of Distributed Cache Based on Redis","authors":"Lanying Shi","doi":"10.17706/jsw.19.1.1-8","DOIUrl":null,"url":null,"abstract":": As a traditional relational database, MySQL provides complete ACID operations, supports rich data types, powerful associated queries, where statements, etc., can easily establish query indexes, perform complex operations such as internal connection, external connection, summation, sorting, grouping, and support functions such as stored procedures. The product is highly mature and powerful. However, when databases face large-scale data access, disk I/O often becomes a performance bottleneck. In complex telecommunications business scenarios, high-frequency access to data such as product instances, sales product instances, product/sales product specifications, and accounts in telecommunications business can result in high database load and low efficiency if operated directly across tables or databases. Adopting distributed caching products can greatly improve performance and reduce database load. Therefore, this article proposes a distributed caching system to solve the disk I/O performance bottleneck caused by large-scale and high concurrency database access. It is a memory based, persistence, high-performance, highly reliable, and horizontally scalable distributed NoSQL memory database product. It supports memory management of sub databases and sub tables, provides disaster recovery, recovery, monitoring, migration and other capabilities, and supports transparent access for API provisioning.","PeriodicalId":519004,"journal":{"name":"Journal of Software","volume":"31 2","pages":""},"PeriodicalIF":0.0000,"publicationDate":"2024-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"Journal of Software","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.17706/jsw.19.1.1-8","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0
Abstract
: As a traditional relational database, MySQL provides complete ACID operations, supports rich data types, powerful associated queries, where statements, etc., can easily establish query indexes, perform complex operations such as internal connection, external connection, summation, sorting, grouping, and support functions such as stored procedures. The product is highly mature and powerful. However, when databases face large-scale data access, disk I/O often becomes a performance bottleneck. In complex telecommunications business scenarios, high-frequency access to data such as product instances, sales product instances, product/sales product specifications, and accounts in telecommunications business can result in high database load and low efficiency if operated directly across tables or databases. Adopting distributed caching products can greatly improve performance and reduce database load. Therefore, this article proposes a distributed caching system to solve the disk I/O performance bottleneck caused by large-scale and high concurrency database access. It is a memory based, persistence, high-performance, highly reliable, and horizontally scalable distributed NoSQL memory database product. It supports memory management of sub databases and sub tables, provides disaster recovery, recovery, monitoring, migration and other capabilities, and supports transparent access for API provisioning.