%0 Conference Proceedings
%T A methodology for tenant migration in legacy shared-table multi-tenant applications
%+ Université Catholique de Louvain = Catholic University of Louvain (UCL)
%+ Web Scale Trustworthy Collaborative Service Systems (COAST)
%A Rosinosky, Guillaume
%A Youcef, Samir
%A Charoy, François
%A Rivière, Etienne
%< avec comité de lecture
%B DAIS 2021 - 21th IFIP International Conference on Distributed Applications and Interoperable Systems
%C Valetta, Malta
%Y Miguel Matos
%Y Fabíola Greve
%I Springer International Publishing
%3 Distributed Applications and Interoperable Systems
%V LNCS-12718
%P 3-20
%8 2021-06-14
%D 2021
%K scalability
%K multi-tenancy
%K databases
%K cloud computing
%Z Computer Science [cs]/Distributed, Parallel, and Cluster Computing [cs.DC]
%Z Computer Science [cs]/Software Engineering [cs.SE]Conference papers
%X 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.
%G English
%Z TC 6
%Z WG 6.1
%2 https://inria.hal.science/hal-03381116/document
%2 https://inria.hal.science/hal-03381116/file/camera_ready.pdf
%L hal-03381116
%U https://inria.hal.science/hal-03381116
%~ CNRS
%~ INRIA
%~ INRIA_TEST
%~ INRIA-LORRAINE
%~ LORIA2
%~ INRIA-NANCY-GRAND-EST
%~ TESTALAIN1
%~ IFIP-LNCS
%~ IFIP
%~ UNIV-LORRAINE
%~ INRIA2
%~ IFIP-TC
%~ IFIP-WG
%~ IFIP-TC6
%~ IFIP-WG6-1
%~ IFIP-DAIS
%~ LORIA
%~ LORIA-NSS
%~ IFIP-LNCS-12718