>> Maybe you've heard of PostgreSQL,
but how does it relate to Citus and Hyperscale and Azure Arc?
Learn more in this episode of Data Exposed.
[MUSIC]
>> Hi, I'm Anna Hoffman and
welcome to this episode of Data Exposed.
Today, I'm joined by JY,
a Program Manager on Azure Data.
Thanks for being with us today.
>> Anna, thanks for having me.
>> Always a pleasure.
Today we're going to be talking about Azure Arc
enabled PostgreSQL Hyperscale.
Now, before we get into that,
typically on this show we've only talked
about Azure SQL and SQL Server.
Can you talk to me a little bit about what Azure
brings to customers that are currently using PostgreSQL.
>> Yeah, sure. So Azure provides to
customers a great choice of data services.
In particular, when it comes to open-source database engines,
Azure already offers managed services for
MySQL, MariaDB, and PostgreSQL.
Azure offers PostgreSQL database engine
in a few different deployment options.
One is Azure database for PostgreSQL flexible server.
Flexible server is a new deployment option
for our managed database service in Azure.
It is in preview right now.
Number two, Azure database for Postgres Hyperscale Citus.
Hyperscale Citus is a built-in deployment option
for our Postgres managed service in Azure,
and what it does is that it enables
you to scale Postgres [inaudible].
The Hyperscale Citus uses
a Citus extension to transform
Postgres into a distributed database systems.
Citus distributes the data and
do queries across multiple nodes in the cluster.
I should mention as well that
the Citus extension is open-source and
that the Citus team is now part of the Postgres team at Microsoft.
Hyperscale Citus fits particularly well
for multitenant applications like SaaS application,
in real-time analytics application
that are heavy on processing data.
Hyperscale Citus is offered both as a managed service
in Azure and as
an hybrid solution with Azure Arc enable Postgres Hyperscale.
>> Awesome. Cool. Thanks for that overview
and explaining the differences.
Now, at the end you were mentioning Azure Arc.
Can you tell me a little bit more about what that is
and how it relates to PostgreSQL Hyperscale.
>> Yeah, sure. First, let's put things in perspective.
This is about Azure Hybrid that
Microsoft offers to our customers to
solve the increasing complexity they are
facing in terms of number of applications they have to manage,
and the variety of infrastructure they have to manage,
from on-premises to Multicloud.
It's very complex.
Azure Hybrid comes with three pillars.
We have Azure Stack,
Azure IoT, and Azure Arc.
Azure Arc brings Azure services and
management capabilities to any infrastructure.
It encompasses Azure Arc for Servers,
Azure Arc for communities,
and Azure Arc for data services.
Kubernetes provides the abstraction layer that makes
it possible for Azure Arc to run on any physical infrastructure.
One of these services that are available today with Azure Arc
enable data services is Azure Arc enabled PostgreSQL, Hyperscale.
>> Cool, so you mentioned that
Postgres is offered in Azure in two deployment options,
and you mentioned this earlier,
single node and Hyperscale,
and then it's also offered in two ways.
This Microsoft manage service and also,
this customer manage hybrid type of solution.
Now, when customers think about this,
how does Azure differentiate here?
>> Azure is the only Cloud that
provides two deployment options for the Postgres database engine.
Single node in Hyperscale,
both as a managed service,
as an hybrid solution.
This provide the flexibility and
the scale that our customers tell us they need.
Why that's important? Let me give you an example.
A few days ago, I was discussing with bank in Southeast Asia.
They want to modernize and move to the Cloud.
However, like quite a few of our customers,
they cannot migrate or goes over night,
and for some compliance regulatory reasons,
they also need to keep some of the workloads on their premises.
Azure enables them to modernize in their terms at
their pace using Azure Postgres Hyperscale,
both as a managed service in Azure,
in their premises with Azure Arc enable Postgres Hyperscale.
>> Okay. Got it, so if I were to try to summarize,
because this is new to me.
Azure Arc enabled PostgreSQL Hyperscale
is a hybrid solution that's going to do two main things.
It's transforming
the standard PostgreSQL database engine into distributed database,
which is going to allow a really big levels of scale,
especially because of the Citus extension,
which is now part of Microsoft and it's
also open-source, and then additionally,
I'm going to be able to run this in
really any physical infrastructure,
whether that's my datacenter or my customer's datacenter or
maybe at the edge or even in other Clouds. Is that right?
>> Yes, Anna. Exactly. You get it.
>> Okay. Cool. What does a customer get when they start
to use this Azure Arc enable
PostgreSQL Hyperscale wherever it is that they're using it.
>> Sure. Today, in preview,
customers can deploy on
any physical infrastructure in any Kubernetes.
They also get the typical capabilities and
features of Azure database for Postgres Hyperscale,
for instance, backup, restore,
or several parameters using Postgres extensions,
scale up, down, and out.
They also get monitoring and log analytics capabilities.
Since any deployment ships with Griffin and Kibana,
they can also upload their Azure Arc inventory information to
the Azure portal and their benefits
from the unified monitorability experience.
In terms of tooling customers has a choice
between experiences with command line interfaces,
with ASI data or kubeCTL to which ASI data is integrated,
or graphical user interfaces tools like [inaudible] ,
Kibana, Azure Data Studio, and the Azure Portal.
Let me show the Azure portal.
Now, is going to so that you can see what it looks like.
We have done a lot of work to
provide seamless experience between
the portal and Azure Data Studio,
so you have the same experience with a product
whether you are connected or disconnected with an offline tool.
>> Awesome, very cool.
That's really great, I obviously still have a lot to learn,
and I'm sure many of our customers
and viewers are interested in learning more.
How would you recommend folks get started?
>> Anna, the simplest way to do that is
for customers to go and look at the documentation,
there they would find step-by-steps about
how to deploy the product and how to use it,
and maybe more importantly,
they can find our Azure Arc jumpstart program,
which provides them with a set of
ready-to-go deployment that they can use to try out the product.
That is useful in particular if our customers do not have
a Kubernetes deployment available
or if the don't know much yet about Kubernetes,
so there's just URL to remember, it's aka.MS/AzureArcdata.
>> Awesome. Cool. That's really exciting
because I didn't know that you could go in
and take a look at this stuff without having to deploy
anything to get your feet wet and get used to the service.
That's really cool, we'll be sure to put
a link to that URL that you mentioned in the description,
as well as a link to a few other things to get started.
JY, thanks so much for being on the show today,
I personally learned a lot and I think
our viewers have probably learned a lot as well.
To our viewers, if you like this video,
please like this video,
subscribe to our channel and we
hope to see you next time on Data Exposed.
[MUSIC]