Upgrade to Pro — share decks privately, control downloads, hide ads and more …

New innovations on Azure Database for MySQL & P...

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.

Azure Database for PostgreSQL

September 22, 2020
Tweet

More Decks by Azure Database for PostgreSQL

Other Decks in Technology

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. Agenda What’s new with open source databases on Azure Building

    a resilient app with PostgreSQL Simplified deployment of MySQL Effective Migrations
  4. Looking back Security § Azure AD authentication § Customer-managed key

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

    encryption § Infrastructure double encryption § Minimum TLS version requirements Performance § Read replicas § Intelligent Performance
  6. 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
  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 Trusted by companies of all sizes 50 regions
  8. 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
  9. 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
  10. 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
  11. Introducing Flexible Server (Preview) for Build resilient apps across availability

    zones Maximum control for your databases Simplified developer experience
  12. 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
  13. 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
  14. Migration Pre-migration Discover Assess Migrate Schema Dump & restore –

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

    offline Native logical replication – online OR Migrating to open source databases on Azure
  16. 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
  17. 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
  18. Introducing Burstable compute option for Lowest starting price 1-2 vCores

    Premium storage + VNet integration Use Burstable CPU credits for performance during peaks
  19. 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)
  20. 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
  21. 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
  22. 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
  23. 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
  24. 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
  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) 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)
  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 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)
  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 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)
  28. Q&A

  29. © Copyright Microsoft Corporation. All rights reserved. Andrea Lam @andreajlam

    @AzureDBMySQL @LukasFittl @AzureDBPostgres @citusdata Lukas Fittl thank you merci grazie danke ध"यवाद ευχαριστώ gracias ధన#$ా&'ల) 谢谢