E-book Series

Developer’s Guide to Getting

Started with Microsoft Azure
Database for MySQL

Iv
Azure Database
Azure Database for MySQL makes it easy to build
new applications or migrate existing ones to the
cloud using the programming languages and

for MySQL frameworks of your choice. It’s a fully managed

service, so you can provision it in minutes and
independently scale compute and storage in
makes it easy to seconds, benefiting from built-in high availability
and a service-level agreement of 99.99 percent.

build new
You can pay as you go under a simple yet flexible
pricing model, so you won’t need to pay extra for
automatic patching and backups, monitoring, or

applications essential security features. You also won’t have to

devote precious resources to handling such things
yourself. In addition, like all open-source database
services from Microsoft, Azure Database for
MySQL is built on a world-class infrastructure with
unmatched global reach, plugging you into the
worldwide network of Microsoft Azure datacenters.

Audience
This paper is targeted at developers who are
thinking of building new cloud apps on MySQL or
moving existing MySQL apps to the cloud. It
provides an overview of Azure Database for
MySQL and the value that it provides as a fully
managed, open-source database service. It also
covers the key concepts you’ll need to understand
to best put Azure Database for MySQL to use,
together with a list of quickstarts, tutorials, and
other resources to help you get started using it.
Introduction: MySQL databases in the Updates and upgrades 9
cloud 2 Drivers and tools compatibility 9
Azure Database for MySQL 3 5-minute quickstarts 9
Step 1: Create a server 9
Key concepts 5
Step 2: Connect and query 10
Databases and servers 5
Step-by-step tutorials 2
Server pricing tiers and resources 5
How-to guides 2
High availability 6
Videos 2
Business continuity 6
Replication 3
Data access and security 7
Developing with Azure Kubernetes
Firewall rules 7
Service 3
Virtual network rules 7
Configuring SSL 7 Advanced Threat Protection 3
Advanced Threat Protection 8
Additional resources 3
Monitoring and tuning 8 Limitations 3
Samples 4
Replication 8
References 4
Getting started with Azure Database Azure Database Migration Guide 4
for MySQL 9 Other useful links 4

Supported versions 9 Conclusion 5

to help you get started using it.

©2019 Microsoft Corporation. All rights reserved.

This document is provided “as is.” Information and views expressed in this document, including URL and other internet website
references, may change without notice. You bear the risk of using it.

This document does not provide you with any legal rights to any intellectual property in any Microsoft product. You may copy and use
this document for your internal, reference purposes
2

The pervasiveness of MySQL is fueling

Introduction: MySQL explosive growth in MySQL database services,
which let you reap the benefits of using
databases in the cloud MySQL while avoiding the many pitfalls of on-
premises solutions or hosted, self-managed
In the early days of computing, developers virtual machines. For example, with cloud
shared the code they wrote to learn from one services, you won’t need to deal with
another and evolve their software. This spirit deployment efforts, continual patching,
of collaboration remains alive today with painstaking performance optimization,
open-source software, which gives users rights complex high-availability mechanisms,
to access, modify, and distribute source intricate security and compliance concerns,
code—relying on community contributions and continual worries about scalability—all of
from across the globe to achieve more than which can lead to unpredictable delays and
any one organization could on its own. costs.

To fully appreciate the value of open-source To make MySQL work in the enterprise,
software, it’s worth examining a few of the however, you’ll need a lot more than just a
benefits it provides. These include open hosted MySQL database service. Rarely does
standards that are accessible to everyone, any database exist in isolation, which is why
along with full visibility into the code base. you’ll also want to make sure your chosen
Everyone benefits from community efforts to platform offers everything else you’ll need to
improve and support the software, a lack of effectively put your chosen database service
licensing fees, and lower development costs. to use. The specific services you’ll need will
Openly available source code speeds the depend on your app, such as whether you’ll
delivery of new offerings, and freedom from be ingesting massive data volumes,
vendor lock-in facilitates increased choice implementing real-time streaming analytics,
across platforms. Best practices for building an AI-powered chatbot, or simply
maximizing performance and availability are deploying an instance of Drupal or WordPress.
shared freely, as are those for deployment and And don’t forget about development tools,
operations, and reliability is maximized software frameworks, and integration; you
through community vetting. In addition, the won’t want to complicate things unnecessarily
flexibility that open-source software provides in those areas either. After all, even if a cloud
for developers can help attract more and platform provides all the services you need, it
better talent. won’t do you much good if you need to learn
an entirely new skill set before you can
It’s for these reasons that open-source
effectively put those services to use.
databases such as MySQL have grown to be
so popular. MySQL Community Edition is In the rest of this paper, we’ll provide an
supported by a large and vibrant community overview of Microsoft Azure Database for
of open-source developers. As the database MySQL, a fully managed MySQL database
component of the popular LAMP (Linux, service, and the value that it brings to you as a
Apache, MySQL, PHP) web application stack, developer. We’ll also cover the key concepts
MySQL remains one of the most popular you’ll need to understand to best put Azure
database management systems among Database for MySQL to use, together with a
developers today. list of quickstarts, tutorials, and other
resources to help you get started using it.
3

That said, we’re seeing some patterns in the

Azure Database for types of solutions that customers are building:

MySQL  Scalable e-commerce solutions that

engage customers through
customized offerings and process
transactions quickly and securely
Azure Database for MySQL combines the
 Engaging and scalable web and
community edition of the MySQL database
mobile apps that are capable of
engine with all the benefits of the cloud,
reaching across platforms to connect
freeing you from the complexity of
with users on iOS, Android, Windows,
infrastructure and database management so
or Mac computers
you can focus on building exceptional apps.
As a fully managed service, Azure Database  Rich digital-marketing experiences,
for MySQL lets you easily build new including digital campaigns that can
applications or migrate existing ones to the automatically scale based on customer
cloud using the programming languages and demand
frameworks of your choice.
 Financial management apps that
With Azure Database for MySQL, you can securely store critical data,
provision new databases in minutes and aggregating that information to
independently scale compute and storage, deliver high-value analytics and
knowing that you’ll get built-in high insights with uncompromised
availability and a service-level agreement of performance
99.99 percent. In fact, Azure Database for
 Gaming experiences that can scale
MySQL provides everything you need under a
elastically, ensuring the ability to
simple, flexible pricing model, so you won’t
accommodate unexpected bursts of
need to pay extra for things like automatic
traffic and deliver consistent, low-
database patching and backups, monitoring
latency, multiplayer experiences
capabilities, or essential security features.
Azure Database for MySQL is built on the
same platform as Azure SQL Database and
These characteristics make Azure Database for Azure SQL Data Warehouse, as are Azure
MySQL ideal for hosting enterprise-scale Database for PostgreSQL and Azure Database
production workloads. You can get started for MariaDB, our other open-source database
immediately and build a broad range of services. This means that you’ll benefit from
solutions, knowing that you won’t be limited the same on-demand scalability no matter
by infrastructure issues, scalability, availability which service you choose. It also means that,
concerns, geographic presence, or excessive where it makes sense, we’ll be able to infuse
upfront costs. The possibilities are endless, the same intelligent features that we built for
which is one reason why open-source Azure SQL Database into Azure Database for
database services are becoming so popular. MySQL that much faster. Advanced Threat
Protection, one such feature that we’ve
already started rolling out to Azure Database
for MySQL, is a good example.
4

As an Azure data service, Azure Database for MySQL is backed by Azure compute and Azure Storage,
and is built to work with the extensive range of other Azure services—including Azure Power BI
Embedded, Azure App Service, and the Azure AI platform. And like all Azure services, Azure Database
for MySQL is built on a world-class infrastructure with unmatched global reach; Azure has more
global regions than any other cloud provider, enabling you to bring your apps closer to your users
around the world, preserve data residency, and satisfy compliance demands. Finally, when you
choose Azure Database for MySQL, you’ll get comprehensive compliance and Azure IP Advantage, a
program for Azure customers that provides protection against intellectual property (IP) risks
5

You can create an Azure Database for MySQL

Key concepts server in one of three pricing tiers, which are
differentiated by the amount of compute
Following are some of the key concepts you’ll (vCores) that can be provisioned, the amount
need to understand to get the most out of of memory per vCore, and the technology
Azure Database for MySQL. If you’d rather just used for data storage. In general:
jump in and learn via a hands-on approach,
feel free to skip this chapter for now and jump  Basic is good for workloads that
to Getting Started with Azure Database for require only light compute and I/O—
MySQL. such as test servers and small-scale,
infrequently used applications.
Databases and servers  General purpose is good for
Azure Database for MySQL exposes access workloads that require balanced
and features at the server level. An Azure compute and memory, with scalable
Database for MySQL server, which is created I/O—including web apps, mobile apps,
within an Azure subscription, is the parent and many other enterprise apps. This
resource for one or more individual databases. is our most popular option, and it
It collocates the computing resources for works well for most scenarios.
those databases in a specified Azure region,  Memory optimized is good for
provides a namespace for the databases, and
workloads that require in-memory
serves as a connection endpoint for server and
performance for faster transaction
database access.
processing and greater concurrency—
An Azure Database for MySQL server also including real-time data processing
defines the scope for management policies and high-performance transactional or
that apply to those databases—including analytical apps.
sign-in, firewall, users, roles, and
After you create a server, you can adjust the
configurations. You can create, manage, and
number of vCores, the hardware generation,
delete Azure Database for MySQL servers and
and the pricing tier up or down, within
databases by using the Azure portal or the
seconds. Similarly, you can increase the
Azure CLI. The online documentation for
amount of storage or adjust your backup
Azure Database for MySQL provides more retention period up or down without
information on the concepts of databases and
application downtime.
servers.
Note: Changing to and from the basic tier is
Server pricing tiers and not supported, so if you’re planning to scale, we
recommend you start with the general-purpose
resources
or memory-optimized tiers. Also, you can’t
Pricing for an Azure Database for MySQL change the backup storage type after a server is
server is determined by the configuration of created.
resources that you specify for that server,
including the pricing tier, number of vCores, Finally, it’s worth pointing out that each
and amount of storage. Create a single option within each pricing tier has an
database under the server, and that database associated set of limits, such as the number of
has exclusive access to those resources; create concurrent connections.
multiple databases under the server, and
those resources are shared.
6

High availability gateway directs the connection to the newly

sized instance.
Azure Database for MySQL provides
guaranteed high availability to help you avoid The online documentation for Azure Database
application downtime—including a financially for MySQL provides more information on high
backed service-level agreement of 99.99 availability.
percent for all services that are in general
availability. This high-availability model is Business continuity
based on built-in failover mechanisms that are Azure Database for MySQL supports locally
triggered when a node-level interruption redundant backups in the basic tier, and both
occurs, such as in the event of a hardware locally redundant and geographically
failure. redundant backups in the general-purpose
and memory-optimized tiers. You can take
The entire failover process typically takes tens
advantage of these features to provide
of seconds. Here’s how it works: At all times,
business continuity, such as recovering a
changes to an Azure Database for MySQL
server after a user or application error, or in
server occur in the context of a transaction,
the unlikely event of an Azure regional
with changes recorded synchronously in Azure
datacenter outage. The online documentation
storage when the transaction is committed. If
provides a good overview of recovery
a node-level interruption occurs, the database
scenarios and how they can affect your
server automatically creates a new node and
Estimated Recovery Time and Recovery Point
attaches data storage to the new node. Any
Objective.
active connections are dropped, any in-flight
transactions aren’t committed, and an internal To understand how you can use backup and
gateway transparently redirects any new restore as part of a comprehensive business
connections to the new instance. continuity strategy, it’s worth taking a closer
look at how these features work: Azure
Because of how the failover process works, it’s
Database for MySQL automatically creates 
important that you build your database
full, differential, and transaction-log backups,
applications to detect and retry dropped
which you can use to restore a server to any
connections and failed transactions. When
point in time within your configured backup
your application retries, its connection is
retention period. Generally, full backups occur
transparently redirected to the newly created
weekly, differential backups occur twice a day,
instance. And because the redirect is handled
and transaction-log backups occur every five
transparently by the internal Azure gateway,
minutes. The default backup retention period
your client application’s connection string
is 7 days and can be configured for up to 35
remains the same.
days. All backups are secured using AES 256-
The same failover model makes it easy to bit encryption.
scale compute resources up or down. When
The basic tier offers only locally redundant
you do so, a new compute instance with the
backup storage, whereas the general-purpose
specified resources is created, and existing
and memory-optimized tiers provide the
data storage is detached from the original
option to augment locally redundant backups
instance and attached to the new instance.
with geographically redundant backups. When
Client applications are disconnected, open,
you choose geo-redundant backup storage,
uncommitted transactions are canceled, and,
your backups aren’t only stored within the
after the client application retries the
region in which your server is hosted, but are
connection or makes a new connection, the
7

also replicated to a paired datacenter in computers can access a server, based on the
another region within the same geography, originating IP address for each request. These
allowing you to restore your server in any firewall rules apply to all databases on the
Azure region in the event of a disaster. There’s logical server and are configured as ranges of
a delay between when backups are taken and IP addresses. You can also configure the
when they’re replicated to another region, so, firewall to allow access from all Azure services
if a disaster occurs, you may face some data and all Azure subnets. Firewall rules can be
loss. configured by using the Azure portal or the
Azure CLI.
When you provision a server, you need to
decide whether to augment locally redundant The online documentation for Azure Database
backups with geo-redundant backups because for MySQL provides more information about
you can’t change this option afterward. firewall rules, including connecting from the
Whichever option you choose, Azure Database internet, connecting from Azure,
for MySQL provides up to 100 percent of your programmatically managing firewall rules, and
provisioned server storage as backup storage troubleshooting the database server firewalls.
at no additional cost.
Virtual network rules
Performing a restore creates a new server Virtual network rules, a firewall security
from the original server's backups. Recovery feature, control whether your Azure Database
time depends on several factors, including the for MySQL server accepts communications
size of the database or databases, transaction sent from particular subnets on virtual
log size, network bandwidth, and the total networks. To create a virtual network rule, you
number of databases being recovered in the must first have a virtual network and a virtual
same region at the same time. The estimated network service endpoint to reference. If you
recovery time is usually less than 12 hours. configure your database firewall to allow
Point-in-time restore is available with either access from all Azure services and all Azure
backup redundancy option, and it creates a subnets, you can use virtual network rules to
new server in the same region as your original achieve much more granular control.
server. Geo-restore, which is available only if The online documentation for Azure Database
you configured your server for geo-redundant for MySQL provides more information about
storage, allows you to restore your server to a virtual network rules, including their benefits,
different region. characteristics, limitations, and use with
The online documentation for Azure Database ExpressRoute.
for MySQL provides additional detail on how
Configuring SSL
backup and restore work.
Enforcing Secure Sockets Layer (SSL)
Data access and security connections between your client applications
and an Azure Database for MySQL server
With Azure Database for MySQL, you have
encrypts all traffic between the two, which can
several capabilities to help ensure safe and
help protect against “man-in-the-middle”
secure access.
attacks. Enforcement of SSL connections is
Firewall rules enabled by default when a new Azure
By default, all access to an Azure Database for Database for MySQL server is provisioned. It’s
MySQL server is blocked by its firewall. You worth noting, however, that some application
can use firewall rules to specify which frameworks don’t enable SSL by default
during installation, so you’ll want to check this
8

if your app is failing to connect to your Replication

database server.
Azure Database for MySQL supports two types
The online documentation for Azure Database of replication:
for MySQL provides more information on
 Data-in replication, which you can use
configuring SSL.
to synchronize data from an existing
Advanced Threat Protection MySQL server into the Azure Database
Advanced Threat Protection for Azure for MySQL service. The existing MySQL
Database for MySQL can help detect server can be running on-premises,
anomalous activities that may indicate unusual running in a virtual machine, or hosted
or potentially harmful attempts to access or by another cloud provider. You set up
exploit your databases. It’s part of the Azure data-in replication by using stored
Advanced Threat Protection offering, a unified procedures, which can be run in the
package of advanced security capabilities MySQL Shell, MySQL Workbench, or
that’s available at an additional cost. any other tool that can be used to run
queries against MySQL.
With Advanced Threat Protection for Azure
Database for MySQL, you’ll receive an alert  Read replicas, which you can use to
when suspicious database activities, potential replicate data from an Azure Database
vulnerabilities, and anomalous database for MySQL server (master) to up to five
access and query patterns are detected. It read-only servers (replicas).
works with Azure Security Center, which Read replicas can help improve the
provides details about suspicious activity and performance and scale of read-intensive
recommended actions to investigate and workloads, which can be isolated to the
mitigate the threat. replicas while write workloads are directed to
The online documentation for Azure Database the master. A common scenario is to have
for MySQL provides more information about business intelligence and analytical workloads
Advanced Threat Protection for Azure use the read replica as the data source for
Database for MySQL, including how-to articles reporting.
that cover how to set it up and begin using it. Replicas are updated asynchronously with the
native replication technology in the MySQL
Monitoring and tuning engine. From a provisioning perspective, read
Azure Database for MySQL provides several replicas are considered new servers, and you
metrics that give you insight into server manage them similarly to how you manage
behavior, which you can use for both regular Azure Database for MySQL servers. For
workload optimization and troubleshooting. each replica, you’re billed for the provisioned
All metrics have a one-minute frequency, and compute and storage.
each metric provides 30 days of history. You
can also enable logging on your server.
Both data-in replication and read replicas in
The online documentation for Azure Database
Azure Database for MySQL use the replication
for MySQL provides more information about
technology that's based on the binary log
the available metrics and logging features.
(binlog) file position native to MySQL. The
online documentation for Azure Database for
MySQL provides more information on data-in
replication and read replicas.
9

Drivers and tools compatibility

Getting started with
Azure Database for MySQL is compatible with
Azure Database for a wide variety of programming languages and
drivers, including PHP, .NET, Node.js, Go,
MySQL Python, and Java. It’s best to check the online
documentation for the latest information on
The MySQL database engine can be used with supported drivers and version compatibility.
many programming languages, the most
Your existing tools should continue to work
prevalent being Java and PHP. It’s the
with Azure Database for MySQL, as long as
database component of the popular LAMP
database manipulation operates within the
(Linux, Apache, MySQL, PHP) web application
confines of user permissions. Again, the online
stack, which is used for leading open-source
documentation is the best source of
content management systems like WordPress,
information about which management tools
Drupal, and Joomla. MySQL is also used in
have been tested and found to be compatible
many industries, including gaming.
with Azure Database for MySQL.
The following resources can help you get
Regardless of which tools you choose,
started with Azure Database for MySQL—from
remember that you’ll need to think about
creating your first database server to using the
connection resiliency and how to handle
features that we covered in the Key concepts
transient errors.
section.
5-minute quickstarts
Supported versions
Our 5-minute quickstarts can help you get
Azure Database for MySQL is based on MySQL
started with Azure Database for MySQL in the
Community Edition, using the InnoDB storage
time it takes to walk down the hall for a cup of
engine. As of March 2019, Azure Database for
coffee. To use them, you’ll need an Azure
MySQL supports the following versions:
subscription. If you don't have an Azure
 MySQL Version 5.6 subscription, you can create a free Azure
account before you begin.
 MySQL Version 5.7
Supported versions will change over time, so Step 1: Create a server
it’s best to check the online documentation The first thing you’ll need to do is create an
for MySQL versions that are currently Azure Database for MySQL server. You have
supported. two options:
 Create an Azure Database for MySQL
Updates and upgrades
server by using the Azure portal shows
The Azure Database for MySQL service you how to use the Azure portal to
automatically manages patching for bug-fix create an Azure Database for MySQL
version updates. Currently, minor version server within an Azure resource group.
upgrades aren’t supported. For example, You’ll also configure a server-level
upgrading from MySQL 5.6 to MySQL 5.7 isn’t firewall rule, get connection
supported. If you want to upgrade to the next information, connect to the MySQL
minor version, you can dump and restore a database by using the mysql
MySQL database to a server that was created command-line tool and the MySQL
with the new engine version.
10

Workbench tool, and clean up to the MySQL database by using the

resources when you’re done. mysql command-line tool and the
MySQL Workbench tool, and clean up
 Create an Azure Database for MySQL
resources when you’re done.
server using Azure CLI shows you how
to use Azure Cloud Shell to create an If you plan to continue to experiment with
Azure resource group, and then an Azure Database for MySQL (such as by trying
Azure Database for MySQL server. one or more of the following Connect and
You’ll also configure a server-level query quickstarts), you may want to skip the
firewall rule, configure SSL settings, last part, which covers cleaning up resources,
get connection information, connect in the previous quickstarts.

Step 2: Connect and query

After you create a server, you can connect to and query its database in many different ways. The
quickstarts in the following table are identified by language or tool. They assume you’ve already
completed at least one of the previous quickstarts and that you’re already familiar with whichever
development environment you choose.

Language or tool Scenario

PHP Connect to an Azure Database for MySQL database using a PHP application,
and then use SQL statements to query, insert, update, and delete data.
Java Connect to an Azure Database for MySQL database by using a Java
application with a JDBC driver, and then use SQL statements to query, insert,
update, and delete data.
.NET Connect to an Azure Database for MySQL database by using a C#
application, and then use SQL statements to query, insert, update, and
delete data.
Python Connect to an Azure Database for MySQL database by using Python, and
then use SQL statements to query, insert, update, and delete data.
Node.js Connect to an Azure Database for MySQL database by using Node.js, and
then use SQL statements to query, insert, update, and delete data.
Ruby Connect to an Azure Database for MySQL database by using
a Ruby application and the mysql2 gem, and then use SQL statements to
query, insert, update, and delete data.
C++ Connect to an Azure Database for MySQL database by using a C++
application, and then use SQL statements to query, insert, update, and
delete data.
Go Connect to an Azure Database for MySQL database by using Go, and then
use SQL statements to query, insert, update, and delete data.
MySQL Connect to an Azure Database for MySQL database by using the MySQL
Workbench Workbench application.
2

Marketplace template to quickly get your

Step-by-step tutorials WordPress application up and running.
After trying a quickstart or two, when you’re
If you’re interested in hosting your WordPress
ready to dive deeper, you can follow the step-
application in a container, you may want to
by-step tutorials to design a database and
watch the video about how to deploy a web
then create a web app.
app using a container and integrate it with
To design a database, choose one of the Azure Database for MySQL, which is described
following tutorials: in more detail in the following section.
 Design an Azure Database for MySQL
How-to guides
database using the Azure portal walks
you through using the Azure portal to After completing a few tutorials, you’ll
create a database. You’ll also probably be ready to begin experimenting
configure a server firewall; use the with Azure Database for MySQL on your own.
mysql command-line tool to create Our online how-to guides can walk you
the database; load sample data; and through many of the things you’ll likely want
then query, update, and restore that to do. There are too many to list in this
data. document, but you can find the first one here,
with the rest listed immediately below it in the
 Design an Azure Database for MySQL
navigation pane.
using Azure CLI walks you through
using the Azure CLI and other utilities Videos
to create a database. You’ll also
If you’d rather watch a few videos, here are
configure a server firewall; use the
some options:
mysql command-line tool to create
the database; load sample data; and  Azure Database for MySQL product
then query, update, and restore that videos are a great way to familiarize
data. You can use Azure Cloud Shell in yourself with the database service.
the browser or install the Azure CLI on  Learn about Azure Database for
your own computer to run the code MySQL is the first in a series of videos
blocks in this tutorial. that show how you can migrate your
After you’re designed a database, you’ll be applications to Azure or build
ready to create a web app. Build a PHP and advanced, new applications with Azure
MySQL app in Azure teaches you how to Database for MySQL. This video briefly
create a PHP app in Azure and connect it to a introduces the series and covers the
MySQL database. When you’re finished, you’ll features and benefits of this database
have a Laravel app running on Azure App service.
Service on Windows. To deploy to App Service  Migrate your MySQL applications to
on Linux, see Build a PHP and MySQL app in Azure using the Azure Database
Azure App Service on Linux. Migration Service provides a detailed
If you’re already familiar with WordPress, you walkthrough and demo on how to
can set up a WordPress site on Azure App migrate your application to Azure
Service that uses an Azure Database for Database for MySQL with minimal
MySQL database. Note: This isn’t a step-by- downtime.
step tutorial. It uses the existing Azure  Deploy a web app using a container
and Azure Database for MySQL shows
3

how you can deploy and scale your  Read replicas, which you can use to
web app in the cloud and replicate data from an Azure Database
demonstrates how Azure Database for for MySQL server (master) to up to five
MySQL works with Azure App Service. read-only servers (replicas) within the
The demo shows how to deploy same Azure region. The how-to guides
WordPress (which typically uses provide step-by-step instructions on
MySQL as a database) and how to how to create and manage read
make WordPress work with Azure replicas in Azure Database for MySQL
Database for MySQL. by using the Azure portal or by using
the Azure CLI.
 Connect applications running in
Kubernetes to Azure Database for
Developing with Azure
MySQL shows how to connect
container applications running in Kubernetes Service
Kubernetes to Azure Database for Azure Kubernetes Service provides a managed
MySQL by using the Open Service Kubernetes cluster you can use in Azure.
Broker for Azure, an implementation Connecting Azure Kubernetes Service and
of the Open Service Broker API for Azure Database for MySQL covers some
Azure services. The video covers the options to consider when using Azure
rationale for using a Service Broker Kubernetes Service with Azure Database for
and how it can help you benefit from MySQL, including accelerated networking and
the built-in high availability and Open Service Broker for Azure.
security offered by Azure Database for
MySQL. Advanced Threat Protection
Advanced Threat Protection for Azure
Replication Database for MySQL can help detect
Azure Database for MySQL supports two types anomalous activities that may indicate unusual
of replication: or potentially harmful attempts to access or
 Data-in replication, which you can use exploit your databases. Our how-to article on
to synchronize data from a MySQL Advanced Threat Protection for Azure
server that’s running on-premises, in Database for MySQL walks you through
virtual machines, or in a database setting up threat detection by using the Azure
service hosted by another cloud portal, exploring anomalous database
provider into the Azure Database for activities, and exploring threat-detection
MySQL service. How to configure alerts.
Azure Database for MySQL data-in
replication walks you through creating
Additional resources
an Azure Database for MySQL server The following are some additional resources
to be used as a replica, configuring the to help you get started with Azure Database
master server, dumping and restoring for MySQL.
the master server, linking the master Limitations
and replica servers to start data-in
Limitations in Azure Database for MySQL
replication, and relevant stored
describes various types of limits in the
procedures.
database service—including maximum
connections per pricing tier/number of
4

vCores, storage engine support, data Azure Database for MySQL data-in replication
manipulation statement support, functional stored procedures covers the stored
limitations, and current known issues. procedures needed to set up or remove data-
in replication between a master and replica.
Samples
Azure CLI samples for Azure Database for Azure Database Migration Guide
MySQL provides links to sample Azure CLI The Azure Database Migration Guide provides
scripts for Azure Database for MySQL— step-by-step guidance on migrating to various
including scripts to create a server and firewall Azure data services, in addition to a selection
rule, scale a server, change server of case studies and partner tools. You can just
configurations, restore a server, and enable select your source and target to get started,
and download server logs. or, if applicable, you can go directly to the
scenario on migrating from MySQL to Azure
References
Database for MySQL.
Azure CLI reference for Azure Database for
MySQL provides a list of Azure CLI commands Other useful links
for managing Azure Database for MySQL  Pricing information for Azure
servers, with links to more information on Database for MySQL
each command.
 Online documentation on Azure
Azure Database for MySQL REST API reference Database for MySQL
covers the REST operations you can use with
 Azure pricing calculator for Azure
Azure Database for MySQL. You can use these
Database for MySQL
REST operations to create, delete, manage,
and list servers, server configurations,  Azure service health dashboard
databases, server logs, and firewall rules, and  Azure product availability by region
to list all available REST operations.
 Azure Database for MySQL blog
5

Conclusion
Microsoft Azure provides an end-to-end you’ll have everything you need to build great
platform for open-source applications, apps and deploy them across the globe.
including a fully managed MySQL database
service for app developers. Azure Database for
MySQL can be provisioned in minutes and Sign up for a free Azure
scaled in seconds, with built-in high account and get started with
availability and a simple, flexible pricing model Azure Database for MySQL
that includes automatic patching and backups, today.
monitoring tools, essential security features,
and more. And because it’s a part of Azure,
when you choose Azure Database for MySQL,