1. Home
  2. Training Library
  3. Microsoft Azure
  4. Courses
  5. Introduction to Azure Storage Solutions

MySQL Demo

The course is part of these learning paths

AZ-203 Exam Preparation: Developing Solutions for Microsoft Azure
course-steps 18 certification 1 lab-steps 7
Getting Started with Azure
course-steps 2 certification 1
Developing, Implementing and Managing Azure Infrastructure
course-steps 10 certification 7 lab-steps 2
more_horiz See 2 more
play-arrow
Start course
Overview
DifficultyIntermediate
Duration1h 13m
Students2158

Description

This course provides an introductory tour of Azure Storage Solutions such as its SQL offerings (SQL DB and third party offerings of MySQL), managed NoSQL databases (DocumentDB and MongoDB), managed Redis Cache service, Azure Backup (backup-as-a-service), Site Recovery (for handling disaster recovery) and StorSimple (a hybrid cloud storage solution).

Target Audience / Experience

  • This course is for developers or IT professionals looking for an introduction to Azure’s Storage Solutions.
  • Some familiarity with the Azure platform is helpful, but not required.

Learning Objectives

  • Understand what SQL DB is and how to get started using it
  • Learn the options offered by Azure for managed MySQL
  • Understand what DocumentDB and MongoDB are and how to get started using them
  • Learn what Redis Cache is and some cases of when you would use it
  • Get an understanding of what Azure Search provides
  • Learn how Azure Backup can solve common backup needs
  • Understand what role Site Recovery can play in disaster recovery
  • Learn how StorSimple can extend your on-premise storage capacity


Outline

  • Course Introduction
    • Overview
  • Azure SQL Database
    • What is Azure SQL Database?
    • Understanding the service tiers
    • Create a SQL Database
    • What is a Data Throughput Unit (DTU)?
    • Scaling Azure SQL
  • MySQL
    • Options for Using MySQL in Azure
  • Azure CosmosDB DocumentDB API
    • What is DocumentDB?
  • Azure CosmosDB MongoDB API
    • Options for Using MongoDB in Azure
    • How does DocumentDB compare to MongoDB?
  • Azure Redis Cache
    • What is Azure Redis Cache?
    • Common scenarios for using Redis Cache
    • Understanding the service tiers
    • How does Redis work?
    • Create and manage a Redis Cache
    • Scaling Azure Redis Cache
  • Azure Search
    • What is Azure Search?
    • Indexes and Search Features
    • How do you use the Search Service?
    • Create a Search Service and Index
  • Azure Backup
    • What is Azure Backup?
    • Backup Scenarios
    • Import/Export Service
    • What is the Import/Export Service?
    • Why would you use Import/Export?
  • Site Recovery
    • What is Site Recovery?
    • Workload recovery scenarios
  • StorSimple
    • What is StorSimple?
    • How does StorSimple work?
  • Course Summary
    • Conclusion and Wrap-Up

Transcript

Ok, so just like the demo for SQL Database, I want to show you how to create a ClearDB MySQL database in the Azure portal and give you a look at the features available.
So click on the new button and type MySql in the search box. Ok, you’ll notice there several MySQL results and here’s that new on from Microsoft. But we want the ClearDB one, now I click the create button.
So this opens the blade for us to help us configure the database settings. I’ll enter a name for the database and then leave the subscription and I’ll leave it at shared. Enter in a new resource group and leave the location. Now let’s look at the pricing tier. So by default it is at 3.50, let’s choose the free.
Ok so here’s the legal terms for the ClearDB, hit purchase, pin to dashboard and hit create. I’ll pause the video while this creates, it will take a few minutes.
Ok, we’re back. The database is created.
Ok same stuff at the top, resource group, location, host name, size. We have the database size charts, connections used charts and then some user RBAC security stuff. Then off to the side here, not a lot of options. So let’s look at the properties. Properties this where you would go to get the connection string for your application. And then let’s look at Scale. Scale is where you can change your plan a little bit. You can see not all the options are open. And that’s it. A real quick overview of MySQL.
 
Here are a few references for those of you who want to learn more about ClearDB's MySQL.
Now let’s briefly look at Microsoft’s new MySQL offering

On May 10 2017, at Microsoft’s Build conference, they announced the public preview of their new MySQL product.
It is a fully managed database-as-a-service.
Runs the Community version of MySQL.
Though, for the preview, not all the service tiers are available yet.
If you look at the pricing - you’ll see they use a new concept called Compute Unit instead of the DTU used with SQL Database. This is a move towards keeping the compute and storage separate for more flexibility.
Microsoft has built this managed version of MySQL on the database services platform that SQL Database uses. This platform gives MySQL the ability to scale up and down on demand, high availability, automatic backups with point in time restore and an IP Firewall.
No timelines have been announced for when it will be generally available.

Here are some links to find out more about this preview product.
Let's change gears a little and take a look at Azure CosmosDB DocumentDB API or what was known as DocumentDB before the Build conference.

About the Author

Students2159
Courses1


Jason Haley is an independent consultant who focuses on Azure and Angular. He has over 20+ years’ experience architecting, designing, developing and delivering software solutions using mostly Microsoft technologies. Jason recently achieved his MCSE: Cloud Platform and Infrastructure certification in May 2017 (by passing all of the 70-532, 70-533 and 70-534 exams). He is also a Microsoft Azure MVP and leads the North Boston Azure User Group. He frequently speaks at community events on topics relating to Azure.