A Methodology for Tenant Migration in Legacy Shared-Table Multi-tenant Applications
(2021) DAIS 2021 — Location: Malta
Files
camera_ready.pdf
Open Access - Adobe PDF
- 444.41 KB
Details
- Authors
- Abstract
- Multi-tenancy enables cost-effective SaaS through resource consolidation. Multiple customers, or tenants, are served by a single application instance, and isolation is enforced at the application level. Ser- vice load for different tenants can vary over time, requiring applications to scale in and out. A large class of SaaS providers operates legacy applications structured around a relational (SQL) database. These applications achieve tenant isolation through dedicated fields in their relational schema and are not designed to support scaling operations. We present a novel solution for scaling in or out such applications through the migration of a tenant’s data to new application and database instances. Our solution requires no change to the application and incurs no service downtime for non-migrated tenants. It leverages external tables and foreign data wrappers, as supported by major relational databases. We evaluate the approach using two multi-tenant applications: Iomad, an ex- tension of the Moodle Learning Management System, and Camunda, a business process management platform. Our results show the usability of the method, minimally impacting performance for other tenants during migration and leading to increased service capacity after migration.
- Affiliations
Citations
Rosinosky, G., Youcef, S., Charoy, F., & Riviere, E. (2021). A Methodology for Tenant Migration in Legacy Shared-Table Multi-tenant Applications. Distributed Applications and Interoperable Systems : Lecture Notes in Computer Science, p. 3-20. https://doi.org/10.1007/978-3-030-78198-9_1