ProRea: live database migration for multi-tenant RDBMS with snapshot isolation

The consolidation of multiple tenants onto a single RDBMS instance turned out to be benefical with respect to resource utilization and scalability. The consolidation implies that multiple tenants share the physical resources available for the RDBMS instance. If the available resources tend to get insufficient to meet the SLAs agreed with the tenants, migration of a tenant's database from one RDBMS instance to another is compelling. Highly available services demand for live migration techniques that come with minimal service interruption and low performance impact. This paper meets the demand for live migration techniques by contributing ProRea. ProRea is a live database migration approach designed for multi-tenant RDBMS that run OLTP workloads under snapshot isolation. ProRea extends concepts of existing live database migration approaches to accomplish minimal service interruption, high efficiency and very low migration overhead. Measurements of a prototypical ProRea implementation underpin its good performance.

[1]  Markus Kirchberg,et al.  D-ARIES: A Distributed Version of the ARIES Recovery Algorithm , 2005, ADBIS Research Communications.

[2]  Dean Jacobs,et al.  Ruminations on Multi-Tenant Databases , 2007, BTW.

[3]  Divyakant Agrawal,et al.  Albatross: Lightweight Elasticity in Shared Storage Databases for the Cloud using Live Data Migration , 2011, Proc. VLDB Endow..

[4]  Craig D. Weissman,et al.  The design of the force.com multitenant internet application development platform , 2009, SIGMOD Conference.

[5]  Dan R. K. Ports,et al.  Serializable Snapshot Isolation in PostgreSQL , 2012, Proc. VLDB Endow..

[6]  Prashant J. Shenoy,et al.  "Cut me some slack": latency-aware live migration for databases , 2012, EDBT '12.

[7]  Jim Gray,et al.  A critique of ANSI SQL isolation levels , 1995, SIGMOD '95.

[8]  Divyakant Agrawal,et al.  Database Scalability, Elasticity, and Autonomy in the Cloud - (Extended Abstract) , 2011, DASFAA.

[9]  Andreas Reuter,et al.  Transaction Processing: Concepts and Techniques , 1992 .

[10]  P. Mell,et al.  The NIST Definition of Cloud Computing , 2011 .

[11]  Fan Yang,et al.  A Scalable Data Platform for a Large Number of Small Applications , 2009, CIDR.

[12]  Bernhard Mitschang,et al.  Native support of multi-tenancy in RDBMS for software as a service , 2011, EDBT/ICDT '11.

[13]  Rui Liu,et al.  Elastic Scale-Out for Partition-Based Database Systems , 2012, 2012 IEEE 28th International Conference on Data Engineering Workshops.

[14]  Hamid Pirahesh,et al.  ARIES: a transaction recovery method supporting fine-granularity locking and partial rollbacks using write-ahead logging , 1998 .

[15]  Ragnar Normann,et al.  A theoretical study of 'Snapshot Isolation' , 2010, ICDT '10.

[16]  Bernhard Mitschang,et al.  Partitioned or Non-Partitioned Table Storage? Concepts and Performance for Multi-tenancy in RDBMS , 2011, SEDE.

[17]  Michael J. Cahill.  Serializable isolation for snapshot databases , 2009, TODS.

[18]  Samuel Madden,et al.  An integrated approach to recovery and high availability in an updatable, distributed data warehouse , 2006, VLDB.

[19]  Balakrishna R. Iyer,et al.  Online reorganization of databases , 2009, CSUR.

[20]  David P. Reed,et al.  Naming and synchronization in a decentralized computer system , 1978 .

[21]  Ashraf Aboulnaga,et al.  Automatic virtual machine configuration for database workloads , 2008, SIGMOD Conference.

[22]  Divyakant Agrawal,et al.  Towards an Elastic and Autonomic Multitenant Database , 2011 .

[23]  Robin Dhamankar,et al.  Transaction Log Based Application Error Recovery and Point In-Time Query , 2012, Proc. VLDB Endow..

[24]  Torsten Grust,et al.  Multi-tenant databases for software as a service: schema-mapping techniques , 2008, SIGMOD Conference.

[25]  Divyakant Agrawal,et al.  Zephyr: live migration in shared nothing databases for elastic cloud platforms , 2011, SIGMOD '11.

[26]  Carlo Curino,et al.  Relational Cloud: a Database Service for the cloud , 2011, CIDR.