Migrate MySQL on-premises to Azure Database for MySQL: Summary
APPLIES TO: Azure Database for MySQL - Single Server Azure Database for MySQL - Flexible Server
Prerequisites
Overview
This document has covered several topics related to migrating an application from on-premises MySQL to Azure Database for MySQL. We covered how to begin and assess the project all the way to application cut over.
The migration team needs to review the topics carefully as the choices made can have project timeline effects. The total cost of ownership is enticing given the many enterprise ready features provided.
The migration project approach is important. The team needs to assess the application and database complexity to determine the amount of conversion time. Conversion tools help make the transition easier, but there have always been an element of manual review and updates required. Scripting out pre-migration tasks and post migration testing is important.
Application architecture and design can provide strong indicators as to the level of effort required. For example, applications utilizing ORM frameworks can be great candidates, especially if the business logic is contained in the application instead of database objects.
In the end, several tools exist in the marketplace ranging from free to commercial. This document covered the steps required if the team plans a database migration using one of the more popular open-source tool options. Whichever path that is chosen, Microsoft and the MySQL community have the tools and expertise to make the database migration successful.
Feedback and support
For any questions or suggestions you might have about working with Azure Database for MySQL flexible server, consider the following points of contact:
- To contact Azure Support, file a ticket from the Azure portal.
- To fix an issue with your account, file a support request in the Azure portal.
- To provide feedback or to request new features, create an entry via UserVoice.
Find a partner to help migrate
This guide can be overwhelming, but don't fret! There are many experts in the community with a proven migration track record. Search for a Microsoft Partner or Microsoft MVP to help with finding the most appropriate migration strategy. You aren't alone!
You can also browse the technical forums and social groups for more detailed real-world information:
Next step
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for