Home > Papers

 
 
A Database Architecture of E-commerce System with High Availability and Scalability based on MySQL and Redis
CUI Yansong 1,BAI Chunyu 2 *
1.Beijing University of Posts and Telecommunications,Beijing 100876;Beijing University of Posts and Telecommunications,Beijing 100876
2.
*Correspondence author
#Submitted by
Subject:
Funding: none
Opened online:18 January 2021
Accepted by: none
Citation: CUI Yansong,BAI Chunyu.A Database Architecture of E-commerce System with High Availability and Scalability based on MySQL and Redis[OL]. [18 January 2021] http://en.paper.edu.cn/en_releasepaper/content/4753448
 
 
With the continuous development of e-commerce systems, data storage has become a crucial technology in this era, and building a database environment with high-availability has become an urgent demand of many enterprises. In order to prevent web application crashes caused by database server downtime, this paper proposes a database architecture of e-commerce system with high availability and scalability based on MySQL and Redis. The architecture implements read-write separation and automatic switching when the server goes down to ensure high availability of e-commerce systems. It uses the sentinel to build Redis cluster, while reducing database access pressure and preventing cache invalidation caused by Redis server downtime. It builds a database cluster based on MySQL replication, which can ensure real-time synchronization and disaster recovery of data between database servers and improve scalability of system. Finally, this paper implemented an e-commerce system based on this architecture.
Keywords:computer application technology; high availability; scalability; MySQL cluster; Redis cluster; database architecture
 
 
 

For this paper

  • PDF (0B)
  • ● Revision 0   
  • ● Print this paper
  • ● Recommend this paper to a friend
  • ● Add to my favorite list

    Saved Papers

    Please enter a name for this paper to be shown in your personalized Saved Papers list

Tags

Add yours

Related Papers

Statistics

PDF Downloaded 57
Bookmarked 0
Recommend 0
Comments Array
Submit your papers