基于缓存和分库组件的在线培训数据系统研发与应用  

Development and Application of DB Service System Based on Redis and MyCAT

作　　者：金华 JIN Hua(Shanghai Pudong Software Park Co.,Ltd.,Shanghai 201203)

机构地区：[1]上海浦东软件园股份有限公司,上海201203

出　　处：《电脑与电信》2021年第1期37-40,45,共5页Computer & Telecommunication

摘　　要：在当前的培训行业中,在线培训已经成为一种趋势,尤其在上海市浦东软件园里,众多园内企业更希望通过在线培训平台得到各种职业技能培训服务。对此上海市浦东软件园职业技能培训中心研发了一套在线培训平台。为应对高并发的培训访问量,本系统的数据服务子系统一方面引入了MyCAT组件实现了海量数据的分库存储,提升了操作培训相关数据的性能;另一方面引入了基于Redis哨兵框架的缓存机制,提升了数据服务的性能。系统在投入使用后,能满足线上高并发和大数据量的要求,在数据服务层面为本在线培训平台提供了坚实的保障。In current training trade,online training has become more and more popular,especially in Shanghai Pudong Software Park,many IT companies want to train their employee by online mode.Therefore the skill training center of Shanghai Pudong Software Park developed an online training system.In order to satisfy the high volume of the request,the DB Service System of this system uses the MyCAT component to store the data in splitted DB.And in order to improve the efficiency,the DB Service System uses the Redis sentinel cluster to cache the data.After the release,the system works well,and provides the solid support for the online training system.

关 键 词：IT培训 MyCAT REDIS 缓存 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]