SLA-driven resource re-allocation for SQL-like queries in the cloud
- PDF / 2,050,227 Bytes
- 28 Pages / 439.37 x 666.142 pts Page_size
- 40 Downloads / 171 Views
SLA-driven resource re-allocation for SQL-like queries in the cloud Mohamed Mehdi Kandi1
· Shaoyi Yin1 · Abdelkader Hameurlain1
Received: 22 July 2019 / Revised: 21 July 2020 / Accepted: 25 July 2020 © Springer-Verlag London Ltd., part of Springer Nature 2020
Abstract Cloud computing has become a widely used environment for database querying. In this context, the goal of a query optimizer is to satisfy the needs of tenants and maximize the provider’s benefit. Resource allocation is an important step toward achieving this goal. Allocation methods are based on analytical formulas and statistics collected from a catalog to estimate the cost of various possible allocations and then choose the best one. However, the allocation initially chosen is not necessarily the optimal one because of the approximate nature of the analytical formulas and the fact that the catalog may not be up to date. To solve this problem, existing work was proposed to collect statistics during the execution of the query and then trigger a re-allocation if suboptimality is detected. However, these proposals consider that queries have the same level of priority. Unlike the existing work, we propose in this paper a method of statistics collector placement and resource re-allocation by taking into account that the cloud is a multi-tenant environment and queries have different services-level agreements. In the experimental section, we show that our method provides a better benefit for the provider compared to state-of-the-art methods. Keywords Cloud computing · Databases · Services-level agreement · Statistics collection · Resource re-allocation
1 Introduction Deploying databases in the cloud is a practice widely adopted by companies today [3–6]. Companies are promoting the use of the cloud because it avoids a large human and technical investment for local infrastructure management. The cloud is based on Services-Level Agreements (SLAs). It is a set of rules that define objectives that must be met by the cloud provider
B
Mohamed Mehdi Kandi [email protected] Shaoyi Yin [email protected] Abdelkader Hameurlain [email protected]
1
IRIT Laboratory, Paul Sabatier University, 118 Route de Narbonne, 31062 Toulouse, France
123
M. M. Kandi et al.
and the actions to be taken in the case of objective violation. SLAs can be service-oriented or tenant-oriented. Service-oriented SLAs are assigned to all tenants using a given service, while tenant-oriented SLAs are established individually with each tenant following a negotiation. There are also SLAs for availability objectives and SLAs for performance objectives. Service-oriented SLAs for availability targets are currently used for many services, mainly for infrastructure level. For a database querying service, the requirements of the tenants are different depending on the nature of the client application that query the databases. Indeed, some applications have strict constraints in terms of query execution time. We are therefore interested in this work on tenant-oriented SLAs and perfo
Data Loading...
