User Disengagement-Oriented Target Enforcement for Multi-Tenant Database Systems
User Disengagement-Oriented Target Enforcement for Multi-Tenant Database Systems
复制标题
DOI：
10.1145/3620678.3624668
复制
发表时间：
2023-10
期刊：
影响因子：
--
通讯作者：
Ning Li;Hong Jiang;Hao Che;Zhijun Wang;Minh Q. Nguyen;Todd Rosenkrantz
中科院分区：
文献类型：
--
作者：
Ning Li;Hong Jiang;Hao Che;Zhijun Wang;Minh Q. Nguyen;Todd Rosenkrantz
数据库系统意外的长查询延迟可能会对所有上游服务造成多米诺骨牌效应，并严重降低终端用户的体验，导致越来越多的用户脱离服务，从而导致高用户脱离率（UDR）。较高的UDR通常意味着服务提供商的收入减少。本文提出了一种面向UDR的SLO保证系统UTSLO，它通过面向UDR的容量规划和动态UDR目标执行，使数据库系统能够以经济有效的方式支持多租户UDR目标。前者旨在估计UDR目标的可行性，后者动态跟踪和调节保证准确UDR目标所需的每连接查询延迟分布。在UTSLO中，可以充分利用数据库服务容量来有效地容纳租户，同时最小化UDR目标保证所需的资源。
Unexpected long query latency of a database system can cause domino effects on all the upstream services and severely degrade end users' experience with unpredicted long waits, resulting in an increasing number of users disengaged with the services and thus leading to a high user disengagement ratio (UDR). A high UDR usually translates to reduced revenue for service providers. This paper proposes UTSLO, a UDR-oriented SLO guaranteed system, which enables a database system to support multi-tenant UDR targets in a cost-effective fashion through UDR-oriented capacity planning and dynamic UDR target enforcement. The former aims to estimate the feasibility of UDR targets while the latter dynamically tracks and regulates per-connection query latency distribution needed for accurate UDR target guarantee. In UTSLO, the database service capacity can be fully exploited to efficiently accommodate tenants while minimizing resources required for UDR target guarantee.