Observatorio de I+D+i UPM

Memorias de investigación
Conferences:
Leveraging the Scalability and Availability of Replicated Databases with Autonomic Capabilities.
Year:2009
Research Areas
  • Programming language
Information
Abstract
Replication is the main technique to increase the scalability of databases. Scalability is achieved by resorting to a combination of techniques such as more relaxed replication correctness criterion, e.g., 1-Copy-Snapshot-Isolation, asymmetric update processing, and partial replication. However, in order to obtain scalability in an effective way it needs to be accompanied by a number of autonomic capabilities like self-healing, self-optimization, self-configuration and self-provisioning. Each of them requires a particular mix of protocols such as online recovery, and dynamic load balancing. In this paper we provide a summary of the autonomic capabilities that have been incorporated into Middle-R, a middleware for scalable database replication. In order to attain self-healing capabilities, replication has been extended with online recovery what enables to recover failed replicas without disrupting transaction processing neither system performance. Self-optimization is attained at two different levels. At the local level, the multi-programming level is adapted to maximize replica throughput. At the global level, a dynamic online balancing protocol distributes the load evenly across replicas to maximize system throughput. In order to increase the scalability partial replication is used. Partial replicas are self-configured based on the monitoring of the access profile to reduce both replication overhead and latency. Finally, self-provisioning is enabled by means of online recovery. Online recovery enables to create new replicas without degrading system performance. Monitoring of the system load enables to decide when to add new replicas or remove them. Decommissioning of replicas is performed in combination with dynamic load balancing that redirects the load of the replica to be decommissioned to the other replicas and then removes the replica.
International
Si
1867-8211
Entity
Third International ICST Conference on Autonomic Computing and Communication Systems.
Entity Nationality
CHIPRE
Place
Limassol, Cyprus. Sept. 9-11, 2009.
Participants
  • Autor: Ricardo Jimenez Peris (UPM)
  • Autor: Damián Serrano García (UPM)
  • Autor: Jesús Milán Franco (UPM)
  • Autor: Marta Patiño Martinez (UPM)
Research Group, Departaments and Institutes related
  • Creador: Grupo de Investigación: Distributed Systems Labs (LSD) Laboratorio de sistemas distribuidos
  • Departamento: Lenguajes y Sistemas Informáticos e Ingeniería de Software
S2i 2019 Observatorio de investigación @ UPM con la colaboración del Consejo Social UPM
Cofinanciación del MINECO en el marco del Programa INNCIDE 2011 (OTR-2011-0236)
Cofinanciación del MINECO en el marco del Programa INNPACTO (IPT-020000-2010-22)