Group-based replication of on-line transaction processing servers

• Author(s): Correia Júnior, Alfrânio Tavares ; Sousa, António Luís Pinto Ferreira de ; Soares, L. ; Pereira, José, 1973- ; Moura, Francisco Coelho Soares ; Oliveira, Rui Carlos Mendes de
• Date: 2005
• Persistent ID: http://hdl.handle.net/1822/6274
• Origin: RepositóriUM - Universidade do Minho
• Subject(s): Distributed systems; Databases
• Document Type: Article
• Language: English

Description

Several techniques for database replication using group communication have recently been proposed, namely, the Database State Machine, Postgres-R, and the NODO protocol. Although all rely on a totally ordered multicast for consistency, they differ substantially on how multicast is used. This results in different performance trade-offs which are hard to compare as each protocol is presented using a different load scenario and evaluation method. In this paper we evaluate the suitability of such protocols for replication of On-Line Transaction Processing (OLTP) applications in clusters of servers and over wide area networks. This is achieved by implementing them using a common infra-structure and by using a standard workload. The results allows us to select the best protocol regarding performance and scalability in a demanding but realistic usage scenario.