jasonma msft [email protected] principal pm ... · • using community editions of mysql and...
TRANSCRIPT
![Page 1: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/1.jpg)
Microsoft ♥ MySQL & PostgreSQL!An Introduction to Azure OSS RDBMS Services
Jason AndersonPrincipal PM - [email protected] JasonMA_MSFT
![Page 2: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/2.jpg)
Microsoft&
Open Source Databases?
![Page 3: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/3.jpg)
Applications
Clients
Infrastructure
Management
Databases &Middleware
App Frameworks& Tools
DevOps
PaaS &DevOps
Azure is an open cloud
![Page 4: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/4.jpg)
MySQL Database on Azure China
• Launched in September 2015
• No partner-based MySQL PaaS solution in China
• Among top 10 utilized Azure services in China
• Based on different managed service architecture
• New service will replace the Azure China solution
We’re Not Exactly “New” to MySQL
![Page 5: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/5.jpg)
A few key things to know first…
• Using Community Editions of MySQL and PostgreSQL
• True PaaS offering; not a managed IaaS instance
• No new tools, connectivity libraries – use what you know
• Offerings differ only at the DB engine – at the service-level they are the same (mostly)
• In Public Preview – 50% pricing discount
![Page 6: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/6.jpg)
Azure Relational Database PlatformPo
wer
BI,
Ap
p S
ervi
ces,
Dat
a Fa
cto
ry,
Ana
lytic
s, M
L, C
ogn
itive
, Bo
t…
Global Azure with 38 Regions
Azure Compute
SQL Data Warehouse
Azure Storage
SQL Database MySQLPREVIEW PostgreSQLPREVIEW
Flexible: On-demand scaling, Resource governance
Trusted: HA/DR, Backup/Restore, Security, Audit, Isolation
Intelligent: Advisors, Tuning, MonitoringDatabase
Services
Platform
![Page 7: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/7.jpg)
Azure
Azure Database for MySQL
Conceptual Model
Subscription
Account
Resource Group
Server
Database
Logical, not bound to server instance
Connection endpoint for MySQL server
Can create one to many user databases
Highly available with automatic failover
Pinned to a region
Policy scope, e.g. firewall rules, recovery,
monitoring and management
![Page 8: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/8.jpg)
Control access
•Secure SSL connectivity
•Server firewall rules
Protect data
•Built-in encryption for application data and backups
Security built in
Identity
•Native authentication
![Page 9: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/9.jpg)
High Availability
Server provisioning and management
server=server.mysql.database.azure.com
Retry
Enables scale on the fly, server patching, with virtually no app down time
MySQL IP:3306PGSQL IP:5432
Application
MySQL orPostgreSQL
Client
Azure Database Management Service
Gateway
US West
Azure Storage
![Page 10: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/10.jpg)
Scale Up/Down on the Fly
Server provisioning and management
server=server.mysql.database.azure.com
Scale your server up or down without the need to manually configure a new server instance
MySQL IP:3306PGSQL IP:5432
Application
MySQL or PostgreSQL
Client
Azure Database Management Service
Gateway
US West
Standard 100
Standard 800
Azure Storage
![Page 11: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/11.jpg)
Backup & Restore
Built-in backup
No configuration needed
1x Backup storage included
PITR up to 35 days
![Page 12: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/12.jpg)
MySQL CLI built-in to Azure Cloud Shell
![Page 13: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/13.jpg)
Monitoring & Alerting
·Built-in monitoring
·Configurable alerts
·Notifications
·Run Logic Apps on alerts to take action (Scaling)
![Page 14: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/14.jpg)
Performance Tiers
![Page 15: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/15.jpg)
Storage Scale up to 1 TB
IOPS NA
Basic Tier – Personal blogs, small sites, Dev/Test
Service Tier Basic StandardBalanced IO and Compute
PremiumIO and Memory Optimized
Intended Use CaseFor workloads that scale with variable
IOPS
Compute Units 50, 100
Storage (included)50GB
Magnetic Media
IOPS (included) Variable
Additional Options
![Page 16: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/16.jpg)
Standard – Ideal for apps that need to scale
Service Tier Basic StandardBalanced IO and Compute
PremiumIO and Memory Optimized
Intended Use CaseFor workloads that scale with variable
IOPS
For workloads that require on-demand scaling optimized for high throughput
with provisioned IOPS
Compute Units 50, 100 100, 200, 400, 800, 1600
Storage (included)50GB
Magnetic Media125GB
Remote SSD
IOPS (included) Variable375
Scales 3:1 (IOPS:GB)
Scale up to 10 TB
Additional Options
Scale up to 10 TBStorage Scale up to 1 TB Scale up to 1 TB Scale up to 4 TB
IOPS NA Through increasing storage Scale up to 40K IOPS
![Page 17: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/17.jpg)
Premium – Apps that require very low latency
Service Tier Basic StandardBalanced IO and Compute
PremiumIO and Memory Optimized
Intended Use CaseFor workloads that scale with variable
IOPS
For workloads that require on-demand scaling optimized for high throughput
with guarenteed IOPS
For workloads that require on-demand scaling optimized for lowest latency
with provisioned IOPS
Compute Units 50, 100 100, 200, 400, 800, 1600 100, 200, 400, 800, 1600
Storage (included)50GB
Magnetic Media125GB
Remote SSD125GB
Local SSD
IOPS (included) Variable375
Scales 3:1 (IOPS:GB)Provisioned IOPS
Additional Options
99.99% SLA | fully managed | built-in HA | online performance scaling
Storage Scale up to 1 TB Scale up to 1 TB TBD
IOPS NA Through increasing storage Provisioned Directly
![Page 18: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/18.jpg)
AZURE DATABASE FOR MYSQL & POSTGRESQL REGION AVAILABILITY TODAY
West US, North Central US, East US, East US2, South Central US, West Europe, North Europe, Japan West, Japan East, East Asia, SE Asia, India West, India Central
More coming soon!
13Azure regions available today
![Page 19: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/19.jpg)
Getting Started – New Apps
![Page 20: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/20.jpg)
Azure Database for MySQL is tightly integrated with Azure Web Apps as a DB Provider
Deploy a new Web App + MySQL and add your own app
Pre-configured Web Apps –
Deploy through CLI using your own customized ARM deployment template
Integration with Azure Web Apps
+ +
![Page 21: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/21.jpg)
Migration
![Page 22: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/22.jpg)
1. There’s always mysqldump, Workbench, etc…
Getting your MySQL DB into Azure
2. Attunity Replicate for Microsoft Migrations• Source-Target replication for Microsoft customers• https://aka.ms/attunity-replicate
3. Data Sync through Read Replica• MySQL native replication• Supports masters outside of Azure; replica in Azure• Open for Private Preview – https://aka.ms/mysql_replication
![Page 23: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/23.jpg)
What Customers are sayingHow GeekWire is serving the latest tech news to 2 million readers worldwide“The biggest benefit of Azure Database for MySQL will be to have Microsoft manage and back up that resource for us so that we can focus on other aspects of the site. Plus, we will be able to scale up temporarily as traffic surges and then bring it back down when it is not needed. That’s a big deal for us.” -- Kevin Lisota, Web Developer, GeekWire
School district’s website handles avalanche of traffic during record snowfall“We don’t have to worry about what the web server is doing or if the log file is filling up. Azure Database for MySQL just abstracts everything to the PaaS layer, and we don’t have to manage the server itself. It makes life easier.” -- Matt Williams, Systems Administrator, School District 42
Top mobile app developer pictures worldwide expansion on an elastic cloud platform“Azure Database for MySQL simplifies development, it’s much easier to maintain, and it lowers costs too.” -- Jiawei Li: IT Architect, Fotable
![Page 24: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/24.jpg)
Call to Action – TRY IT!Read more about Azure Database for MySQL & PostgreSQL https://azure.microsoft.com/en-us/services/mysql/https://azure.microsoft.com/en-us/services/postgresql/
Sign-up for your Free Azure Trialhttps://azure.microsoft.com/en-us/free/
Take advantage of Preview Pricing – your $200 credit goes 100% further for a limited time!https://azure.microsoft.com/en-us/pricing/details/mysql/ https://azure.microsoft.com/en-us/pricing/details/postgresql/
Jump-in using the 5-min QuickStart Tutorials https://docs.microsoft.com/en-us/azure/mysql/ https://docs.microsoft.com/en-us/azure/postgresql/
![Page 25: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/25.jpg)
Purple
R:0
G:45 B
:145
Dark Purp
leR
:50 G
:20 B
:90
Dark B
lueR
:0 G
:32 B:8
0
Magenta
R:18
0 G
:0 B
:158D
ark Gray
R:8
0 G
:80
B:8
0
Blue
R:0
G:120
B:215
Main co
lors
Second
ary colo
rs (use only w
hen necessary)
Mid
Blue
R:0
G:24 B
:143G
reenR
:16 G:124 B
:16Light B
lueR
:0 G
:188
B:242Microsof
t
MySQLPostgreSQL
![Page 26: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/26.jpg)
Resources· Azure service page:· PostgreSQL: Azure Database for PostgreSQL· MySQL: Azure Database for MySQL
· Documentation:· PostgreSQL: Azure Database for PostgreSQL· MySQL: Azure Database for MySQL
· Discussion forum: · PostgreSQL: MSDN, StackOverflow· MySQL: MSDN, StackOverflow
· Feedback forum:· PostgreSQL User Voice· MySQL: User Voice
· GitHub repo: · https://github.com/Azure/azure-postgresql· https://github.com/Azure/azure-mysql
· Twitter: @AzureDBPostgres, @AzureDBMySQL
![Page 27: JasonMA MSFT janders@microsoft.com Principal PM ... · • Using Community Editions of MySQL and PostgreSQL ... West, Japan East, East Asia, SE Asia, India West, India Central More](https://reader033.vdocuments.us/reader033/viewer/2022060310/5f0a91787e708231d42c4594/html5/thumbnails/27.jpg)
© Copyright Microsoft Corporation. All rights reserved.