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

【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 techno-logy 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.更多还原