计算机科学 ›› 2012, Vol. 39 ›› Issue (Z11): 168-170.

• 软件工程 • 上一篇    下一篇

MySQL复制技术的研究及应用

张伟丽,江春华,魏劲超   

  1. (电子科技大学 成都610054)
  • 出版日期:2018-11-16 发布日期:2018-11-16

MySQL Replication Technology and its Applications

  • Online:2018-11-16 Published:2018-11-16

摘要: 数据库复制技术是提高数据库系统并发性和容错性的重要技术。通过复制,将数据存储于一个分布式的网络中,由多个数据库系统来提供数据访问服务,能大大地提高数据库的响应速度和并发能力。针对当前数据库应用现状,分析和对比了几大主流数据库ORACLE, SQL Server, Sybase , MySQL的复制技术以及原理,着重探讨了MySQL的复制原理及其在分布式数据库系统中的应用,并给出了MySQI的双向链式复制在分布式系统中的应用,达到了分布式系统中数据同步复制的目的。

关键词: MySQI,数据库,同步复制,异步复制,分布式数据库

Abstract: Database replication technology is an important technology which is aimed at improving the concurrency and fault tolerant of database systems. With replication technology, same data can be stored in distributed system. Because multiple database system provides data access services, database response and concurrency have been greatly improved.This paper is based on the current status of database system applications, analyzes and compares the replication technology of several major databases, such as ORACLE, SQL Server, Sybase and MySQL. This paper focuses on MySQL replication technology and its concrete application in distributed database systems. In addition, this paper also proposed a model of chain replication of MySQL in distributed system. All of these achieve the purpose of data replication in distributed system

Key words: MySQL,Database, Eager replication, Lazy replication, Distributed system

No related articles found!
Viewed
Full text


Abstract

Cited

  Shared   
  Discussed   
No Suggested Reading articles found!