Resource auto-scaling for SQL-like queries in the cloud based on parallel reinforcement learning. (9th August 2019)

• Record Type: Journal Article
• Authors: Kandi, Mohamed Mehdi; Yin, Shaoyi; Hameurlain, Abdelkader
• Is Part Of: International journal of grid and utility computing. Volume 10:Number 6(2019)
• Page Start: 654
• Page End: 671
• Publication Date: 2019-08-09
• Subjects: cloud computing -- auto-scaling -- resource allocation -- parallel reinforcement learning; Electronic data processing -- Distributed processing -- Periodicals; Electronic commerce -- Management -- Computer programs -- Periodicals; 004.605
• Languages: English
• ISSNs: 1741-847X

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.