A methodology for tenant migration in legacy shared-table multi-tenant applications - Inria - Institut national de recherche en sciences et technologies du numérique Accéder directement au contenu
Communication Dans Un Congrès Année : 2021

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

Résumé

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.
Fichier principal
Vignette du fichier
camera_ready.pdf (480.24 Ko) Télécharger le fichier
Origine : Fichiers produits par l'(les) auteur(s)

Dates et versions

hal-03381116 , version 1 (15-10-2021)

Identifiants

  • HAL Id : hal-03381116 , version 1

Citer

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⟩
104 Consultations
654 Téléchargements

Partager

Gmail Facebook X LinkedIn More