What developers are doing with Postgres & MySQL on Azure | Build 2020 | Samay Sharma, Andrea Lam

What developers are doing with Postgres & MySQL on Azure | Build 2020 | Samay Sharma, Andrea Lam

Join us to learn how developers like you are architecting applications on Postgres & MySQL open source databases on Azure—for use cases like e-commerce, web content, time series data, real-time analytics, & multi-tenant SaaS

143117954187136b825331f24da0e201?s=128

Azure Postgres

May 19, 2020
Tweet

Transcript

  1. 2.
  2. 3.

    Agenda Why open source databases on Azure? Common patterns for

    Postgres What devs are doing with MySQL on Azure Seamless cloud migrations Open Source
  3. 4.

    1K 800 600 400 200 100 Score (logarithmic scale 2013

    2014 2015 2016 2017 2018 2019 2020 Growing In Popularity https://db-engines.com/en/ranking_trend PostgreSQL MySQL
  4. 5.

    PostgreSQL & MariaDB are fastest growing relational database management systems

    MySQL named 2019 “Database of the year” by DB-Engines.com PostgreSQL named 2017 and 2018 “Database of the year” by DB-Engines.com Postgres one of most loved & wanted databases in Stack Overflow Developer Survey 2019 80% Growing In Popularity
  5. 7.

    Rich feature set Proven resilience & stability Open source Fully

    managed Highly scalable Security & Compliance Intelligent performance
  6. 8.

    Rich feature set Proven resilience & stability Open source Fully

    managed Highly scalable Security & Compliance Intelligent performance
  7. 9.

    Available on Microsoft Azure Rich feature set Proven resilience &

    stability Open source Fully managed Highly scalable Security & Compliance Intelligent performance
  8. 12.

    Modernize data estate by migrating Oracle > Postgres Rich PostgreSQL

    features & data types including geospatial Fast and low risk PL/SQL to PL/PgSQL migration Minimal downtime via Ora2PG & Azure Database Migration Reduce TCO by over 90% & avoid vendor lock-in Fully-managed database service
  9. 13.

    Modernize data estate by migrating Oracle > Postgres Rich PostgreSQL

    features & data types including geospatial Fast and low risk PL/SQL to PL/PgSQL migration Minimal downtime via Ora2PG & Azure Database Migration Reduce TCO by over 90% & avoid vendor lock-in Fully-managed database service
  10. 14.

    Modernize data estate by migrating Oracle > Postgres Fast and

    low risk PL/SQL to PL/PgSQL migration Minimal downtime via Ora2PG & Azure Database Migration Reduce TCO by over 90% & avoid vendor lock-in Fully-managed database service Rich PostgreSQL features & data types including geospatial
  11. 15.

    Modernize data estate by migrating Oracle > Postgres Rich PostgreSQL

    features & data types including geospatial Minimal downtime via Ora2PG & Azure Database Migration Reduce TCO by over 90% & avoid vendor lock-in Fully-managed database service Fast and low risk PL/SQL to PL/PgSQL migration
  12. 16.

    Modernize data estate by migrating Oracle > Postgres Rich PostgreSQL

    features & data types including geospatial Fast and low risk PL/SQL to PL/PgSQL migration Reduce TCO by over 90% & avoid vendor lock-in Fully-managed database service Minimal downtime via Ora2PG & Azure Database Migration
  13. 17.

    Migrating from Oracle to Postgres | The Process Post-migration Migration

    Migrate schema, data, & objects Data sync Cutover Pre-migration Discover Assess Connect Remediate applications Optimize Run functional & performance tests
  14. 23.

    Real-time ingest & complex analytics in same database Data types,

    operators, functions Why build real-time analytics on Postgres?
  15. 24.

    Real-time ingest & complex analytics in same database Data types,

    operators, functions Extensions: pg_partman, pg_cron, HLL, topn Why build real-time analytics on Postgres?
  16. 25.

    Real-time ingest & complex analytics in same database Data types,

    operators, functions Extensions: pg_partman, pg_cron, HLL, topn Pre-aggregations & rollups Why build real-time analytics on Postgres?
  17. 26.

    Real-time ingest & complex analytics in same database Data types,

    operators, functions Extensions: pg_partman, pg_cron, HLL, topn Pre-aggregations & rollups Connectivity with rest of data pipeline Why build real-time analytics on Postgres?
  18. 27.

    Real-time ingest & complex analytics in same database Data types,

    operators, functions Extensions: pg_partman, pg_cron, HLL, topn Pre-aggregations & rollups Connectivity with rest of data pipeline Scale to hundreds of TBs with Hyperscale (Citus) Why build real-time analytics on Postgres?
  19. 28.

    Real-time analytics architectures with Hyperscale (Citus) Notification Hubs Devices Raw

    Events Azure Databricks Scheduled process Browser Aggregations App Service/AKS 4 Hyperscale (Citus) in Azure Database for PostgreSQL 4 3 5 2 6 1 Event Hubs
  20. 29.

    4 4 5 1 6 3 2 Notification Hubs Devices

    Raw Events Azure Databricks Scheduled process Browser Aggregations Hyperscale (Citus) in Azure Database for PostgreSQL Event Hubs App Service/AKS Real-time analytics architectures with Hyperscale (Citus)
  21. 30.

    3 5 2 1 6 4 4 Notification Hubs Devices

    Raw Events Azure Databricks Scheduled process Browser Aggregations Hyperscale (Citus) in Azure Database for PostgreSQL Event Hubs App Service/AKS Real-time analytics architectures with Hyperscale (Citus)
  22. 31.

    4 4 3 2 1 5 6 Notification Hubs Devices

    Raw Events Azure Databricks Scheduled process Browser Aggregations Hyperscale (Citus) in Azure Database for PostgreSQL Event Hubs App Service/AKS Real-time analytics architectures with Hyperscale (Citus)
  23. 32.

    4 4 3 5 2 1 6 Notification Hubs Devices

    Raw Events Azure Databricks Scheduled process Browser Aggregations Hyperscale (Citus) in Azure Database for PostgreSQL Event Hubs App Service/AKS Real-time analytics architectures with Hyperscale (Citus)
  24. 33.

    4 4 3 5 2 1 6 Notification Hubs Devices

    Raw Events Azure Databricks Scheduled process Browser Aggregations Hyperscale (Citus) in Azure Database for PostgreSQL Event Hubs App Service/AKS Real-time analytics architectures with Hyperscale (Citus)
  25. 35.

    Build ecommerce apps that delight customers with Magento & MySQL

    An open source e-commerce solution developed in PHP
  26. 36.

    AKS Kubernetes Cluster NGINX 1.15.5 Ingress Cache service (2 pod

    instances) Varnish Pod Varnish Pod Web (Magento) service WEB Pod App (Magento) service APP Pod Redis-cache service (1 pod instance) Redis-session service (1 pod instance) Redis Cache (1) Redis Cache (1) Magento uses Azure Database for MySQL to store inventory catalog, order, and customer information
  27. 37.

    Built-in HA for 99.99% SLA fault tolerant performance Transactions in

    500 milliseconds with 20K IOPS and 16 TB of storage Read-replicas to scale out read- only workloads for analytical platforms AKS Kubernetes Cluster NGINX 1.15.5 Ingress Cache service (2 pod instances) Varnish Pod Varnish Pod Web (Magento) service WEB Pod App (Magento) service APP Pod Redis-cache service (1 pod instance) Redis-session service (1 pod instance) Redis Cache (1) Redis Cache (1) Azure Database for MySQL gives Magento (and ecommerce customers)
  28. 38.

    Built-in HA for 99.99% SLA fault tolerant performance Transactions in

    500 milliseconds with 20K IOPS and 16 TB of storage Read-replicas to scale out read- only workloads for analytical platforms AKS Kubernetes Cluster NGINX 1.15.5 Ingress Cache service (2 pod instances) Varnish Pod Varnish Pod Web (Magento) service WEB Pod App (Magento) service APP Pod Redis-cache service (1 pod instance) Redis-session service (1 pod instance) Redis Cache (1) Redis Cache (1) Azure Database for MySQL gives Magento (and ecommerce customers)
  29. 39.

    Built-in HA for 99.99% SLA fault tolerant performance Transactions in

    500 milliseconds with 20K IOPS and 16 TB of storage Read-replicas to scale out read- only workloads for analytical platforms AKS Kubernetes Cluster NGINX 1.15.5 Ingress Cache service (2 pod instances) Varnish Pod Varnish Pod Web (Magento) service WEB Pod App (Magento) service APP Pod Redis-cache service (1 pod instance) Redis-session service (1 pod instance) Redis Cache (1) Redis Cache (1) Azure Database for MySQL gives Magento (and ecommerce customers)
  30. 40.

    Built-in HA for 99.99% SLA fault tolerant performance Transactions in

    500 milliseconds with 20K IOPS and 16 TB of storage Read-replicas to scale out read- only workloads for analytical platforms AKS Kubernetes Cluster NGINX 1.15.5 Ingress Cache service (2 pod instances) Varnish Pod Varnish Pod Web (Magento) service WEB Pod App (Magento) service APP Pod Redis-cache service (1 pod instance) Redis-session service (1 pod instance) Redis Cache (1) Redis Cache (1) Azure Database for MySQL gives Magento (and ecommerce customers)
  31. 43.

    Deliver online educational programs with Moodle Allows educators to manage

    quizzes, assignments, and communicate with students Moodle: open source learning management solution developed in PHP
  32. 45.

    Azure Admin (SSH) IP VNet Gluster FS Controller VM (w/

    opt. NFS vol.) Elastic VMS Azure Database for MySQL Moodle deployment architecture on Azure
  33. 46.

    Azure Admin (SSH) IP Autoscaling VMSS web frontend VNet Gluster

    FS Controller VM (w/ opt. NFS vol.) Elastic VMS Azure Database for MySQL Moodle deployment architecture on Azure
  34. 47.

    Azure Admin (SSH) IP Autoscaling VMSS web frontend VNet Gluster

    FS Controller VM (w/ opt. NFS vol.) Elastic VMS Azure Database for MySQL Moodle deployment architecture on Azure
  35. 49.

    Moodle uses Azure Database for MySQL to store student scores,

    grades, & student info Automated patching & backups Integrated with native MySQL tools Concurrent user access Moodle deployment architecture on Azure Azure VNet
  36. 55.

    Postgres Quickstart Docs: https://aka.ms/azure-postgres-quickstart https://aka.ms/azure-mysql-quickstart Azure Postgres Blog: https://aka.ms/azure-postgres-blog https://aka.ms/azure-mysql-blog

    @AzureDBMySQL citusdata/citus @AzureDBPostgres AskAzureDBforMySQL@service.microsoft.com AskAzureDBforPostgreSQL@service.microsoft.com Postgres Resources
  37. 56.

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

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