>> Azure Database for MariaDB is
the newest open source database available on Azure.
It's a fully managed service with built-in high availability,
automatic backups, and scaling of resources that meet your needs.
Andrea Lam is here to give us
an introduction and demo its use today on Azure Friday.
[MUSIC]
>> Hello, this is Lara Rubbelke,
and today on Azure Friday,
we have Andrea Lam,
a Program Manager with the Azure OSS databases
team and she's here to talk to us about MariaDB. Hello, Andrea.
>> Hi Lara, how are you today?
>> I'm doing great.
>> Awesome.
>> So what are you going to talk about today?
>> So today, I'm here to talk about
the Azure Database for MariaDB service.
We brought this up into GA in December of 2018.
So I'm here to talk about some of the different things
that you can do with the managed service and walk through
a demo using WordPress
with a template that was developed by our partners at Bitnami.
>> Fantastic. That sounds like a pretty exciting demo.
So talk to me about why MariaDB?
>> So we chose MariaDB as
the next database to bring into our OSS database platform.
Today, we have MySQL,
Postgres, and we now have MariaDB.
MariaDB was more of a strategic choice.
We realized that there's a lot to do
with Microsoft and embracing the open source community.
So we wanted to make sure that we kind of brought
ourselves into the conversation with the open source community.
We even joined the MariaDB Foundation as a platinum sponsor.
So really trying to help drive the community in the conversations
about what it is to develop against MariaDB.
We've also tried to push some of our improvements into
the MariaDB community engine as well as
some of the drivers and tools that you can use with MariaDB.
>> That's fantastic. So we are actively
contributing to the open source.
>> Yes, and it's been a really awesome journey.
We've gotten a lot of really great feedback
so far from the community.
It's definitely a work in progress.
We're definitely trying to do the best that we can
to communicate and work with developers
in the community and really try to give back.
>> Great. Well, what would you like to show us?
>> So today, I'm here just to show you
a demo on the actual MariaDB service.
Essentially, we have partnered with Bitnami.
Bitnami has a great open source community of their own.
They definitely have the mind share in the community,
and the thing that we realize is
we wanted to make sure we partnered with folks
like Bitnami to ensure that it's not just Microsoft
pushing out images and stuff into the Azure Marketplace,
we wanted to make sure that we gave
everybody a slice of the pie, if you will.
>> Great.
>> So with the MariaDB service,
as a managed database service,
we want to offer stuff like high availability,
automated security, patching
backups, and all that kind of good stuff.
So in the demo today,
I'm going to show you how to provision
a WordPress blogging website
with Azure Database for MariaDB as the backend store.
>> Okay.
>> All right, so let's switch over.
I'm going to go in to the Azure Marketplace.
So today, Bitnami has two images available.
The first is WordPress,
so WordPress being one of
the most popular blogging or CMS systems available,
very popular in the open source community.
MariaDB is one of the nice drop-in
replacements for MySQL to be used as a database.
Bitnami has also released the Drupal image,
and the Drupal image, again,
also a very popular open source CMS,
but today, I'm going to focus on WordPress.
What I've done is I've taken this existing WordPress template that
they've released with us and I have pre-baked it.
So from the Azure portal,
what you would do is you would go into "Create a
resource" and you could actually
go search up WordPress Bitnami.
What you'll find is
the existing WordPress with Azure Database for MariaDB template.
What I've done is I've gone ahead
and pre-provisioned this ahead of time.
So once you click through all the steps,
what you'll find is in a resource group that you've created,
you'll find an Azure Database for MariaDB server already
provisioned as well as a VM that
hosts the actual WordPress application itself along with some
of the IP, resources, etc.
So there's also a storage account associated with it.
So as part of this,
what I wanted to show you is how easy
it is to just with a few clicks,
be able to provision
a WordPress application along with the MariaDB server.
So once you have this up and running, what does it look like?
So if I quickly switch over and I go into the front end,
and actually navigate to
the front end which is hosted on a virtual machine,
you'll see here that this is the DNS name available,
have it open in this tab.
You'll see this is a generic WordPress site.
I haven't done anything special to it,
this is what you can get in the open source community today.
You'll see it starts you off with the Hello world!
screen. Then from there,
it's really up to you to start writing your first post,
spread the words of what you want to put out into the Internet.
So I'm going to log in here as
the main user and I'll have that open in a second tab.
Essentially, this is the main "Dashboard" that you can
use to manage your WordPress website.
So I wanted to show you,
okay, that's great, I have a WordPress here.
What does that mean for the database?
Where does the data go? So I'm going to create my very first post.
Let's go ahead and we'll start typing something.
So let's call this Azure Friday and I'm going to say,
"It's great to be here."
Let's go ahead and "Publish" that.
We'll publish that immediately.
From here, I can actually go view the post,
what does it actually look like on my website.
You can see here Azure Friday, it's great to be here.
So awesome, it's now in the WordPress site.
But how do we actually know
that it's made it to the backend database?
So I'm going to open MySQL Workbench which can be used
to actually query both MySQL and MariaDB engines.
I've already connect to it, and let's go ahead and take
a look at the WordPress posts table.
This is where all of the blog posts will
get pushed into and managed.
So as you can see here,
there's no existing blog that I had just written.
So let's go ahead and rerun the query,
and you can see here that there's a new post that was created,
Azure Friday, it's great to be here.
So mainly, I just want to show how
easy it is just to get your very first blog post up and running,
how to integrate with the Azure Database for
MariaDB service without having to do anything extra.
You don't have to go do a second deployment and all
that is involved in a one-stop shop.
That's what's really awesome about
the service and working with partners.
>> Right. Now, why would we want to take advantage of the service
versus maybe just running it in a VM on our own?
>> So as part of a managed service like I mentioned,
you get all of the automatic patching,
the backups are all taken for you.
We also push any of
the security patches that say there's a security bug fix.
You don't have to go manage that by yourself.
>> So as a developer, it's just super easy for you.
>> Yeah. Also, I wanted to highlight
that with the MariaDB service,
you can scale your compute and your storage resources as you need.
So let's say during the peak time of the business day,
you want to make sure that you have as much compute allocated to
that server as possible and then spin
that back down during off-peak business hours,
helping with the ability to scale
automatically and elastically as you need.
>> That sounds like a great option for me, that's a great option.
What more can we expect from your contributions with MariaDB?
>> So when in terms of the service,
we're working on bringing more and more features.
For example, one of the new features we just brought
up was the VNet service endpoints.
So this allows you to connect from a virtual network
to your Azure Database from your MariaDB server.
We're constantly working on new improvements to get it to
the same point as we have for
MySQL and Postgres database services.
>> That's great. Where can we go learn more?
>> So you can check out aka.ms/mariaDB.
From there, that's our service landing page,
you can go learn about what's available,
pricing, go read up on documentation.
We also have a UserVoice forum that
we've been looking at and tracking to help get
feedback from our customers to learn
about what to prioritize next in terms
of different types of features that they're looking for,
whether it's to beef up different parts of
the service and to
bring up any new improvements
that they'd like to see in the service.
>> Great. Well, thank you so much. Is there anything more?
>> Follow us on Twitter.
Our Twitter account is @AzureDB, @mariadb,
so use that to learn about new announcements,
new features that are coming up,
and also check up the documentation.
If you guys have any questions,
you can also reach out to us over Twitter.
Yeah, that's basically it.
>> Fantastic. Thanks again, Andrea.
It was great to see you again.
>> Great to see you as well.
>> We are learning all about Azure Database
for MariaDB today on Azure Friday.
[MUSIC]