Flexible Resource Allocation for Relational Database-as-a-Service
- Pankaj Arora ,
- Surajit Chaudhuri ,
- Sudipto Das ,
- Junfeng Dong ,
- Cyril George ,
- Ajay Kalhan ,
- Arnd Christian König ,
- Willis Lang ,
- Changsong Li ,
- Feng Li ,
- Jiaqi Liu ,
- Lukas M. Maas ,
- Akshay Mata ,
- Ishai Menache ,
- Justin Moeller ,
- Vivek Narasayya ,
- Matthaios Olma ,
- Morgan Oslake ,
- Elnaz Rezai ,
- Yi Shan ,
- Manoj Syamala ,
- Shize Xu ,
- Vasileios Zois
49th International Conference on Very Large Data Bases |
Published by VLDB | Organized by VLDB Endowment
Oversubscription is an essential cost management strategy for cloud database providers, and its importance is magnified by the emerging paradigm of serverless databases. In contrast to general purpose techniques used for oversubscription in hypervisors, operating systems and cluster managers, we develop techniques that leverage our understanding of how DBMSs use resources and how resource allocations impact database performance. Our techniques are designed to flexibly redistribute resources across database tenants at the node and cluster levels with low overhead. We have implemented our techniques in a commercial cloud database service: Azure SQL Database. Experiments using microbenchmarks, industry-standard benchmarks and real-world resource usage traces show that using our approach, it is possible to tightly control the impact on database performance even with a relatively high degree of oversubscription.