Self-tunable DBMS Replication with Reinforcement Learning - Distributed Applications and Interoperable Systems
Conference Papers Year : 2020

Self-tunable DBMS Replication with Reinforcement Learning

Abstract

Fault-tolerance is a core feature in distributed database systems, particularly the ones deployed in cloud environments. The dependability of these systems often relies in middleware components that abstract the DBMS logic from the replication itself. The highly configurable nature of these systems makes their throughput very dependent on the correct tuning for a given workload. Given the high complexity involved, machine learning techniques are often considered to guide the tuning process and decompose the relations established between tuning variables.This paper presents a machine learning mechanism based on reinforcement learning that attaches to a hybrid replication middleware connected to a DBMS to dynamically live-tune the configuration of the middleware according to the workload being processed. Along with the vision for the system, we present a study conducted over a prototype of the self-tuned replication middleware, showcasing the achieved performance improvements and showing that we were able to achieve an improvement of 370.99% on some of the considered metrics.
Fichier principal
Vignette du fichier
495624_1_En_9_Chapter.pdf (1022.46 Ko) Télécharger le fichier
Origin Files produced by the author(s)

Dates and versions

hal-03223253 , version 1 (10-05-2021)

Licence

Identifiers

Cite

Luís Ferreira, Fábio Coelho, José Pereira. Self-tunable DBMS Replication with Reinforcement Learning. 20th IFIP International Conference on Distributed Applications and Interoperable Systems (DAIS), Jun 2020, Valletta, Malta. pp.131-147, ⟨10.1007/978-3-030-50323-9_9⟩. ⟨hal-03223253⟩
69 View
19 Download

Altmetric

Share

More