Data Migration Management
Data migration; Database migration; Live database migration
Database migration can refer to one of several concepts. The first being the migration of data either between database management systems (i.e., moving data from DBMS X to DBMS Y ) or between versions of the same database management system (i.e., moving from DBMS X version 8.1 to version 8.3). Second, database migration can refer to a change in schema, typically the result of an application change. Third, and the focus of this article, refers to the migration of data between two database servers, typically for the purposes of load balancing or server maintenance. Migrating a database with no observable unavailability (downtime) and minimal performance degradation is referred to as live database migration.
The earliest migration techniques were developed for process migration in prototype operating systems, such as V-System and Sprite . These techniques focus on migrating a running...
- 1.Barker SK, Chi Y, Moon HJ, Hacigümüs H, Prashant J. Shenoy: cut me some slack: latency-aware live migration for databases. In: Proceedings of the 15th International Conference on Extending Database Technology; 2012. p. 432–43.Google Scholar
- 2.Bradford R, Kotsovinos E, Feldmann A, Schiöberg H. Live wide-area migration of virtual machines including local persistent state. In: Proceedings of the 3rd International Conference on Virtual Execution Environments; 2007. p. 169–79.Google Scholar
- 3.Clark C, Fraser K, Hand S, Hansen JG, Jul E, Limpach C, Pratt I, Warfield A. Live migration of virtual machines. In: Proceedings of the 2nd USENIX Symposium on Networked Systems Design & Implementation; 2005. p. 273–86.Google Scholar
- 6.Elmore AJ, Das S, Agrawal D, El Abbadi A. Zephyr: live migration in shared nothing databases for elastic cloud platforms. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2011. p. 301–12.Google Scholar
- 7.Schiller O, Cipriani N, Mitschang B. ProRea: live database migration for multi-tenant RDBMS with snapshot isolation. In: Proceedings of the 16th International Conference on Extending Database Technology; 2013. p. 53–64.Google Scholar