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
   

   View Slide

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

   View Slide

3. We’re
   Open
   We’re
   Cloudy
   We’re
   Magical
   

   View Slide

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

   View Slide

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

   View Slide

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

   View Slide

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
   

   View Slide

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
   

   View Slide

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
   

   View Slide

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
    

    View Slide

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
    

    View Slide

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

    View Slide

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

    View Slide

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
    

    View Slide

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
    

    View Slide

16. MYSQL DEMO:
    Simplified deployment of Flexible Server
    Andrea Lam
    

    View Slide

17. But what about
    data migration?
    

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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
    

    View Slide

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
    

    View Slide

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

    View Slide

24. When to use Single Server—vs. Flexible Server?
    

    View Slide

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)
    

    View Slide

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
    

    View Slide

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
    

    View Slide

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
    

    View Slide

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
    

    View Slide

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
    

    View Slide

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)
    

    View Slide

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)
    

    View Slide

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)
    

    View Slide

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

    View Slide

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

    View Slide

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
    

    View Slide

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
    

    View Slide

38. Q&A
    

    View Slide

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

    View Slide