mcw-building-the-migration-business-case-with-sap's Introduction

Building the business migration case with Linux and OSS DB to Azure

NOTE: This workshop is archived and no longer being maintained. Content is read-only.

Terra Firm Laboratories is a global bioengineering company that’s the leading researcher and innovator in genetic and biological science technology. The company was founded in 1975 with its corporate headquarters in Palo Alto, CA. Their mission-critical workloads are currently hosted in an on-premises datacenter and are beginning a journey to modernize and migrate into the cloud using Microsoft Azure.

The CTO, Dennis Nedry, has kicked off an initiative for the organization to begin adopting the Microsoft Azure cloud and modernize its infrastructure. He has already had his team begin assessing their current environment and what it will take to migrate to the cloud. They are looking to optimize their technology investments by reducing technical debt and streamlining operations using Azure Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) cloud services.

December 2022

Target audience

Technical Architects
Infrastructure Architects
Data Architects

Abstracts

Workshop

In this workshop, you will gain experience designing and implementing a strategy for migrating Red Hat Enterprise Linux (RHEL) and MySQL database workloads to Azure.

At the end of the workshop, you will be better able to design and implement an Azure migration strategy for Red Hat Enterprise Linux and MySQL database workloads using Azure Virtual Machines, and Azure Database for MySQL.

Whiteboard design session

In this whiteboard design session, you will learn to design a strategy for migrating existing on-premises Red Hat Enterprise Linux (RHEL) and MySQL database workloads to Azure. Throughout the whiteboard design session, you will look at the virtual machine (VM) pricing and migrating MySQL database workloads to Azure.

At the end of the workshop, you will be better able to design a migration strategy for Red Hat Enterprise Linux (RHEL) workloads to Azure VMs and MySQL database workloads to Azure Database for MySQL.

Continue to the Whiteboard design session documents folder.

Hands-on Lab

In this hands-on lab, you will perform steps to migrate Red Hat Enterprise Linux (RHEL) and MySQL database workloads to Azure. You will go through provisioning a Red Hat Enterprise Linux VM, and migrate MySQL database to Azure Database for MySQL.

At the end of this hands-on lab, you will be better able to set up a Red Hat Enterprise Linux (RHEL) VM for application migration to Azure and migrate an on-premises MySQL database to Azure Database for MySQL.

Continue to the Hands-on lab documents folder.

Azure services and related products

RedHat Enterprise Linux
Azure VMs
Azure Hybrid Benefit (AHB)
Azure Database for MySQL
Azure Networking
Azure Database Migration Service
Azure Bastion

Azure solutions

DC Migration

Related references

Help & Support

We welcome feedback and comments from Microsoft SMEs & learning partners who deliver MCWs.

Having trouble?

First, verify you have followed all written lab instructions (including the Before the Hands-on lab document).
Next, submit an issue with a detailed description of the problem.
Do not submit pull requests. Our content authors will make all changes and submit pull requests for approval.

If you are planning to present a workshop, review and test the materials early! We recommend at least two weeks prior.

Please allow 5 - 10 business days for review and resolution of issues.

mcw-building-the-migration-business-case-with-sap's People

Contributors

Stargazers

Watchers

mcw-building-the-migration-business-case-with-sap's Issues

Error MySQL to Azure Database for MySQL Offline Data Migration Wizard

I completed this step: https://github.com/microsoft/MCW-Building-the-business-migration-case-with-Linux-and-OSS-DB-to-Azure/blob/main/Hands-on%20lab/Before%20the%20HOL%20-%20Building%20the%20business%20migration%20case%20with%20Linux%20and%20OSS%20DB%20to%20Azure.md
and I logged in successfully to page:

But when I come to step MySQL to Azure Database for MySQL Offline Data Migration Wizard .
It still return error:

SQL Connection Issue (Same old issue)

Unable to collect server properties for server 4.194.218.94 due to a connection error.
Connection failed.
Host 'X.X.X.X' is not allowed to connect to this MySQL server
when trying on the "MySQL to Azure Database for MySQL Offline Data Migration Wizard" page.

Re-Deployed 3 times and got no errors from deployments. I had no issues connecting phpipam application but still getting this error.

MySQL to Azure Database for MySQL Offline Data Migration Wizard

Hi team,

I got the error:
Unable to collect server properties for server 4.194.218.94 due to a connection error.
Connection failed.
Host '4.193.75.227' is not allowed to connect to this MySQL server
when trying on the "MySQL to Azure Database for MySQL Offline Data Migration Wizard" page. (attached image below)

4.194.218.94 for the VM

Could you help me to figure out?

Thanks.

Facing connection issue while creating new migration project in Exercise-1, Task-3

Hi,
I am facing an issue while creating new migration project in Database Migration Service in Exercise-1 Task-3 Step-4.

Please find the Error details below with screenshot FYR:

{ "resourceId":"/subscriptions/resourceGroups/terrafirm-rg/providers/Microsoft.DataMigration/services/terrafirm-database-migration", "errorType":"Failed to connect, please check error details", "errorDetail":"Unable to collect server properties for server `20.14.185.2` due to a connection error.Connection failed.Host '20.12.78.67' is not allowed to connect to this MySQL server" }

FYI, we have the required MYSQL port 3306 is enabled. Please find the below screenshot:

Recommend Projects

microsoft / mcw-building-the-migration-business-case-with-sap Goto Github PK