One great advantage of the cloud is the ability to utilize Platform as a Service (PaaS) offerings to offload server and database administration, freeing you to focus on what drives success for your business. This includes your favorite open-source databases such as MySQL. In this hands-on lab scenario you are the DBA for Awesome Company. You have been tasked with delivering an open-source database backend for a new cloud-native app. This solution should integrate closely with Azure services, allow seamless transition of developer code that has been written against MySQL, and require as little hands-on maintenance as possible. This lab will help you become familiar with how to provision an Azure Database for MySQL server.
Successfully complete this lab by achieving the following learning objectives:
- Log in to the Azure Portal
Log in to the Azure Portal using the provided credentials.
- Create an Azure Database for MySQL
- Click the three-line menu icon in the top left corner of the page, and click Create a resource.
- Click on Databases.
- Click Azure Database for MySQL.
- Select the resource group created by the lab.
- Provide a server name.
- Set Location as (US) West US.
- Under Compute + storage, click Configure server.
- Click on Basic.
- Change Storage to 10 GB.
- Set Storage Auto-growth to No.
- Click OK.
- Provide an admin username and password.
- Click Review + create.
- Verify all is well, and click Create.
- Once the deployment is complete, click Go to resource.
Congratulations! You now have a fully operational MySQL Database server that is tightly integrated with other Azure services, has its infrastructure fully managed by Microsoft, and will allow your developer data and code to be transitioned seamlessly.