Moving a Basic MySQL Database to Azure

1 hour
  • 3 Learning Objectives

About this Hands-on Lab

In this lab, students will use the Azure portal to deploy an Azure Database for MySQL instance and then use Azure Cloud Shell to deploy a small MySQL database on a virtual machine (to simulate an “on-premises” server), migrate the data from the VM to the Azure DB, and then verify the migration.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Deploy the “On-Premises” Database

Using the Azure Cloud Shell, SSH in to the virtual machine, and then re-create the database for migration.

Deploy the Azure DB for MySQL Instance

Using the Azure portal, deploy a basic Azure cloud database instance.

Migrate Data to the Cloud Database

Using the virtual machine as an "on-premises" server, migrate the data from the virtual machine to the Azure cloud database.

Additional Resources

In this scenario, you are Cloudy Solutions, Inc. systems engineer who has been tasked with testing the migration of an on-premises database to a database in Azure. This is meant to test the process of taking several MySQL databases from the on-premises datacenter and moving them to Azure to reduce maintenance overhead.

The systems engineer will be provided a virtual machine. From the Azure portal, you will need to deploy an Azure Database for MySQL instance. From there, you will remote in to the virtual machine and install a basic MySQL database in the virtual machine for migration. Using this ephemeral setup is preferable before testing on production data.

In order to complete this lab, you will leverage the materials inside of the GitHub repository provided here.

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Get Started
Who’s going to be learning?