New innovations on Azure Database for MySQL & Postgres to turbo charge app development | Microsoft Ignite 2020 | Andrea Lam & Lukas Fittl

Flexible Server is a new deployment option for Azure Database for PostgreSQL and MySQL, our relational open source database services. This new deployment option gives you more control of your database configuration, maintenance, and tuning—enabling you to better optimize your workloads. Flexible Server for Postgres and MySQL also gives you zone redundant high availability plus the ability to Stop/Start your database to optimize costs.

Transcript

1. New innovations on Azure Database for MySQL & PostgreSQL to turbo charge app development Andrea Lam Lukas Fittl
2. Speakers Andrea Lam, Senior PM Azure Database for MySQL & MariaDB Lukas Fittl, Senior PM Azure Database for PostgreSQL @andreajlam @LukasFittl
3. We’re Open We’re Cloudy We’re Magical
4. Agenda What’s new with open source databases on Azure Building a resilient app with PostgreSQL Simplified deployment of MySQL Effective Migrations
5. Looking back Security § Azure AD authentication § Customer-managed key encryption § Infrastructure double encryption § Minimum TLS version requirements
6. Looking back Security § Azure AD authentication § Customer-managed key encryption § Infrastructure double encryption § Minimum TLS version requirements Performance § Read replicas § Intelligent Performance
7. 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
8. 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
9. 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
10. 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
11. 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
12. Introducing Flexible Server (Preview) for Build resilient apps across availability zones Maximum control for your databases Simplified developer experience
13. POSTGRES DEMO: Building a resilient app with Flexible Server Lukas Fittl
14. 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
15. 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
16. MYSQL DEMO: Simplified deployment of Flexible Server Andrea Lam
17. But what about data migration?
18. Pre-migration Discover Assess Migrating to open source databases on Azure Migrate Schema
19. Migration Pre-migration Discover Assess Migrate Schema Dump & restore – offline Migrating to open source databases on Azure
20. Migration Pre-migration Discover Assess Migrate Schema Dump & restore – offline Native logical replication – online OR Migrating to open source databases on Azure
21. 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
22. 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
23. Introducing Burstable compute option for Lowest starting price 1-2 vCores Premium storage + VNet integration Use Burstable CPU credits for performance during peaks
24. When to use Single Server—vs. Flexible Server?
25. 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)
26. 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
27. 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
28. 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
29. 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
30. 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
31. 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)
32. 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)
33. 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)
34. aka.ms/postgres-flexible-server-docs MySQL aka.ms/mysql-flexible-server-docs
35. aka.ms/postgres-flexible-server-docs MySQL aka.ms/mysql-flexible-server-docs aka.ms/postgres-flexible-blog aka.ms/mysql-flexible-blog
36. 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
37. aka.ms/postgres-flexible-server-docs AskAzureDBforMySQL@service.microsoft.com AskAzureDBforPostgreSQL@service.microsoft.com 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
38. Q&A
39. © Copyright Microsoft Corporation. All rights reserved. Andrea Lam @andreajlam @AzureDBMySQL @LukasFittl @AzureDBPostgres @citusdata Lukas Fittl thank you merci grazie danke ध"यवाद ευχαριστώ gracias ధన#$ా&'ల) 谢谢