Title
ProRea: live database migration for multi-tenant RDBMS with snapshot isolation
Abstract
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.
Year
DOI
Venue
2013
10.1145/2452376.2452384
EDBT
Keywords
Field
DocType
prototypical prorea implementation,low migration overhead,single rdbms instance,available resource,rdbms instance,multi-tenant rdbms,minimal service interruption,snapshot isolation,live database migration approach,live migration technique,multiple tenant,cloud computing,rdbms,management,multi tenancy,relational databases
Snapshot isolation,Computer science,Live migration,Online transaction processing,Multitenancy,Relational database management system,Database,Operating system,Cloud computing,Data migration,Scalability
Conference
Citations 
PageRank 
References 
10
0.53
19
Authors
3
Name
Order
Citations
PageRank
Oliver Schiller1384.32
Nazario Cipriani2497.99
Bernhard Mitschang3928284.89