New innovations on Azure Database for MySQL & PostgreSQL to turbo charge app development Andrea Lam Lukas Fittl

Speakers Andrea Lam, Senior PM Azure Database for MySQL & MariaDB Lukas Fittl, Senior PM Azure Database for PostgreSQL @andreajlam @LukasFittl

We’re Open We’re Cloudy We’re Magical

Agenda What’s new with open source databases on Azure Building a resilient app with PostgreSQL Simplified deployment of MySQL Effective Migrations

Looking back Security § Azure AD authentication § Customer-managed key encryption § Infrastructure double encryption § Minimum TLS version requirements

Looking back Security § Azure AD authentication § Customer-managed key encryption § Infrastructure double encryption § Minimum TLS version requirements Performance § Read replicas § Intelligent Performance

Looking back Security § Azure AD authentication § Customer-managed key encryption § Infrastructure double encryption § Minimum TLS version requirements Performance § Read replicas § Intelligent Performance Manageability § RI for all GA services § Storage auto grow

Looking back Security § Azure AD authentication § Customer-managed key encryption § Infrastructure double encryption § Minimum TLS version requirements Performance § Read replicas § Intelligent Performance Manageability § RI for all GA services § Storage auto grow Trusted by companies of all sizes 50 regions

Hyperscale (Citus) Worry-free PostgreSQL in the cloud with an architecture built to scale out Existing deployment options for MySQL & Postgres Single Server Enterprise-ready, fully managed community OSS engines

Hyperscale (Citus) Worry-free PostgreSQL in the cloud with an architecture built to scale out Drumroll.... Single Server Enterprise-ready, fully managed community OSS engines

Hyperscale (Citus) Worry-free PostgreSQL in the cloud with an architecture built to scale out MySQL & Postgres deployment options being announced Single Server Enterprise-ready, fully managed community OSS engines Azure Arc enabled Postgres Hyperscale NEW Scale out PostgreSQL in environment of your choice Flexible Server (Preview) NEW Maximum control with a simplified developer experience

Introducing Flexible Server (Preview) for Build resilient apps across availability zones Maximum control for your databases Simplified developer experience

POSTGRES DEMO: Building a resilient app with Flexible Server Lukas Fittl

North Europe Region – East US West US 2 AZ1 AZ2 AZ3 Flexible Server Architecture Flexible Server Availability Zone 1 Availability Zone 2 Availability Zone 3 MySQL or PostgreSQL Linux VM Azure VM AKS App Service Premium Storage Data, Logs Backup Storage

Region – East US Zone Redundant HA Architecture in Flexible Server Backup storage Availability Zone 1 Flexible Server (Primary) MySQL or PostgreSQL Linux VM Premium Storage Data, Logs Azure VM AKS App Service v Availability Zone 2 Flexible Server (Standby) Linux VM Premium Storage Data, Logs Azure VM AKS App Service Backup Storage Synchronous Replication Backup Storage MySQL or PostgreSQL

MYSQL DEMO: Simplified deployment of Flexible Server Andrea Lam

But what about data migration?

Pre-migration Discover Assess Migrating to open source databases on Azure Migrate Schema

Migration Pre-migration Discover Assess Migrate Schema Dump & restore – offline Migrating to open source databases on Azure

Migration Pre-migration Discover Assess Migrate Schema Dump & restore – offline Native logical replication – online OR Migrating to open source databases on Azure

Migration Pre-migration Discover Assess Migrate Schema Dump & restore – offline Native logical replication – online Azure Database Migration Service – online OR OR Migrating to open source databases on Azure

Migration Pre-migration Discover Assess Migrate Schema Dump & restore – offline Native logical replication – online Azure Database Migration Service – online OR OR Post-migration Remediate applications Optimize Run functional & performance tests Migrating to open source databases on Azure

Introducing Burstable compute option for Lowest starting price 1-2 vCores Premium storage + VNet integration Use Burstable CPU credits for performance during peaks

When to use Single Server—vs. Flexible Server?

When to use Single Server vs. Flexible Server (Preview) Single Server Flexible Server (Preview) Database Version § MySQL 5.7, 8 § Postgres 9.5, 9.6, 10, 11 § MySQL 5.7 § MySQL 8.0 (planned) § Postgres 11, 12 § Postgres 13 (planned)

When to use Single Server vs. Flexible Server (Preview) Single Server Flexible Server (Preview) Database Version § MySQL 5.7, 8 § Postgres 9.5, 9.6, 10, 11 § MySQL 5.7 § MySQL 8.0 (planned) § Postgres 11, 12 § Postgres 13 (planned) High Availability Built-in HA (Single-AZ) Zone Redundant HA

When to use Single Server vs. Flexible Server (Preview) Single Server Flexible Server (Preview) Database Version § MySQL 5.7, 8 § Postgres 9.5, 9.6, 10, 11 § MySQL 5.7 § MySQL 8.0 (planned) § Postgres 11, 12 § Postgres 13 (planned) High Availability Built-in HA (Single-AZ) Zone Redundant HA Scheduled Maintenance System scheduled System or custom scheduled

When to use Single Server vs. Flexible Server (Preview) Single Server Flexible Server (Preview) Database Version § MySQL 5.7, 8 § Postgres 9.5, 9.6, 10, 11 § MySQL 5.7 § MySQL 8.0 (planned) § Postgres 11, 12 § Postgres 13 (planned) High Availability Built-in HA (Single-AZ) Zone Redundant HA Scheduled Maintenance System scheduled System or custom scheduled Stop/Start O P

When to use Single Server vs. Flexible Server (Preview) Single Server Flexible Server (Preview) Database Version § MySQL 5.7, 8 § Postgres 9.5, 9.6, 10, 11 § MySQL 5.7 § MySQL 8.0 (planned) § Postgres 11, 12 § Postgres 13 (planned) High Availability Built-in HA (Single-AZ) Zone Redundant HA Scheduled Maintenance System scheduled System or custom scheduled Stop/Start O P PITR P P

When to use Single Server vs. Flexible Server (Preview) Single Server Flexible Server (Preview) Database Version § MySQL 5.7, 8 § Postgres 9.5, 9.6, 10, 11 § MySQL 5.7 § MySQL 8.0 (planned) § Postgres 11, 12 § Postgres 13 (planned) High Availability Built-in HA (Single-AZ) Zone Redundant HA Scheduled Maintenance System scheduled System or custom scheduled Stop/Start O P PITR P P Network Isolation P Private Link P VNET Integration

When to use Single Server vs. Flexible Server (Preview) Single Server Flexible Server (Preview) Database Version § MySQL 5.7, 8 § Postgres 9.5, 9.6, 10, 11 § MySQL 5.7 § MySQL 8.0 (planned) § Postgres 11, 12 § Postgres 13 (planned) High Availability Built-in HA (Single-AZ) Zone Redundant HA Scheduled Maintenance System scheduled System or custom scheduled Stop/Start O P PITR P P Network Isolation P Private Link P VNET Integration Customer managed keys for Encryption P O (planned) Reserved Instances (RI) P O (planned) Cross region replicas P O (planned)

When to use Single Server vs. Flexible Server (Preview) Single Server Flexible Server (Preview) Database Version § MySQL 5.7, 8 § Postgres 9.5, 9.6, 10, 11 § MySQL 5.7 § MySQL 8.0 (planned) § Postgres 11, 12 § Postgres 13 (planned) High Availability Built-in HA (Single-AZ) Zone Redundant HA Scheduled Maintenance System scheduled System or custom scheduled Stop/Start O P PITR P P Network Isolation P Private Link P VNET Integration Customer managed keys for Encryption P O (planned) Reserved Instances (RI) P O (planned) Cross region replicas P O (planned) Uptime SLA 99.99% O (planned)

When to use Single Server vs. Flexible Server (Preview) Single Server Flexible Server (Preview) Database Version § MySQL 5.7, 8 § Postgres 9.5, 9.6, 10, 11 § MySQL 5.7 § MySQL 8.0 (planned) § Postgres 11, 12 § Postgres 13 (planned) High Availability Built-in HA (Single-AZ) Zone Redundant HA Scheduled Maintenance System scheduled System or custom scheduled Stop/Start O P PITR P P Network Isolation P Private Link P VNET Integration Customer managed keys for Encryption P O (planned) Reserved Instances (RI) P O (planned) Cross region replicas P O (planned) Uptime SLA 99.99% O (planned)

aka.ms/postgres-flexible-server-docs MySQL aka.ms/mysql-flexible-server-docs

aka.ms/postgres-flexible-server-docs MySQL aka.ms/mysql-flexible-server-docs aka.ms/postgres-flexible-blog aka.ms/mysql-flexible-blog

aka.ms/postgres-flexible-server-docs aka.ms/postgres-flexible-blog MySQL aka.ms/postgres-cloud9 aka.ms/mysql-flexible-server-docs aka.ms/mysql-flexible-blog aka.ms/mysql-tenthline

aka.ms/postgres-flexible-server-docs [email protected] [email protected] MySQL aka.ms/postgres-cloud9 aka.ms/mysql-flexible-server-docs aka.ms/postgres-flexible-blog aka.ms/mysql-flexible-blog aka.ms/mysql-tenthline

Q&A

© Copyright Microsoft Corporation. All rights reserved. Andrea Lam @andreajlam @AzureDBMySQL @LukasFittl @AzureDBPostgres @citusdata Lukas Fittl thank you merci grazie danke ध"यवाद ευχαριστώ gracias ధన#$ా&'ల) 谢谢