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

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.

143117954187136b825331f24da0e201?s=128

Azure Postgres

September 22, 2020
Tweet

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 ధన#$ా&'ల) 谢谢