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

MySQL

The course is part of these learning paths

AZ-203 Exam Preparation: Developing Solutions for Microsoft Azure
course-steps 20 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 1 more
play-arrow
Start course
Overview
DifficultyIntermediate
Duration1h 13m
Students2313
Ratings
4.8/5
star star star star star-half

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

Welcome back. Let's now talk about another relational database MySQL. 

After the last section about SQL Database, you may be wondering: what if my application already uses MySQL?
Well, this is a valid question. If you already have an application that is using MySQL, you may want to know what options you have besides migrating to SQL Database, so let's look at some options. 

If you are already invested in MySQL and want to move to Azure, it makes sense to keep using it.
In Azure your options for using MySQL are: Running it yourself in a virtual machine, Using a managed version from a third-party vendor (named ClearDB) Or announced May 10 at Build 2017 a managed version from Microsoft.
If you decide you don't want to deal with the infrastructure overhead of running MySQL on a VM and instead want to use ClearDB to manage it for you, you have a couple of options: a shared environment or a dedicated environment.
As of this recording the managed version offered by Microsoft just started its public preview, so I’m not going to cover it in full - but I do have a couple of slides at the end to give you more information about it.
So let's take a look at what ClearDB offers.

This is a relational database-as-a-service product - just like SQL Database is. That means you don't have to worry about installations, configuring clusters and all that other infrastructure stuff. ClearDB takes care of all that for you.
Unlike SQL Database, you get to choose whether or not your database is running on shared or dedicated resources and you can even get up to 100% availability SLA - which is amazing!
Geo-replication is available with ClearDB, however it isn’t available in every Azure region – so you’ll need to check if it is in the regions you need. ClearDB MySQL also has automatic failover for that high availability we all need.
There are multiple service tiers to choose from.
Support is available and if you go with the dedicated tiers you even get 24/7 support!
Ok, scaling. When it comes to moving between the service tiers, you can scale up - however, scaling down it’s just not supported by ClearDB.
Now, let's take a look at the different service tiers.
 
Ok, to be clear, using the phrase "service tier" here is my phrase - not ClearDB's.
They call them editions, but I'm keeping with the terminology we used with SQL Database since its basically the same idea. Instead of Basic, Standard and Premium – they use Community and Production.
One of the cool things you may notice - is the lowest level of the Community edition is free! Which can be really useful for a proof of concept application.
Within the two tiers, you'll notice a pattern for the size, memory and cost that show the different sizes are mostly relative to each other.
So that is ClearDB’s service tiers – pretty straight forward – but do remember you can only scale up sizes not down.
You should now have a pretty good idea of what ClearDB MySQL offers, let's take a look at it in a demo.
 

About the Author

Students2314
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.