skip to main content
research-article

Albatross: lightweight elasticity in shared storage databases for the cloud using live data migration

Authors Info & Claims
Published:01 May 2011Publication History
Skip Abstract Section

Abstract

Database systems serving cloud platforms must serve large numbers of applications (or tenants). In addition to managing tenants with small data footprints, different schemas, and variable load patterns, such multitenant data platforms must minimize their operating costs by efficient resource sharing. When deployed over a pay-per-use infrastructure, elastic scaling and load balancing, enabled by low cost live migration of tenant databases, is critical to tolerate load variations while minimizing operating cost. However, existing databases---relational databases and Key-Value stores alike---lack low cost live migration techniques, thus resulting in heavy performance impact during elastic scaling. We present Albatross, a technique for live migration in a multitenant database serving OLTP style workloads where the persistent database image is stored in a network attached storage. Albatross migrates the database cache and the state of active transactions to ensure minimal impact on transaction execution while allowing transactions active during migration to continue execution. It also guarantees serializability while ensuring correctness during failures. Our evaluation using two OLTP benchmarks shows that Albatross can migrate a live tenant database with no aborted transactions, negligible impact on transaction latency and throughput both during and after migration, and an unavailability window as low as 300 ms.

References

  1. P. A. Bernstein et al. Adapting Microsoft SQL Server for Cloud Computing. In ICDE (to appear), 2011. Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. P. A. Bernstein and E. Newcomer. Principles of Transaction Processing. MK Publishers Inc., second edition, 2009.Google ScholarGoogle Scholar
  3. R. Bradford, E. Kotsovinos, A. Feldmann, and H. Schiöberg. Live wide-area migration of virtual machines including local persistent state. In VEE, pages 169--179, 2007. Google ScholarGoogle ScholarDigital LibraryDigital Library
  4. F. Chang et al. Bigtable: A Distributed Storage System for Structured Data. In OSDI, pages 205--218, 2006. Google ScholarGoogle ScholarDigital LibraryDigital Library
  5. C. Clark et al. Live migration of virtual machines. In NSDI, pages 273--286, 2005. Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. B. F. Cooper et al. PNUTS: Yahoo!'s hosted data serving platform. Proc. VLDB Endow., 1(2):1277--1288, 2008. Google ScholarGoogle ScholarDigital LibraryDigital Library
  7. B. F. Cooper et al. Benchmarking Cloud Serving Systems with YCSB. In ACM SoCC, pages 143--154, 2010. Google ScholarGoogle ScholarDigital LibraryDigital Library
  8. C. Curino et al. Relational Cloud: A Database Service for the Cloud. In CIDR, pages 235--240, 2011.Google ScholarGoogle Scholar
  9. S. Das, S. Agarwal, D. Agrawal, and A. El Abbadi. ElasTraS: An Elastic, Scalable, and Self Managing Transactional Database for the Cloud. Technical Report 2010-04, CS, UCSB, 2010.Google ScholarGoogle Scholar
  10. S. Das, D. Agrawal, and A. El Abbadi. ElasTraS: An Elastic Transactional Data Store in the Cloud. In USENIX HotCloud, 2009. Google ScholarGoogle ScholarDigital LibraryDigital Library
  11. S. Das, D. Agrawal, and A. El Abbadi. G-Store: A Scalable Data Store for Transactional Multi key Access in the Cloud. In ACM SoCC, pages 163--174, 2010. Google ScholarGoogle ScholarDigital LibraryDigital Library
  12. A. J. Elmore, S. Das, D. Agrawal, and A. El Abbadi. Zephyr: Live Migration in Shared Nothing Databases for Elastic Cloud Platforms. In SIGMOD (to appear), 2011. Google ScholarGoogle ScholarDigital LibraryDigital Library
  13. J. Gray. Notes on data base operating systems. In Operating Systems, An Advanced Course, volume 60, pages 393--481. Springer-Verlag, 1978. Google ScholarGoogle ScholarDigital LibraryDigital Library
  14. D. Jacobs and S. Aulbach. Ruminations on multi-tenant databases. In BTW, pages 514--521, 2007.Google ScholarGoogle Scholar
  15. T. Kraska, M. Hentschel, G. Alonso, and D. Kossmann. Consistency Rationing in the Cloud: Pay only when it matters. PVLDB, 2(1):253--264, 2009. Google ScholarGoogle ScholarDigital LibraryDigital Library
  16. H. T. Kung and J. T. Robinson. On optimistic methods for concurrency control. ACM TODS, 6(2):213--226, 1981. Google ScholarGoogle ScholarDigital LibraryDigital Library
  17. H. Liu, H. Jin, X. Liao, L. Hu, and C. Yu. Live migration of virtual machine based on full system trace and replay. In HPDC, pages 101--110, 2009. Google ScholarGoogle ScholarDigital LibraryDigital Library
  18. D. B. Lomet, A. Fekete, G. Weikum, and M. J. Zwilling. Unbundling transaction services in the cloud. In CIDR Perspectives, 2009.Google ScholarGoogle Scholar
  19. G. H. Sockut and B. R. Iyer. Online reorganization of databases. ACM Comput. Surv., 41(3):1--136, 2009. Google ScholarGoogle ScholarDigital LibraryDigital Library
  20. The Transaction Processing Performance Council. TPC-C benchmark (Version 5.10.1), 2009.Google ScholarGoogle Scholar
  21. C. D. Weissman and S. Bobrowski. The design of the force.com multitenant internet application development platform. In SIGMOD, pages 889--896, 2009. Google ScholarGoogle ScholarDigital LibraryDigital Library
  22. P. Xiong et al. Intelligent management of virtualized resources for database systems in cloud environment. In ICDE (to appear), 2011. Google ScholarGoogle ScholarDigital LibraryDigital Library
  23. F. Yang, J. Shanmugasundaram, and R. Yerneni. A scalable data platform for a large number of small applications. In CIDR, 2009.Google ScholarGoogle Scholar

Index Terms

  1. Albatross: lightweight elasticity in shared storage databases for the cloud using live data migration

              Recommendations

              Comments

              Login options

              Check if you have access through your login credentials or your institution to get full access on this article.

              Sign in

              Full Access

              • Published in

                cover image Proceedings of the VLDB Endowment
                Proceedings of the VLDB Endowment  Volume 4, Issue 8
                May 2011
                58 pages

                Publisher

                VLDB Endowment

                Publication History

                • Published: 1 May 2011
                Published in pvldb Volume 4, Issue 8

                Qualifiers

                • research-article

              PDF Format

              View or Download as a PDF file.

              PDF

              eReader

              View online with eReader.

              eReader