© 2019

Migrating to MariaDB

Toward an Open Source Database Solution


Table of contents

  1. Front Matter
    Pages i-xiv
  2. William Wood
    Pages 1-14
  3. William Wood
    Pages 15-32
  4. William Wood
    Pages 33-47
  5. William Wood
    Pages 49-57
  6. William Wood
    Pages 59-71
  7. William Wood
    Pages 73-87
  8. William Wood
    Pages 89-95
  9. William Wood
    Pages 97-134
  10. Back Matter
    Pages 135-156

About this book


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


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

Authors and affiliations

  1. 1.PacificUSA

About the authors

​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. 

Bibliographic information

Industry Sectors
Chemical Manufacturing
IT & Software
Consumer Packaged Goods
Materials & Steel
Finance, Business & Banking
Energy, Utilities & Environment