You are here

Miguel Araújo defends master dissertation entitled "Database Replication in Large Scale Systems"

Miguel Gonçalves de Araújo has requested the defence of his dissertation, entitled "Database Replication in Large Scale Systems". The defence will be held in room A2 of the Departamento de Informática, on July 29, 2011, 3:30pm. The public is invited.

The examining committee is the following:

  • João M. Fernandes (UMinho) - president
  • Pedro Souto (U Porto) - opponent
  • José Orlando Pereira (UMinho) - supervisor

Abstract

There is nowadays an increasing need for database replication, as the construction of high performance, highly available, and large-scale applications depends on it to maintain data synchronized across multiple servers and to achieve fault tolerance.

A particularly popular approach, is the MySQL open source database management system and its built-in asynchronous replication mechanism. The limitations imposed
by MySQL on replication topologies mean that data has to go through a number of hops or each server has to handle a large number of slaves. This is particularly worrisome
when updates are accepted by multiple replicas and in large systems. Noting the most common topologies and taking into account the asynchrony referred, a problem arises,
the freshness of the data, i.e. the fact that the replicas do not have just the most recently written data. This problem contrasts with the state of the art in group communication.

In this context, the work presented in this Master’s thesis is the result of an evaluation of the models and mechanisms for group communication, as well as the practical advantages of group-based replication. The proposed solution extends the MySQL Proxy tool with plug-ins combined with the Spread group communication system offering, transparently, active and passive replication.

Finally, to evaluate the proposed and implemented solution we used the reference workload defined by the TPC-C benchmark, widely used to measure the performance
of commercial databases. Under this specification, we have evaluated our proposal on different scenarios and configurations.

19.07.2011

home contacts RSS Feed last update: 06-Dec-2019 share facebook
Drupal theme by pixeljets.com D7 ver.1.1