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
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
Available on Microsoft Azure Rich feature set Proven resilience & stability Open source Fully managed Highly scalable Security & Compliance Intelligent performance
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
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
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
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
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
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
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?
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?
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
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)
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)
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)
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)
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
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
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
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