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

Transcript

1. What developers are doing with Postgres & MySQL on Azure Andrea Lam Samay Sharma
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
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
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
6. Rich feature set Proven resilience & stability Open source
7. Rich feature set Proven resilience & stability Open source Fully managed Highly scalable Security & Compliance Intelligent performance
8. Rich feature set Proven resilience & stability Open source Fully managed Highly scalable Security & Compliance Intelligent performance
9. Available on Microsoft Azure Rich feature set Proven resilience & stability Open source Fully managed Highly scalable Security & Compliance Intelligent performance
10. Oracle to Postgres 1
11. Oracle to Postgres, a common pattern we are seeing more & more of
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
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
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
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
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
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
18. Operational Real-time Analytics 2
19. Scalable real-time analytics with Hyperscale (Citus) on Azure Database for PostgreSQL
20. aka.ms/citus
21. Why build real-time analytics on Postgres?
22. Real-time ingest & complex analytics in same database Why build real-time analytics on Postgres?
23. Real-time ingest & complex analytics in same database Data types, operators, functions Why build real-time analytics on Postgres?
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?
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?
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?
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?
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
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)
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)
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)
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)
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)
34. Magento ecommerce on MySQL 3
35. Build ecommerce apps that delight customers with Magento & MySQL An open source e-commerce solution developed in PHP
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
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)
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)
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)
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)
41. aka.ms/azure-magento
42. Moodle online learning on MySQL 4
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
44. And yes, Moodle—like MySQL—is open source
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
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
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
48. Azure VNet Moodle deployment architecture on Azure
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
50. aka.ms/azure-moodle
51. Migrating data to Azure 5
52. aka.ms/azure-mysql-migrate aka.ms/azure-postgres-migrate Seamless data migrations to the cloud
53. Postgres Quickstart Docs: https://aka.ms/azure-postgres-quickstart https://aka.ms/azure-mysql-quickstart Postgres Resources
54. 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 Postgres Resources
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
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 ధన#$ా&'ల) 谢谢
57. Any Questions?
58. © Copyright Microsoft Corporation. All rights reserved.