一种基于组通信的数据库复制的实现

An Implementation of Database Replication Based on Group Communication

基于组通信系统的数据库复制将一些单个的数据库组织成一个逻辑数据库,可以提高其可用性和产量并支持更多用户。中间层数据复制用一种中间层的C/S模式来截取客户端和数据库交互的数据流,将用户请求送到所有节点执行。组通信系统和2PC被用来保证复制数据库严格的一致性。本文提出了一种面向操作的复制协议和一种面向事务的记录一重放协议。基于组通信系统的发展和国产的DBMS of Kingbase模式,面向操作的复制服务得到了实现。本文的工作表明利用组通信可以在中间层实现透明复制并可以取得较好的性能。

Database replication based on group communication system that organizes several single databases as a logical database can improve availability, throughput and support more clients. Replication middleware can catch data stream between server and client with an additional middle layer of C/S mode,send request to multiple database nodes to execute while group communication system and 2PC are used to guarantee strict data consistency. This paper presents an operation-oriented replication protocol and a transaction-oriented Record-Replay Protocol. Based on group communication system of Spread and homemade DBMS of Kinghase,operation-oriented replication server has been implemented. Measurement conducted on two nodes shows that the performance and stability of replicated database are better than non-replicated database in read intensive environment remarkably.