Azure SQL - MySQL, PostGreSQL, SQL on Azure.pdf

Azure SQL - MySQL, PostGreSQL, SQL on Azure! This presentation helps you understand operational databases for open source and SQL on Linux variations for the Microsoft Azure cloud. Microsoft Azure allows for historically linux-based databases to be fully supported in platform as a service on Azure. This reduces operational overhead, and allows you to innovate faster. There is tremendous opportunity in every industry and organization for Data and AI powered Digital Transformation to accelerate transformative business growth and unlock savings. Digital Transformation entails re-imagining the use of technology and data to innovate intelligent applications that transform products, customer experiences, employee productivity, and operations efficiencies.
 
Data and AI are the oxygen to nourish and grow transformative business outcomes with digital investments. To maximize the impact of their digital transformation investments, organizations must also evolve their Data and AI strategy and investments.
Data modernization is the path drives meaningful business transformation in stages, as you evolve in your data maturity.

Looking at your current data estate, how would you position your organization if you’d have to think of your business strategies today?
How are you doing reporting?
Are you running both relational and non-relational databases?
Do you have any open-source technologies supporting your data estate?
How do you do reporting?

Do you see your business as having a more reactive approach to leveraging data for faster informed decisions, informative or predictive?

What are your goals for the mid and long term?

1. George Walters
[email protected]
https://www.linkedin.com/in/georgewalters/
PostgreSQL, MySQL and SQL
Server on Azure

2. Digital Transformation accelerates your business growth and
unlocks savings
and Data
is the Oxygen of Digital Transformation
Data-driven transformations can yield significant
benefits with up to
61%
increase in
revenue performance
1
Signal
Signal
Signal
Signal
People
Operations
ProductsCustomers
Data
& AI
In
te
lli g
entApp
l
i
c
a
t
i
o
n
s
Action
Action
Action
Action
Deeper
relationships
Customer
signals
More effective
employees
Employee
signals
Better
products
Product
telemetry
More
efficient ops
Operational
data
1
“How to lead a data-driven digital transformation,” Harvard Business Review

3. Operational databases
Analytics & AI
Data Governance
Operational Databases
What datado you have?
Is it trustworthy?
Is it siloed?
What’s your compliance exposure?
How much are you spending with your current
data platform?
Can people in your company access the data
needed to make informed decisions?
How can you enable faster
business insights?
but data realities are
becoming more complex

4. Data insights
transform business
and drive outcomes
Transformative
Data capture is
scalable and informs
business decisions
Predictive
Data is managed
centrally and informs
the business
Informative
Data is locally
managed. Data
used reactively
Reactive
is the path that drives meaningful business transformation in stages
Data modernization

5. Achieve more with
Azure
Maximize value
by optimizing cloud
investments
Emerge stronger
by embracing technology to
differentiate
Achieve efficiency
by securely migrating &
modernizing on Azure

6. 1
Results are based on interviewed customers. “Analyzing the Economic Benefit of Migrating from On-premises Instances to Azure Database for PostgreSQL,” a commissioned study conducted by The Enterprise Strategy
Group on behalf of Microsoft, July 2022
.
²Forrester: The Total Economic Impact of Microsoft Azure Security Center.
³Trust your cloud | Microsoft Azure
4
”Understanding Why Analytics Strategies Fall Short for Some, but Not Others,” Harvard Business Review Analytic Services
growing your data maturity with hybrid,
migration programs and FREE tools
4
54%
Near real-time
insights from
edge to cloud to
help increase
profits up to
Emerge Stronger
+3.5K cybersecurity experts help
safeguard your assets & data³
Reduce time to²
threat mitigation by
Maximize Value
62%
Save up to
1
with Azure Database
for PostgreSQL
when migrating on
premises workloads
to Azure
Achieve Efficiency
Do more with less with Azure
50%

7. Migration triggers
Quickly integrate
acquisitions
Urgent
capacity needs
Business
agility
Security
threats
Software and
hardware refresh
Datacenter contract
expiry
Cash flow
challenges
Application
innovation
Software end
of support

8. Azure open-source statistics
>60%
of VM cores
are Linux
>60%
of Azure
marketplace images
are Linux-based
>47K
customers using
Azure open
source databases
>100K
Azure Data Studio
instances with Azure
open source
database extensions

9. Azure takes the administrative overhead
out of PostgreSQL and MySQL, as well as SQL Server
Azure Databases for PostgreSQL and
MySQL, and Azure SQL Database, are fully
managed, enterprise-ready community
databases-as-a-service.
Greater manageability and security
Improved performance and intelligence
Global scalability
Built-in tools and resources
Machine learning capability
Managed by customer
Managed by Microsoft On-premises
Datacenter
management
Hardware
Virtualization
O/S provision
/patching
Database provision/
Patch/Scaling
High availability
/DR/Backups
Data
Applications
IaaS
Datacenter
management
Hardware
Virtualization
O/S
Database provision/
Patch/Scaling
High availability
/DR/Backups
Data
Applications
PaaS
Datacenter
management
Hardware
Virtualization
O/S
Database provision/
Patch/Scaling
High availability/
DR/Backups
Data
Applications
Intelligent
performance
Intelligent security

10. Azure relational database services
Fully managed community
databases
Minimal admin of PostgreSQL, and
MySQL
Best total cost
of ownership
Built-in high availability for lower
operating costs
Built-in
intelligence
Intelligence for optimized
performance and security
Highly available and
flexible
Easy to deploy and scale with up
to a 99.99% SLA
Secure and compliant
Advanced Threat Protection and
Azure IP Advantage
Integrated with Azure services
Streamlined experience for open-source
frameworks and languages

11. Azure relational open-source databases
PaaS and hybrid databases
Platform
-
as
-
a
-
Service
Azure Database
for MySQL
Azure Database
for PostgreSQL
Flexible Server

Best for migrating, modernizing, and building
PostgreSQL apps with the broadest Postgres
extension support
Azure Cosmos DB for
PostgreSQL
Distributed Postgres
Best for building cloud-native &
digital apps with a fast PostgreSQL
database for any scale
Hybrid
Azure Arc-enabled PostgreSQL
Best for hybriddata workloads operating on any
infrastructure with or without a direct connection to the cloud

12. Maximum control and flexibility to meet your
workload needs with Flexible Server
Maximum control
for your databases
Control planned downtime with
custom maintenance windows
Network isolation with
VNet integration and
network security groups
Multiple configuration parameters
for fine grained database
optimization and tuning
Build resilient apps
across availability zones
Ensure data is always
available with zone
redundant high availability
Zero data loss within single and
multiple availability zones
Minimize latency with co-location
of app & data
Simplified
deployment experience
Full compatibility with community
edition MySQL and Postgres
Stop/Start and burstable capabilities
for cost optimization
Save up to 48%¹ with MySQL and
62%² on PostgreSQL TCO when
migrating to Azure

13. Managed solutions that do more for you
*in connected scenario
Managed by
customer
Managed by
Microsoft
Machine learning
capability
SQL Server
on Azure VMs
Datacenter management
Hardware
Virtualization
Operating system
Database provision/
Patch/Scaling
Data
Applications
High Availability /DR/Backups
SQL instance-level features
Database
Azure SQL
Managed Instance
Data
Applications
Datacenter management
Hardware
Virtualization
Operating system
Database provision/
Patch/Scaling
High Availability/ DR/Backups
Intelligent performance/security
SQL instance-level features
Database
Azure SQL
Database
Database
Applications
Datacenter management
Hardware
Virtualization
Operating system
Database provision/
Patch/Scaling
High Availability/ DR/Backups
Intelligent performance/security
Data
Azure SQL
Edge*
Database
Applications
Hardware & Operating System
Container Platform
Operating system (container)
Database provision/
Patch/Scaling
High Availability/ DR/Backups
Intelligent performance/security
Data
Device management (IoT Hub)

14. Optimize your Azure SQL Costs
Maximize existing
investments in on-
premises licenses with
discounted rates of up
to 55%
Learn more
Prepare resources in
advance and save up
to 33%. Combine with
Azure Hybrid Benefit
for savings up to 80%.
Learn more
Azure Hybrid Benefit Reserved Capacity
Key offers lower your total cost of ownership
Save up to 55% versus
list prices, eligible with
active Visual Studio
subscriptions.
Learn more
Dev/Test Pricing
Save on licensing costs
for a secondary
deployment for disaster
recovery
Learn about SQL MI
Learn about SQL DB
Learn about SQL VM
License-Free Standby
Replica

15. Optimize costs with Azure SQL Database serverless
Cost-effective
•Pay only for compute resources you
consume, on a per-second basis
•Further optimize costs with
configurable compute thresholds
Automatic scaling
•Adapts compute resources to the
workload without sacrificing
performance
•Automatically pauses and
resumes
Fully managed & intelligent
•Fully-managed and intelligent
database service
•Built-in 99.99% availability

16. Significantly reduce cost when
migrating workloads to PaaS
Microsoft commissioned
Enterprise Strategy Group to
conduct Economic Value studies
to examine potential cost savings
and business benefits enterprises
would achieve from migrating
on-premises workloads to Azure
Database for PostgreSQL and
Azure Database for MySQL.
Key PostgreSQL report
benefits and findings
1
Up to 62%
Cost savings when migrating on-
premises PostgreSQL instances to
Azure Database for PostgreSQL
+$11.6M
Additional revenue due
to faster time to market
Key MySQL report
benefits and findings
2
Up to 48%
Cost savings when migrating on-
premises MySQL instances to Azure
Database for MySQL
+$15.5M
Additional revenue due
to faster time to market
1 Results are based on interviewed customers. “Analyzing the Economic Benefit of Migrating from On-premises Instances to Azure Database for
PostgreSQL,” a commissioned study conducted by The Enterprise Strategy Group on behalf of Microsoft, July 2022.
2 Results are based on interviewed customers. “The Economic Value of Migrating and Modernizing On-premises Instances to Azure Database for
MySQL,” a commissioned study conducted by The Enterprise Strategy Group on behalf of Microsoft, September 2021.

17. MigratingOSS Databases to Azure
Option
Dump &
restore
Azure Database
Migration Service
Overview
Manual, but simple
Best for < 100 GB databases
Offline migration
Downtime required
Automated process
Best for up to 1 TB databases
Online or offline method
Minimal downtime
Supported by
Offline
only

18. HarvestMark chooses
Azure over Amazon for
improved security and
performance
Customers of HarvestMark wanted them to find a new
cloud-services provider that would avoid a conflict of
interest and give them the performance and peace of
mind for their solutions
•HarvestMark migrated its existing PostgreSQL database to
Microsoft Azure Database for PostgreSQL​ in just two hours
•During the migration there was no impact to their customers.
•HarvestMark saw a 20 percent decrease in cloud hosting
service costs.
•The company maintains its high standards for reliability and
speed with Azure.

19. Azure is also the home for your Oracle workloads
Leverage Azure with IaaS options or migrate to a fully managed database for more benefits
Oracle on Azure IaaS
Azure Virtual
Machines (IaaS)
Enterprise ready Lower TCO Built-in security
Integrated with Azure dataecosystem
Proven resilience & stability
Always on Azure
Modernize to fully managed databases
Azure Database
for PostgreSQL
Azure SQL Azure
Cosmos DB
Get more with
fully managed databases
Fully
managed
Intelligent
Performance
Highly
scalable
High
Availability
Maximum
control

20. ÖBB expands its business and
improves time to market using
Azure
Challenge
Modernize ticket-selling platform to release software faster, gain
the ability to scale-up capacity, and offer the platform to Austrian
transportation agencies as a B2B multi-tenant SaaS offering.
Solution
Using Azure managed app and database services enabled:
•One week build process from dev to test to production
•Lowered operational overhead by modernizing 11TB of
Oracle data to Azure Database for PostgreSQL
•App development flexibility using containers with Azure
Kubernetes Service
•Leveraging reserved instances to save at least 30% on
database costs
•Integrated an AI-assisted chatbot to automate basic
customer interactions
“Using Azure for releasing software increases our cost
benefits. This allows us an increased degree of automation
and frees up resources.”
Werner Huss, Head of Engineering

21. Minecraft Realms migrates to Azure Database
for MySQL
Gaming
Azure provides cost efficiency and improved
gameplay through lower latency experiences
that leverage Azure Front Door and Azure's
global footprint
Azure led to significantly smaller code
footprint, simpler deployments and a more
flexible architecture – saving precious
developer time
Minecraft Clients Azure
Payments
Realm
Telemetry
Job Agents
Frontends
Get Metadata
Connection
info.
Connect to
Server
Allocate/Reclaim VMs
PlayFab
“Now that the Realms migration is complete, our deployments on Azure are significantly simpler with more efficient resource
utilization and more flexibility in our architecture.”

22. Situation: Solution: Impact:
“The PostgreSQL database platform in Azure is really powerful, resilient, modern, and
it enables business continuity with built-in redundancy and disaster recovery.”
​​As the digital and commercial hub
for the companies of Ahold
Delhaize USA, Peapod Digital Labs
(PDL) builds and operates
omnichannel solutions for the retail
brands. It needed to transform from
on-premises to cloud-first
operations on a new platform.​
—Amit Shah, Chief Technology Officer, Peapod Digital Labs​
​​PDL’s transformed store-picking app
is built and delivered on Microsoft
Azure, taking full advantage of the
speed and efficiency of Azure
managed databases. The app is
used in-store to select products for
online shoppers to pick up or for
delivery.​
​​Development and delivery is faster
and more agile with the new cloud
data platform, with the transformed
app demonstrating up to 3 percent
productivity improvement, 33
percent reduction in errors, and 50
percent reduction in training time
for in-store pickers.​
Customer:
Peapod Digital Labs | Brand of Ahold
Delhaize USA
Industry:
Retailers
Size:
Large (1,000–9,999)
Country:
United States
Products and services:
​​​Microsoft Azure
Azure Cosmos DB
​Microsoft Azure Database for PostgreSQL
​Microsoft Azure Kubernetes Service
​Microsoft Azure Synapse Analytics​​
Read full story here

23. SQL Server 2022 in Azure VMs with Red Hat
Azure-enabled with continued performance and security innovation
Hero
capabilities
Business continuity
through Azure
Bidirectional DR
to Azure SQL
8
Seamless analytics over on-
prem operational data
Azure Synapse Link
Visibility over your entire
data estate
Microsoft
Purview
Data Insights
Data Catalog
Data Map
Microsoft Purview integration
Most secure over the
last 10 years
1
SQL Server ledger
Industry-leading
performanceand
availability
#1 OLTP performance
2
#1 Non-Clustered DW
performance on 1TB
3
, 3TB
4
,
10TB
5
, 30TB
6
, and 100TB
7
Built-in query intelligence
Multi-write replication
Azure SQL Edge
Most consistent data platform
Azure Arc-enabled data services
Edge to Cloud
Azure SQL
All TPC Claims as of 04/06/2022.
1
National Institute of Standards and Technology Comprehensive Vulnerability Database
2
http://www.tpc.org/4087;
3
http://www.tpc.org/3374;
4
http://www.tpc.org/3380;
5
https://tpc.org/3383;
6
http://www.tpc.org/3364;
7
https://tpc.org/3382;
8
Bidirectional disaster recovery capability of link feature for Azure SQL Managed Instance public preview will occur at a future date.
+
0
50
100
150
200
250
300
350
400
450
500
Vulnerabilities (2010
-
2020)

24. Reduce administrator support and maintenance time with Microsoft SQL Server 2022 on Red Hat Enterprise Linux
Deploy on physical, virtual or container platforms, on-premise, or across your favorite clouds
Red Hat platforms for Microsoft SQL Server
▸The world’s leading enterprise Linux platform
1
▸Provides a foundation from which you can scale apps
across bare-metal, virtual, container, and all types of
cloud environments
▸Certified on hundreds of clouds and with thousands of
vendors
▸The leading enterprise Kubernetes platform
2

▸Delivers a cloud experience anywhere
▸Full-stack automated operations, and
self-service provisioning help teams work together to
more efficiently move ideas from development to
production
▸Available as a fully managed cloud service or as self-
managed software
Source:
1 Worldwide Operating Systems and Subsystems Market Shares, 2018; released November 2019
2 The Forrester Wave: Multicloud Container Development Platforms, Q3 2020

25. Why migrate to Azure
Do more with Azure Open-source
Database services
•Reduce cost and database management
•Focus on Application development
•Ensure cloud scale and performance
•Take advantage of enterprise ready features
on SQL Server running in Azure VMs, Azure
Database for PostgreSQL and MySQL
Migrate with ease
•Seamless migration with support for latest
PostgreSQL, MySQL and SQL Server
editions
•Fast and secure migration with minimal
down time

26. Resources for migration
Get started migrating
Database Migration Guide
Azure Database Migration Service
Free Striim Licenses
Get help from Microsoft
Azure Migration and Modernization Program
Microsoft Azure
On-premises
workloads
Azure Database
Migration Service

27. Thank you.
© Copyright Microsoft Corporation. All rights reserved.
Thank you

28. Single server to Flexible server PostgreSQL
Migration tool
•Fully managed migration tool
•Complete the entire migration with a
single click of button
•Portal and CLI support
•Migrate across PG versions / regions /
compute tiers
•Supports both online and offline modes
•Single to Flexible migrations
•Single to Flexible server migration tool
can be used to migrate databases from
Single server to Flexible​ server
Coming soon
Windows Linux
Single Server Flexible Server
dump
CDC
S2F

29. Minimize downtime using Database Migration Service
1.Migrate initial load
2.New transactions continue to replicate to target
until data catches up
3.Stop new traffic coming in (downtime started)
4.Wait for last batch of data to catch up
5.Complete DB migration
6.Update connection string (back online)
DMS Continuous Sync