当前位置：网站首页>Module 4 operation

Module 4 operation

2022-04-22 20:01:00 【InfoQ】

Design the test paper storage scheme of ten million student management system
【 Job requirements 】
Based on modules 4 The first 6 Estimation results and  Redis sentinel  Preliminary scheme design of , Improve the storage scheme of examination papers , Specific include :
•  perfect Redis Data structure design , Specify which kind of  Redis  data structure .
•  Design specific reading and writing processes ( It can be described by text or sequence diagram , The sequence diagram shall be accompanied by text ).
•  Control module 4 The first 6 Performance estimation results of the course , Calculation  Redis sentinel  Number and performance of servers in the cluster .


Redis Data structure design

For the test paper itself , use Redis Of set preservation ：
Key by "#Exam- School ID+ year + The test ID".Value For the content of the test paper , With JSON Format preservation .
use Redis Of set The structure saves the answer content of each test paper submitted by students , among ：
Key by " School ID+ year + Student ID+ The test ID" The combination of ,Value Answer for the test paper , With JSON string Save in the format of .

Specific reading and writing process

write in ：

  • Students submit test papers
  • Exam Service According to the content of the test paper, the corresponding JSON string
  • Exam Service Save data to Redis,Redis cluster Save the data to one of DB shard.
  • Data writing DB shard Of master node
  • master node Synchronize data to slave nodes


Read ：
null
from Redis When reading data , It can be downloaded from DB shard Of master or slave Any of them node Read from .


Performance estimation

From a computational point of view ：
Peek read QPS: 50K/s
Peek write QPS: 1700/s
because Redis Single machine performance can reach TPS 50K-100K/s. therefore 1 platform redis master Can cope with . As a result of Redis Sentinel, You need at least 2 platform slave. So at least 3 Taiwan machine ：1 master + 2 slaves.
From the perspective of data storage ：
Record the test results of students in school every year 2.4TB, And students leaving school 0.6TB. To be kept every year 3TB. One machine can basically meet the storage requirements . But it needs to add... Every year 1 slice DB Shard( namely 1 master + 2 slaves).


版权声明
本文为[InfoQ]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204221957594573.html

边栏推荐

猜你喜欢

随机推荐