The Community for Technology Leaders
Autonomic Computing, International Conference on (2007)
Jacksonville, Florida, USA
June 11, 2007 to June 15, 2007
ISBN: 0-7695-2779-5
pp: 26
Saeed Ghanbari , University of Toronto
Gokul Soundararajan , University of Toronto
Jin Chen , University of Toronto
Cristiana Amza , University of Toronto
This paper introduces a transparent self-configuring architecture for automatic scaling with temperature awareness in the database tier of a dynamic content web server. We use a unified approach to achieving the joint objectives of performance, efficient resource usage and avoiding temperature hot-spots in a replicated database cluster. <p>The key novelty in our approach is a lightweight on-line learning method for fast adaptations to bottleneck situations. Our approach is based on deriving a lightweight performance model of the replicated database cluster on the fly. The system trains its own model based on perceived correlations between various system and application metrics and the query latency for the application. The model adjusts itself dynamically to changes in the application workload mix. We use our performance model for query latency prediction and determining the number of database replicas necessary to meet the incoming load. We adapt by adding the necessary replicas, pro-actively in anticipation of a bottleneck situation and we remove them automatically in underload. Finally, the system adjusts its query scheduling algorithm dynamically in order to avoid temperature hotspots within the replicated database cluster.</p> <p>We investigate our transparent database provisioning mechanism in the database tier using the TPC-W industry-standard e-commerce benchmark. We demonstrate that our technique provides quality of service in terms of both performance and avoiding hot-spot machines under different load scenarios. We further show that our method is robust to dynamic changes in the workload mix of the application.</p>

J. Chen, G. Soundararajan, S. Ghanbari and C. Amza, "Adaptive Learning of Metric Correlations for Temperature-Aware Database Provisioning," 2007 International Conference on Autonomic Computing(ICAC), Jacksonville, FL, 2007, pp. 26.
93 ms
(Ver 3.3 (11022016))