Home // DEPEND 2014, The Seventh International Conference on Dependability // View article
Authors:
Hendrik Müller
Andreas Prusch
Steffan Agel
Keywords: Adaptability; Anticipation; Database Migration; Parallelization
Abstract:
HiPAS is a database migration method, aimed at reducing downtime during offline migrations by automatically adapting to available system resources. Investigating the applicability of adaptive capabilities for database migrations, two stages of system complexity, adaption and anticipation, were mapped onto the requirement of utilizing a system up to an optimal degree in order to achieve the shortest possible transfer duration. The developed method is automated by implementing the HiPAS software, which adapts to its environment by continuously monitoring relevant system information, and increasing or decreasing the current parallelization degree whenever necessity is assumed. To enable a flexible adaption, the total amount of migration data is partitioned into equal sized transfer jobs being distributed across available instances and networks. Since HiPAS is invoked on the database layer, and controlled by a temporarily created autonomous database user, migration metadata is stored inside tables thus being highly integrated with the actual migration data. HiPAS was designed and evaluated iteratively following the IS research framework and reveals significant downtime reduction potential compared to non-adaptive migration approaches like Oracle “Data Pump”. Our results serve as a contribution to all researchers and practitioners in investigating fields of application for adaptability mechanisms.
Pages: 41 to 50
Copyright: Copyright (c) IARIA, 2014
Publication date: November 16, 2014
Published in: conference
ISSN: 2308-4324
ISBN: 978-1-61208-378-0
Location: Lisbon, Portugal
Dates: from November 16, 2014 to November 20, 2014