[MUSIC]
>> Hi. My name is Parikshit Savjani,
and I lead the Product Management team for Azure Database for
MySQL and MariaDB servers at Microsoft.
In this video, my goal is to
introduce you to Azure Database for MySQL service.
After the session, you will know why
developers love MySQL and its top use cases in the industry,
what options are available for you to
host your MySQL environment on Azure,
what are the benefits of hosting your MySQL server
in a fully managed service like Azure Database for MySQL,
what are the kinds of mission critical workloads
our customers are running on Azure Database for MySQL service.
So without any further ado, let's get started.
Why should I even care about learning MySQL?
When should I consider MySQL for my applications?
These are some of the questions which might come to
your mind when you're building a new application.
Let me help answer a couple of these questions in this section.
Developers love MySQL because of
its rich community support knowledge base tools and ecosystem.
Most programming languages and frameworks support MySQL today.
MySQL is open source and available
for use under general public licensing.
Which means there is no additional cost for
you to build your application using MySQL.
MySQL is readily available and supported by
all major Cloud Providers in the market.
This helps you address
your application portability requirements as well,
which is important for some of the Developers' analysis.
MySQL is a reliable performer and supports
horizontal scalability using its rich replication functionality,
which makes it ideal for
internet scale web and mobile application.
Finally, it's a key part of LAMP Stack.
LAMP stands for Linux,
Apache, MySQL, and PHP.
These are some of the top reasons why MySQL is
voted as the most popular database engine by developers
and community as you can see from
the latest Stack Overflow Developer Survey
and DB engine database rankings.
MySQL has many use cases in the industry,
as you can see in the slide.
But if you understand the underlying theme and
the key takeaway for you is
when you are thinking of building of a web,
or a mobile application which is portable, performing,
reliable and can scale to internet scale traffic at low cost,
you should consider MySQL.
Now that you have a good understanding of
why and when to use MySQL,
let us deep dive into what are the options
available for you to run MySQL on Azure.
Fundamentally, there are two options for
you to host your MySQL database on Azure.
First, running MySQL on Azure VM,
also referred to as IaaS option.
In this scenario, hardware and virtualization layer
is managed by Microsoft,
while you will need to manage MySQL server,
high availability of the server,
data protection, patching,
security, and monitoring.
The other option is to leverage Azure Database for MySQL service,
also referred to as PaaS option.
Where you would focus on your application
development, schema development,
and user management and performance,
which is a shared responsibility.
Next, let us deep dive into Azure Database for MySQL service.
Azure Database for MySQL is
a fully managed service running
open source community version of MySQL,
that allows you to lower your total cost of ownership
by 48 percent compared to on-premises.
In less than five minutes,
you can provision or scale your MySQL server.
The server supports same zone time zone
redundant high availability backed by SLAs
that provide up to four nines of uptime.
You can also control maintenance window for
your server to maximize
business uptime for your planned deployments.
You can deploy and ship your application updates faster by using
GitHub Actions and leverage rich integrated Azure ecosystem.
Finally, but more importantly,
you can build your application with
peace of mind thanks to a built in
encryption and enterprise grade security features provided
by Azure to detect and prevent potential threats on your server.
In Azure Database for MySQL Flexible Server Architecture,
we have separated computer storage for higher availability.
Your MySQL server runs on Linux VM,
with data stored on premium file storage.
The data is replicated three times
across the storage for better resiliency.
You can further opt in for same zone or zone
redundant hot standby for higher availability.
In high availability configuration,
the data is synchronously replicated across
the storage to support automatic failover and zero data loss.
The failover typically completes
in 60 seconds and you are expected to have
[inaudible] logic built into your application
with connection timeout more than 60 seconds.
Flexibility of the architecture is zone aware,
which means you can define
the availability zone when you
want your primary server to be hosted.
This is very useful when you want to co-locate
your application and database server to minimize latency.
The database is automatically backed up and
the backups are stored on a locally redundant storage.
But optionally you could also
store backups on a zone redundant storage or
a geo-redundant storage to support
data protection and to support disaster recovery scenarios.
You can deploy your application on VMs skills set,
Azure Kubernetes Services or Azure App Services,
and since the service runs on
open source community version of MySQL,
you do not need to refactor
the application or need any additional drivers.
It just works. Next, let us see what are some of
the top mission critical workloads
running on Azure Database for MySQL service.
HSBS PayMe is a digital payment and
wallet solution used by Hong Kong Citizens for Mobile Payment.
The solution leverages Azure Database for
MySQL service as its operational store,
and uses read replica to scale out
analytics and reporting using Azure Database.
KMD migrated their healthcare SaaS application, Nexus,
to Azure Kubernetes Services and
Azure Database for MySQL services in Azure.
The migration helped them improve scalability
and uptime of KMD Nexus application.
Around 70,000 Healthcare Professionals in
60 municipalities in Denmark
depend on the software for collaboration each week.
LinkedBrain, is a game developer company
headquartered in Japan that
wanted to shift from IaaS to
PaaS to reduce their cost and operational burden.
They chose Azure Database for MySQL Flexible Server service,
as their preferred migration target
for deploying their fleet of MySQL servers.
We have many of the publicly reprehensible customers who trust
their mission critical applications with
Azure Database for MySQL service.
With this, we come to the end of this session.
I hope by now you'll know why
MySQL and when to use MySQL for your application,
the hosting options available for you to
host your MySQL Workload on Azure,
what are the benefits for running
on Azure Database for MySQL service,
and how Flexible Server is architectured,
and some of the mission critical workloads which are already
running on Azure Database for MySQL service today.
Thank you.
[MUSIC].