Introduction
Azure Database for MySQL is an adapted version of MySQL to take full advantage of the Azure platform. It's closely integrated with Azure services and is fully managed by Microsoft. Microsoft handles the updates and patches to the software, and provide an SLA guarantee of 99.99% availability.
You work as a database developer for an online retailer. Their systems store information in a database that currently runs using MySQL on an Azure VM. As part of a hardware rationalization exercise, AdventureWorks want to move the database to an Azure-managed database. Your company wants to reduce the management overhead of keeping MySQL updated and performant.
In this module, you'll learn about the benefits of migrating MySQL workloads to Azure, and the features that Azure provides to help manage and optimize MySQL systems. You'll see how to create an instance of the Azure Database for MySQL service, and learn how to migrate on-premises MySQL databases to Azure. You'll also see how to reconfigure an application that uses the database to connect to Azure instead.
Learning objectives
By the end of this module, you'll be able to:
- Describe the features and limitations of Azure Database for MySQL.
- Migrate an on-premises MySQL database to Azure Database for MySQL.
- Reconfigure existing applications that use your on-premises MySQL databases to connect to Azure Database for MySQL.