Migrating to MariaDB : Toward an Open Source Database Solution

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. 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 Table of Contents 5 About the Author 8 About the Technical Reviewer 9 Introduction 10 Chapter 1: Drivers for Change 12 Driver: A New Product 12 Driver: Oracle Costs and Business Practices 16 Chapter 2: Requirements and Risk Assessment 26 Requirements of a New DBMS 27 Audits and Compliance 29 Risks 40 Chapter 3: Database and Application Code 44 Migrating the Database 45 Database Side Programming 48 Application Code 54 Becoming Database Agnostic 56 Chapter 4: Making the Decision 59 Extolling the Benefits 60 Presenting Cost Savings 61 Develop a Strategy 64 Putting it Together 66 Chapter 5: MariaDB Solution 68 Preinstallation Considerations 69 MariaDB Stand-Alone with Replication 71 Replication Limits and Testing 78 Galera Clustering 78 Chapter 6: Change as a Catalyst 81 Evaluating Solutions for Rework 83 Fixing the Legacy 85 Standards Adoption 86 Process Improvement 89 Automation 92 Chapter 7: Defining a Roadmap for Success 96 Database Evaluation 97 Evaluating First Steps 99 Path of Least Resistance 101 Success 102 Chapter 8: Making the Data Move 103 First Steps 104 Letting DBAs be DBAs 105 Tool Building 107 FOPEN 108 FCLOSE 110 FFLUSH 110 PUT 110 PUT_LINE 111 PUT_RAW 112 Dynamic SQL 113 Handling LOB Data 121 Sample Solution Code 125 Appendix A: Open Source Continuum 141 Open Source in the Data Center 142 Entrepreneurial Limits of Big Name Proprietary Systems 144 Where Is Open Source Not Viable 148 Benefits of Open Source 149 Index 151 Front Matter ....Pages i-xiv Drivers for Change (William Wood)....Pages 1-14 Requirements and Risk Assessment (William Wood)....Pages 15-32 Database and Application Code (William Wood)....Pages 33-47 Making the Decision (William Wood)....Pages 49-57 MariaDB Solution (William Wood)....Pages 59-71 Change as a Catalyst (William Wood)....Pages 73-87 Defining a Roadmap for Success (William Wood)....Pages 89-95 Making the Data Move (William Wood)....Pages 97-134 Back Matter ....Pages 135-156