Migrating to MariaDB

1. Front Matter

   Pages i-xiv

   PDF

2. Drivers for Change

   • William Wood

   Pages 1-14

3. Requirements and Risk Assessment

   • William Wood

   Pages 15-32

4. Database and Application Code

   • William Wood

   Pages 33-47

5. Making the Decision

   • William Wood

   Pages 49-57

6. MariaDB Solution

   • William Wood

   Pages 59-71

7. Change as a Catalyst

   • William Wood

   Pages 73-87

8. Defining a Roadmap for Success

   • William Wood

   Pages 89-95

9. Making the Data Move

   • William Wood

   Pages 97-134

10. Back Matter

    Pages 135-156

    PDF

Mitigate the risks involved in migrating away from a proprietary database platform toward MariaDB’s open source database engine. This book will help you assess the risks and the work involved, and ensure a successful migration. 

Migrating to MariaDB describes the process and lessons learned during a migration from a proprietary database management engine to the MariaDB open source solution. The book discusses the drivers for making the decision and change, walking you through all aspects of the process from evaluating the licensing, navigating the pitfalls and hurdles of a migration, through to final implementation on the new platform. The book highlights the cost-effectiveness of MariaDB and how the licensing worries are simplified in comparison to running on a proprietary platform.

You’ll learn to do your own risk assessment, to identify database and application code that may need to be modified or re-implemented, and to identify MariaDB features to provide the security and failover protection needed by corporate customers. Let the author’s experience in migrating a financial firm to MariaDB inform your own efforts, helping you to develop a road map for both technical and political success within your own organization as you migrate away from proprietary lock-in toward MariaDB’s open source solution. 




What You'll Learn

• Evaluate and compare licensing costs between proprietary databases and MariaDB
  
• Perform a proper risk assessment to inform your planning and execution of the migration
  
• Build a migration road map from the book’s example that is specific to your situation
  
• Make needed application changes and migrate data to the MariaDB open source database engine

Who This Book Is For



Technical professionals (including database administrators, programmers, and technical management) who are interested in migrating away from a proprietary database platform toward MariaDB’s open source database engine and need to assess the risks and the work involved

• MySQL
• Oracle Database
• Encryption at Rest
• Encryption in Transit
• PCI DSS
• SSAE 16
• Open Source
• PL/SQL
• Linux
• Failover
• Galera
• MaxScale
• High Availability
• Clustering
• Licensing
• Risk Assessment

• Pacific, USA

  William Wood

​William Wood is an IT professional who has worked across many disciplines in his 18-year career. He started his work experience as a student worker for his school’s engineering department, which ran the school’s website, doing LAMP Stack work for database-driven dynamic website development. He has been working specifically in the database field for the past 10 years, first on a team that supported development infrastructure and release engineering where he became the Oracle SME, and then entering the working database administrator field in 2010 as a DBA, primarily working with and supporting Oracle and Oracle RAC in high volume, compute intensive, and high availability environments. 

Policies and ethics