期刊文献+

在云平台中高可用性数据库MySQL的设计与实现 被引量:5

Design and Implementation of MySQL Database Availability Based on Cloud Platform
下载PDF
导出
摘要 为了解决OpenStack云平台环境中节点的MySQL数据库在海量数据增长和高并发的访问状态下存在的单点瓶颈、存储扩展性差、可靠性低等问题,实现了一种Ceph分布式文件系统的高可用MySQL数据库集群系统。通过该技术消除单个节点的瓶颈问题,提高可靠性和可用性,同时也为存储数据提供安全性和扩展性。通过优化模型提高故障的切换效率。实验表明,基于云平台的MySQL集群的高可用性可用实现节点失效情况下的故障切换和底层数据的存储扩展,该模型的可用性有效减少故障切换的时间。 In order to solve the problem of single point bottlenecks,poor storage scalability,and low reliability of the MySQL database of nodes in the OpenStack cloud platform in the state of massive data growth and high concurrent access,MySQL database cluster system is realized with a high availability of Ceph distributed file system.This technology eliminates the bottleneck problem of individual nodes,improves reliability and availability,and also provides security and scalability for storing data.The switching efficiency of faults is improved by optimizing the model.Experiments show that the high availability of the MySQL cluster based on the cloud platform can be used to achieve failover and storage expansion of the underlying data in case of node failure.The availability of this model can effectively reduce the time for failover.
作者 王素丽 WANG Suli(Department of Computer,Guangzhou College of South China University of Technology,Guangzhou 510800)
出处 《计算机与数字工程》 2020年第7期1633-1637,1654,共6页 Computer & Digital Engineering
关键词 云平台 高可用性 故障切换 MYSQL数据库 Ceph分布式文件系统 cloud platform high availability failover MySQL database Ceph distributed file system
  • 相关文献

参考文献6

二级参考文献24

  • 1张伟丽,江春华,魏劲超.MySQL复制技术的研究及应用[J].计算机科学,2012,39(S3):168-170. 被引量:20
  • 2盖九宇,张忠能,肖鹤.分布式数据库数据复制技术的分析与应用[J].计算机应用与软件,2005,22(7):36-38. 被引量:37
  • 3赵铁柱.分布式文件系统性能建模及应用研究:[PhDThe-sis ] [D].广州:华南理工大学,2011.
  • 4SABAP.深入理解MySQL核心技术[M].李芳,于红芸,邵健,译.北京:中国电力出版社,2009.
  • 5简朝阳.MySQL数据库性能优化之存储引擎选择[EB/OL].(2012-09-10)[2012-11-05]http://isky000.com/database/mysql-performance-tuning-storage-en-Sine.
  • 6刘晓霞,钟鸣.MySQL必知必会[M].北京:人民邮电出版社,2009.
  • 7简朝阳.MySQL性能调优与架构设计[M].北京:电子工业出版社,2012.
  • 8Veda.数据库水平切分的两个思路[EB/OL].(2012-03-02)[2012-11-07]http://www.nowamagic.net/li-brarys/veda/detml/1528.
  • 9Filip. I,Vasar. C,Robu. R.Considerations about an Oracle database multi-master replication. International Symposium on Applied Computational Intelligence and Informatics . 2009
  • 10Juarez-Rodriguez J R,Armendariz-Inigo J E,de Mendivil J R G,et al.A Database Replication Protocol Where Multicast Writesets Are Always Committed. The Third International Con-ference on Availability.Reliability and Security . 2008

共引文献153

同被引文献52

引证文献5

二级引证文献16

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部