Dynamic partitioning of the cache hierarchy in shared data centers

Due to the imperative need to reduce the management costs of large data centers, operators multiplex several concurrent database applications on a server farm connected to shared network attached storage. Determining and enforcing perapplication resource quotas in the resulting cache hierarchy, on the fly, poses a complex resource allocation problem spanning the database server and the storage server tiers. This problem is further complicated by the need to provide strict Quality of Service (QoS) guarantees to hosted applications. In this paper, we design and implement a novel coordinated partitioning technique of the database buffer pool and storage cache between applications for any given cache replacement policy and per-application access pattern. We use statistical regression to dynamically determine the mapping between cache quota settings and the resulting perapplication QoS. A resource controller embedded within the database engine actuates the partitioning of the two-level cac...

• Type: Journal
• Year: 2008
• Where: PVLDB
• Authors: Gokul Soundararajan, Jin Chen, Mohamed A. Sharaf, Cristiana Amza
• Keywords: Cache, Database, PVLDB 2008, Server Farms