Skip to Main content Skip to Navigation
New interface
Conference papers

A methodology for tenant migration in legacy shared-table multi-tenant applications

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. Service 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 extension 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.
Complete list of metadata

https://hal.inria.fr/hal-03381116
Contributor : François Charoy Connect in order to contact the contributor
Submitted on : Friday, October 15, 2021 - 9:58:05 PM
Last modification on : Saturday, February 5, 2022 - 3:08:38 AM
Long-term archiving on: : Sunday, January 16, 2022 - 9:28:20 PM

File

camera_ready.pdf
Files produced by the author(s)

Identifiers

  • HAL Id : hal-03381116, version 1

Citation

Guillaume Rosinosky, Samir Youcef, François Charoy, Etienne Rivière. A methodology for tenant migration in legacy shared-table multi-tenant applications. DAIS 2021 - 21th IFIP International Conference on Distributed Applications and Interoperable Systems, Jun 2021, Valetta, Malta. pp.3-20. ⟨hal-03381116⟩

Share

Metrics

Record views

70

Files downloads

415