Title: Resource auto-scaling for SQL-like queries in the cloud based on parallel reinforcement learning

Authors: Mohamed Mehdi Kandi; Shaoyi Yin; Abdelkader Hameurlain

Addresses: IRIT Laboratory, Paul Sabatier University, Toulouse, France ' IRIT Laboratory, Paul Sabatier University, Toulouse, France ' IRIT Laboratory, Paul Sabatier University, Toulouse, France

Abstract: Cloud computing is a technology that provides on-demand services in which the number of assigned resources can be automatically adjusted. A key challenge is how to choose the right number of resources so that the overall monetary cost is minimised. This problem, known as auto-scaling, was addressed in some existing works but most of them are dedicated to web applications. In these applications, it is assumed that the queries are atomic and each of them uses a single resource for a short period of time. However, this assumption cannot be considered for database applications. A query, in this case, contains many dependent and long tasks so several resources are required. We propose in this work an auto-scaling method based on reinforcement learning. The method is coupled with placement-scheduling. In the experimental section, we show the advantage of coupling the auto-scaling to the placement-scheduling by comparing our work to an existing auto-scaling method.

Keywords: cloud computing; auto-scaling; resource allocation; parallel reinforcement learning.

DOI: 10.1504/IJGUC.2019.102748

International Journal of Grid and Utility Computing, 2019 Vol.10 No.6, pp.654 - 671

Received: 14 Jan 2019
Accepted: 20 Feb 2019

Published online: 09 Aug 2019 *

Full-text access for editors Access for subscribers Purchase this article Comment on this article