{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,6,19]],"date-time":"2025-06-19T04:38:31Z","timestamp":1750307911900,"version":"3.41.0"},"reference-count":46,"publisher":"Association for Computing Machinery (ACM)","issue":"2","license":[{"start":{"date-parts":[[2006,12,1]],"date-time":"2006-12-01T00:00:00Z","timestamp":1164931200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["ACM Trans. Auton. Adapt. Syst."],"published-print":{"date-parts":[[2006,12]]},"abstract":"<jats:p>This paper introduces a self-configuring architecture for on-demand resource allocation to applications in a shared database cluster. We use a unified approach to load and fault management based on data replication and reactive replica provisioning. While data replication provides scaling and high availability, reactive provisioning dynamically allocates additional replicas to applications in response to peak loads or failure conditions, thus providing per application performance. We design an efficient method for data migration when joining a new replica to a running application that allows for the quick addition of replicas with minimal disruption of transaction processing. Furthermore, by augmenting the adaptation feedback loop with awareness of the delay introduced by the data migration process in our replicated system, we avoid oscillations in resource allocation.We investigate our transparent database provisioning mechanisms in the context of multitier dynamic content Web servers. We dynamically expand\/contract the respective allocations within the database tier for two different applications, the TPC-W e-commerce benchmark and the RUBIS online auction benchmark. We demonstrate that our techniques provide quality of service under different load and failure scenarios.<\/jats:p>","DOI":"10.1145\/1186778.1186780","type":"journal-article","created":{"date-parts":[[2007,2,21]],"date-time":"2007-02-21T16:42:23Z","timestamp":1172076143000},"page":"151-188","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":12,"title":["Reactive provisioning of backend databases in shared dynamic content server clusters"],"prefix":"10.1145","volume":"1","author":[{"given":"Gokul","family":"Soundararajan","sequence":"first","affiliation":[{"name":"University of Toronto, Canada"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Cristiana","family":"Amza","sequence":"additional","affiliation":[{"name":"University of Toronto, Canada"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2006,12]]},"reference":[{"volume-title":"5th IEEE Workshop on Workload Characterization.]]","author":"Amza C.","key":"e_1_2_1_1_1"},{"volume-title":"Proceedings of the 5th USENIX Symposium on Internet Technologies and Systems. 71--84","author":"Amza C.","key":"e_1_2_1_2_1"},{"volume-title":"Proceedings of the 21st International Conference Data Engineering (ICDE'05)","year":"2005","author":"Amza C.","key":"e_1_2_1_3_1"},{"volume":"2672","volume-title":"Lecture Notes in Computer Science","author":"Amza C.","key":"e_1_2_1_4_1"},{"unstructured":"Apache. The Apache Software Foundation. http:\/\/www.apache.org\/.]]  Apache. The Apache Software Foundation. http:\/\/www.apache.org\/.]]","key":"e_1_2_1_5_1"},{"volume-title":"IEEE International Conference on Autonomic Computing (ICAC'05)","year":"2005","author":"Bennani M. N.","key":"e_1_2_1_6_1"},{"unstructured":"Bernstein P. Hadzilacos V. and Goodman N. 1987. Concurrency control and recovery in Database Systems. Addison-Wesley Reading MA.]]   Bernstein P. Hadzilacos V. and Goodman N. 1987. Concurrency control and recovery in Database Systems. Addison-Wesley Reading MA.]]","key":"e_1_2_1_7_1"},{"doi-asserted-by":"publisher","key":"e_1_2_1_8_1","DOI":"10.1109\/69.50903"},{"volume-title":"Proceedings of the USENIX Annual Technical Conference.]]","author":"Cecchet E.","key":"e_1_2_1_9_1"},{"volume-title":"Proceedings of the 6th Symposium on Operating System Design and Implementation (OSDI'04)","author":"Cohen I.","key":"e_1_2_1_10_1"},{"volume-title":"20th International Conference on Data Engineering","author":"Daudjee K.","key":"e_1_2_1_11_1"},{"volume-title":"Proceedings of the 13th IFIP\/IEEE International Workshop on Distributed Systems: Operations and Management. Springer-Verlag, 42--53","author":"Diao Y.","key":"e_1_2_1_12_1"},{"volume-title":"Proceedings of the 2nd USENIX Symposium on Operating Systems Design and Implementation","author":"Goyal P.","key":"e_1_2_1_13_1"},{"volume-title":"Proceedings of the ACM SIGMOD International Conference on Management of Data. Montreal","author":"Gray J.","key":"e_1_2_1_14_1"},{"key":"e_1_2_1_15_1","doi-asserted-by":"crossref","first-page":"254","DOI":"10.1007\/978-3-540-49121-7_22","article-title":"Rumor: Mobile data access through optimistic peer-to-peer replication","volume":"1552","author":"Guy R.","year":"1999","journal-title":"Lecture Notes in Computer Science"},{"volume-title":"Proceedings of the 3rd USENIX Symposium on Operating System Design and Implementation. 239--249","year":"1999","author":"Hutchinson N.","key":"e_1_2_1_16_1"},{"unstructured":"IBM Corporation. 2003a. Autonomic computing manifesto. http:\/\/www.research.ibm.com\/autonomic\/manifesto.]]  IBM Corporation. 2003a. Autonomic computing manifesto. http:\/\/www.research.ibm.com\/autonomic\/manifesto.]]","key":"e_1_2_1_17_1"},{"unstructured":"IBM Corporation. 2003b. Automated provisioning of resources for data center environments. http:\/\/www-306.ibm.com\/software\/tivoli\/solutions\/provisioning\/.]]  IBM Corporation. 2003b. Automated provisioning of resources for data center environments. http:\/\/www-306.ibm.com\/software\/tivoli\/solutions\/provisioning\/.]]","key":"e_1_2_1_18_1"},{"volume-title":"Proceedings of the 15th International Conference on World Wide Web (WWW'06)","author":"Karve A.","key":"e_1_2_1_19_1"},{"doi-asserted-by":"publisher","key":"e_1_2_1_20_1","DOI":"10.1145\/363951.363955"},{"volume-title":"Proceedings of the 26th International Conference on Very Large Databases.]]","author":"Kemme B.","key":"e_1_2_1_21_1"},{"volume-title":"Proceedings of the International Conference on Dependable Systems and Networks (DSN'01)","year":"2001","author":"Kemme B.","key":"e_1_2_1_22_1"},{"unstructured":"Li B. and Nahrstedt K. 1999. A control-based middleware framework for quality of service adaptations. IEEE J. Select. Areas Comm..]]  Li B. and Nahrstedt K. 1999. A control-based middleware framework for quality of service adaptations. IEEE J. Select. Areas Comm..]]","key":"e_1_2_1_23_1"},{"volume-title":"Proceedings of the ACM SIGMOD Conference (SiGMOD'05)","author":"Lin Y.","key":"e_1_2_1_24_1"},{"volume-title":"Proceedings of the 3rd ACM Conference on Electronic Commerce. ACM Press","author":"Menasce","key":"e_1_2_1_25_1"},{"volume-title":"Proceedings of the 5th ACM\/IFIP\/USENIX International Middleware Conference.]]","author":"Milan-Franco J. M.","key":"e_1_2_1_26_1"},{"unstructured":"MySQL. MySQL. http:\/\/www.mysql.com.]]  MySQL. MySQL. http:\/\/www.mysql.com.]]","key":"e_1_2_1_27_1"},{"unstructured":"ORACLE. Oracle Real Application Clusters 10g. http:\/\/www.oracle.com\/technology\/products\/database\/clustering\/.]]  ORACLE. Oracle Real Application Clusters 10g. http:\/\/www.oracle.com\/technology\/products\/database\/clustering\/.]]","key":"e_1_2_1_28_1"},{"volume-title":"Proceedings of the 14th IEEE International Workshop on Quality of Service (IWQoS'06)","author":"Parekh J.","key":"e_1_2_1_29_1"},{"volume-title":"Proceedings of the 5th ACM\/IFIP\/Usenix International Middleware Conference.]]","author":"Plattner C.","key":"e_1_2_1_30_1"},{"volume-title":"10th International Workshop on Quality of Service.]]","author":"Ranjan S.","key":"e_1_2_1_31_1"},{"volume-title":"Proceedings of the 3rd USENIX Symposium on Internet Technologies and Systems. 207--216","author":"Shen K.","key":"e_1_2_1_32_1"},{"volume-title":"Proceedings of the 14th International World Wide Web Conference (WWW'05)","year":"2005","author":"Sivasubramanian S.","key":"e_1_2_1_33_1"},{"unstructured":"Slashdoteffect. Slashdot: Handling the loads on 9\/11. http:\/\/slashdot.org.]]  Slashdoteffect. Slashdot: Handling the loads on 9\/11. http:\/\/slashdot.org.]]","key":"e_1_2_1_34_1"},{"volume-title":"EuroSys'06: Proceedings of the EuroSys Conference (EUROSYS'06)","author":"Soundararajan G.","key":"e_1_2_1_35_1"},{"volume-title":"Proceedings of the 3rd USENIX Symposium on Operating Systems Design and Implementation.]]","author":"Steere D. C.","key":"e_1_2_1_36_1"},{"volume-title":"Proceedings of the 15th Symposium on Operating Systems Principles","author":"Terry D. B.","key":"e_1_2_1_37_1"},{"volume-title":"Proceedings of the 3rd International Conference on Autonomic Computing (ICAC'06)","year":"2006","author":"Tesauro G.","key":"e_1_2_1_38_1"},{"volume-title":"Proceedings of the 2nd IEEE International Conference on Autonomic Computing (ICAC'05)","year":"2005","author":"Tesauro G.","key":"e_1_2_1_39_1"},{"unstructured":"Totok A. and Karamcheti V. 2006. Issues in bottleneck detection in multitier enterprise applications. In IWQoS 2006: Proceedings of the 14th IEEE International Workshop on Quality of Service (IWQS'06).]]  Totok A. and Karamcheti V. 2006. Issues in bottleneck detection in multitier enterprise applications. In IWQoS 2006: Proceedings of the 14th IEEE International Workshop on Quality of Service (IWQS'06).]]","key":"e_1_2_1_40_1"},{"unstructured":"TPC. Transaction Processing Council. http:\/\/www.tpc.org\/.]]  TPC. Transaction Processing Council. http:\/\/www.tpc.org\/.]]","key":"e_1_2_1_41_1"},{"volume-title":"Proceedings of the 1st International Conference on Autonomic Computing (ICACS'04)","author":"Walsh W. E.","key":"e_1_2_1_42_1"},{"doi-asserted-by":"crossref","unstructured":"Weikum G. and Vossen G. 2002. Transactional Information Systems. Theory Algorithms and the Practice of Concurrency Control and Recovery 2nd Ed. Addison-Wesley Reading MA.]]   Weikum G. and Vossen G. 2002. Transactional Information Systems. Theory Algorithms and the Practice of Concurrency Control and Recovery 2nd Ed. Addison-Wesley Reading MA.]]","key":"e_1_2_1_43_1","DOI":"10.1016\/B978-155860508-4\/50005-3"},{"volume-title":"Proceedings of the 5th USENIX Symposium on Internet Technologies and Systems.]]","author":"Welsh M.","key":"e_1_2_1_44_1"},{"volume-title":"Proceedings of the 3rd International Conference on Autonomic Computing (ICAC'06)","year":"2006","author":"Woodside M.","key":"e_1_2_1_45_1"},{"volume-title":"Proceedings of the 21st International Conference on Data Engineering (ICDE'05)","year":"2005","author":"Wu S.","key":"e_1_2_1_46_1"}],"container-title":["ACM Transactions on Autonomous and Adaptive Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/1186778.1186780","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/1186778.1186780","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T14:47:52Z","timestamp":1750258072000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/1186778.1186780"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2006,12]]},"references-count":46,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2006,12]]}},"alternative-id":["10.1145\/1186778.1186780"],"URL":"https:\/\/doi.org\/10.1145\/1186778.1186780","relation":{},"ISSN":["1556-4665","1556-4703"],"issn-type":[{"type":"print","value":"1556-4665"},{"type":"electronic","value":"1556-4703"}],"subject":[],"published":{"date-parts":[[2006,12]]},"assertion":[{"value":"2006-12-01","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}