Migracija podatkov iz podatkovne zbirke MySQL na Percona Server in MariaDB : diplomsko delo

MIHELIČ, MITJA (author), Zrnec, Aljaž (mentor)

Diplomsko delo obravnava tematiko o izvedbi migracije podatkov iz podatkovne zbirke MySQL na podatkovno zbirko MariaDB in Percona Server. Pri tem se osredotoča predvsem na posebnosti na katere je potrebno biti pozoren pri migraciji podatkov, na enakosti in razlike med omenjenimi bazami, kaj je treba popraviti v že narejenih aplikacijah, ki uporabljajo MySQL, s katerimi pastmi se bodo razvijalci srečevali pri migraciji in kakšna naj bi bila nemotena ter pravilno izvedena migracija podatkov. Prikazan je tudi primer testne podatkovne baze in aplikacije, s pomočjo katere se izvede test delovanja aplikacije pred migracijo in po migraciji na novi podatkovni bazi MariaDB.

• Language: Slovenian
• Keywords: podatkovne baze, MySQL, Percona Server, MariaDB, migracija podatkov, računalništvo, visokošolski strokovni študij, računalništvo in informatika, diplomske naloge
• Work type: Bachelor thesis/paper
• Typology: 2.11 - Undergraduate Thesis
• Organization: FRI - Faculty of Computer and Information Science
• Publisher: M. Mihelič
• Year: 2014
• Number of pages: 39 str.
• PID: 20.500.12556/RUL-29640
• COBISS.SI-ID: 1536030147
• Publication date in RUL: 01.10.2014

Licences

• License: CC BY-SA 2.5 SI, Creative Commons Attribution-ShareAlike 2.5 Slovenia
• Link: https://creativecommons.org/licenses/by-sa/2.5/si/deed.en
• Description: You are free to reproduce and redistribute the material in any medium or format. You are free to remix, transform, and build upon the material for any purpose, even commercially. You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use. If you remix, transform, or build upon the material, you must distribute your contributions under the same license as the original. You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.

Secondary language

• Language: English
• Title: Data migration from MySQL database to Percona Server and MariaDB

Abstract

This BSc Thesis aims to present the process of migration from MySQL to both MariaDB and Percona Server, highlighting best practice tips to navigate the migration process the easiest way on one hand, and the constraints and problems most likely encountered during this process on the other. It also presents most basic differences between these implementations. It also demonstrates the migration process from MySQL to MariaDB through a pre and post migration testing scenario of an operational database environment with test application.

• Keywords: databases, MySQL, Percona Server, MariaDB, data migration, computer science, computer and information science, diploma