Perform the lift-and-shift migration into Azure cloud

Download the migration scripts

Open an SSH shell into your on-premises instance and navigate to the asset repository you downloaded:

    

        
        
cd $HOME/lift-n-shift-assets

    

Configure the migration script

Run the following script to create an SSH key pair. Press the Enter key when prompted for a passphrase:

    

        
        
scripts/create_ssh_key.sh

    

The output is similar to:

    

        
        ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAACAQDczfgUuS4pnNSXnNeK4lRR+CcmxCH+/Vl+aP9dhtGYX7DEVrWrKy9Hq7AKs3y1AUyW85MGBJEkgy8WQZui6T92UNZz+MGVoKm/++SyO/
....
tH33RAoBg2q3mJJgOCqCQ8k5kfAww== azureuser@YOUR_X64_ON_PREM_HOST

        
    

Save this key. You’ll use it in the next step.

Create a copy of the terraform.tfvars.example to terraform.tfvars:

    

        
        
cp terraform.tfvars.example terraform.tfvars

    

In an editor, open terraform.tfvars:

    

        
        
location              = "eastus2"
prefix                = "mysql-migrate"

source_mysql_database = "testdb"

admin_username        = "azureadmin"
ssh_public_key        = "RSA_KEY_GOES_HERE"

allowed_ssh_cidr      = "YOUR_PUBLIC_IP/32"
allowed_mysql_cidr    = "YOUR_PUBLIC_IP/32"

allow_mysql_inbound = true
vm_size         = "Standard_E4pds_v6"
os_disk_size_gb = 48

tags = {
  environment = "prod"
  application = "testdb-migration"
  owner       = "admin"
  managed_by  = "terraform"
}

    

Edit the following:

• location with the Azure region you want to use.
• prefix to match your naming preference.
• RSA_KEY_GOES_HERE with the SSH public key that you created. Make sure to include the ssh-rsa keyword as well within the RSA Key.
• YOUR_PUBLIC_IP with the public IP address of your on-premises x64 instance.

You can leave the remaining values unchanged for this Learning Path.

Log in to Azure

On the on-premises SSH shell, run:

    

        
        
az login

    

Follow the prompts to log in to your Azure account.

Start the migration

On the on-premises SSH shell, run:

    

        
        
scripts/migrate.sh testdb

    

This starts migration of the local testdb database into the Arm-based VM you configured in terraform.tfvars.

Assuming no errors in the tfvars config file, you’ll receive a prompt:

    

        
        Migrating local DB: testdb to Cloud...
Creating Cloud VM...
Cloud VM created.
Backing up the local DB testdb...
Enter password:

        
    

Enter the password you set for the local MySQL admin user in the previous section.

    

        
        Migrating local DB: testdb to Cloud...
Creating Cloud VM...
Cloud VM created.
Backing up the local DB testdb...
Enter password: 

        
    

You’ll now be prompted for a password again.

    

        
        Restoring local DB testdb onto the Cloud VM: Admin: admin IP: 20.98.229.225
You will need to open a second window and ssh into the VM and then look in /root for the password
Enter password:

        
    

To retrieve this password, follow these steps:

1. Open another shell into your on-premises x64 instance.
2. In that shell, check $HOME/.ssh and note the SSH private key filename ending in rsa.
3. In the Azure portal, locate your new Arm-based VM under Virtual Machines.
4. Record the VM public IP address.
5. Back in the second on-premises shell, run the following command with your key filename and VM IP:

    

        
        
ssh -i $HOME/.ssh/YOUR_RSA_FILENAME azureadmin@YOUR_ARM_BASED_VM_PUBLIC_IP_ADDRESS

    

You should now have a shell on the Arm-based Azure VM. In that shell, run:

    

        
        
sudo su - 
cat /root/mysql_root_password.txt

    

This is the required password. Provide it in your first SSH session on the on-premises host and let the script continue:

    

        
        Migrating local DB: testdb to Cloud...
Creating Cloud VM...
Cloud VM created.
Backing up the local DB testdb...
Enter password: 
Restoring local DB testdb onto the Cloud VM: Admin: admin IP: 20.98.229.225
You will need to open a second window and ssh into the VM and then look in /root for the password
Enter password: 

        
    

    

        
        
gunzip -c testdb.sql.gz | mysql -h YOUR_ARM_BASED_VM_PUBLIC_IP_ADDRESS -u admin -p 

    

At this point, your on-premises MySQL database (testdb) has been migrated to a new Arm-based VM in Azure.

What you’ve accomplished and what’s next

You’ve now run a script and followed a procedure to migrate a MySQL database from an on-premises x64 source to an Arm-based Azure VM.

In the next section, you’ll benchmark the testdb database with sysbench in the target environment.