Flexible Resource Allocation for Relational Database-as-a-Service

被引:1
|
作者
Arora, Pankaj [1 ]
Chaudhuri, Surajit [1 ]
Das, Sudipto [3 ]
Dong, Junfeng [1 ]
George, Cyril [1 ]
Kalhan, Ajay [1 ]
Konig, Arnd Christian [1 ]
Lang, Willis [1 ]
Li, Changsong [1 ]
Li, Feng [4 ]
Liu, Jiaqi [1 ]
Maas, Lukas M. [1 ]
Mata, Akshay [1 ]
Menache, Ishai [1 ]
Moeller, Justin [1 ]
Narasayya, Vivek [1 ]
Olma, Matthaios [1 ]
Oslake, Morgan
Rezai, Elnaz [2 ]
Shan, Yi [1 ]
Syamala, Manoj [1 ]
Xu, Shize [5 ]
Zois, Vasileios [1 ]
机构
[1] Microsoft Corp, Redmond, WA 98052 USA
[2] Amazon, Chennai, Tamil Nadu, India
[3] Amazon Web Serv, Seattle, WA USA
[4] Meta Platforms Inc, Cambridge, MA USA
[5] Stripe Inc, Dublin, Ireland
来源
PROCEEDINGS OF THE VLDB ENDOWMENT | 2023年 / 16卷 / 13期
关键词
OPTIMIZATION;
D O I
10.14778/3625054.3625058
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
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.
引用
下载
收藏
页码:4202 / 4215
页数:14
相关论文
共 50 条
  • [1] Automated Demand-driven Resource Scaling in Relational Database-as-a-Service
    Das, Sudipto
    Li, Feng
    Narasayya, Vivek R.
    Konig, Arnd Christian
    SIGMOD'16: PROCEEDINGS OF THE 2016 INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2016, : 1923 - 1934
  • [2] Solver-In-The-Loop Cluster Resource Management for Database-as-a-Service
    Konig, Arnd Christian
    Shan, Yi
    Newatia, Karan
    Marshall, Luke
    Narasayya, Vivek
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2023, 16 (13): : 4254 - 4267
  • [3] Database-as-a-Service for IoT
    Gogawale, Anand
    Khatib, Fasih
    Sontakke, Pratik
    Saigaonkar, Swati
    PROCEEDINGS OF THE 10TH INDIACOM - 2016 3RD INTERNATIONAL CONFERENCE ON COMPUTING FOR SUSTAINABLE GLOBAL DEVELOPMENT, 2016, : 1436 - 1438
  • [4] Sharing Buffer Pool Memory in Multi-Tenant Relational Database-as-a-Service
    Narasayya, Vivek
    Menache, Ishai
    Singh, Mohit
    Li, Feng
    Syamala, Manoj
    Chaudhuri, Surajit
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2015, 8 (07): : 726 - 737
  • [5] Penalized Graph Partitioning based Allocation Strategy for Database-as-a-Service Systems
    Kiefer, Tim
    Habich, Dirk
    Lehner, Wolfgang
    2016 3RD IEEE/ACM INTERNATIONAL CONFERENCE ON BIG DATA COMPUTING, APPLICATIONS AND TECHNOLOGIES (BDCAT), 2016, : 200 - 209
  • [6] CPU Sharing Techniques for Performance Isolation in Multi-tenant Relational Database-as-a-Service
    Das, Sudipto
    Narasayya, Vivek R.
    Li, Feng
    Syamala, Manoj
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2013, 7 (01): : 37 - 48
  • [7] Aggregation queries in the database-as-a-service model
    Mykletun, Einar
    Tsudik, Gene
    DATA AND APPLICATIONS SECURITY XX, PROCEEDINGS, 2006, 4127 : 89 - 103
  • [8] Database-as-a-Service for Big Data: An Overview
    Abourezq, Manar
    Idrissi, Abdellah
    INTERNATIONAL JOURNAL OF ADVANCED COMPUTER SCIENCE AND APPLICATIONS, 2016, 7 (01) : 157 - 177
  • [9] Efficient Database Encryption Scheme for Database-as-a-Service Environment
    Joo, Hankyu
    INTERNATIONAL JOURNAL OF SECURITY AND ITS APPLICATIONS, 2015, 9 (05): : 195 - 203
  • [10] Incorporating a secure coprocessor in the Database-as-a-Service model
    Mykletun, E
    Tsudik, G
    INNOVATIVE ARCHITECTURE FOR FUTURE GENERATION HIGH-PERFORMANCE PROCESSORS AND SYSTEMS, 2005, : 38 - 44