Slide 1

Slide 1 text

Modernize Your Data on Azure Database for Postgres And MySQL Flexible Server Parikshit Savjani, Principal PM Manager Azure Database for MySQL & MariaDB Sunil Agarwal, Principal PM Manager Azure Database for PostgreSQL @talktosavjani @S_u_n_e_e_l

Slide 2

Slide 2 text

Agenda Why Flexible Server? Flexible Server offering for PostgreSQL and MySQL Choosing the right deployment option

Slide 3

Slide 3 text

Deployment options for MySQL & Postgres Hyperscale (Citus) Ideal for multi-tenant applications and real-time analytical workloads that need sub-second response. Supports both transactional/operational workloads and hybrid transactional analytics workloads. Single Server Enterprise ready, fully managed community PostgreSQL server with up to 64 vCores, optional geospatial support, full-text search and more Flexible Server (preview) Maximum control with a simplified developer experience. Supports custom maintenance windows, zone redundant high availability, and simple cost optimization. Arc Enabled Hyperscale (Citus) Deployed on the infrastructure of your choice(on-premises/edge/multi-cloud), it is ideal for multi-tenant applications, transactional/operational workloads and real-time analytical workloads that need sub-second response.

Slide 4

Slide 4 text

Why Flexible Server? Some common questions – Why introduce Flexible Server? – Is Flexible Server @feature parity with Single Server? – How is the workload performance on Flexible Server – When will Flexible Server GA? – Is Flexible Server more expensive? – Why should I deploy my workload on Flexible Server – What is the difference between MySQL and PostgreSQL Flexible Server? – How will I migrate from Single Server to Flexible Server?

Slide 5

Slide 5 text

Single Server: Architecture and Value Proposition Notable Facts – GA’d 2018 – Significant growth YOY – Many Tier-1 workloads (e.g. HSBC, Adobe) – Intelligent Performance – Integration with Azure Infra (e.g. App Service, Kubernetes) – Key Engineering Investments since GA • Integration with AAD • Security: vNET,BYOK and Automatic Threat Protection (ATP) • Large storage 16 TB and 20k IOPS • Read Replicas • Logical Encoding (WAL2JSON) Region container container PG GP SSD gateway Built for Tradeoffs • High Availability • Elasticity • Security • Integration in ecosystem • Industry leading TCO • Performance (latency) • Familiarity

Slide 6

Slide 6 text

Single Server Challenge: Higher Latency Key Challenges – Connection Indirection through GW – No AZ (Availability Zones) locality Key Points Ø Limited control on resource placement Ø Once deployed, the placement can change due to SLO upgrade/downgrade, Failures Learnings Ø Eliminate GW Ø Provide AZ colocation

Slide 7

Slide 7 text

Single Server Challenge: Monthly Maintenance Window System Controlled • Multiple changes are batched together to minimize interruptions • Follows Azure Safe Deployment Policy (SDP) • Advanced Notification 72 hours. Customer can’t pause • Total span time 15 hours (5 pm to 8 am) but actual maintenance for a server (minutes) • For zero-day vulnerability, we reserve the right to initiate maintenance without 72 hours advance notification. Challenge: Customer has limited control to align maintenance to their workload patterns Planned Improvements • We are in the process of reducing maintenance window to 10 hours in public rings • Premium rings to selectively onboard customers with 4 hours maintenance window Learnings Ø Provide Customer Controlled Maintenance Window

Slide 8

Slide 8 text

Single Server Challenge: Connections Key Challenges – Connection requires @servername – Establishing a new connection expensive – Hard limit on max number of Connections per SKU Learnings Ø Remove @ Ø Reduce time to establish new connection Ø Decouple max connections from SKU Ø Integrate PGBouncer in Server Best Practice Recommendations • Use connection pooling – PGBouncer (Azure Kubernetes offers PGBouncer sidecar) • Connection retry logic should have back off logic

Slide 9

Slide 9 text

Single Server Challenge: AZ Resilient HA HA and current challenge – Resiliency with compute failure – Resiliency with storage failure – Failure of AZ can lead to downtime Azure Storage Server Secure container Secure container Secure container … X Server Secure container X Learnings Ø AZ resilient HA with Automatic failover with no data loss

Slide 10

Slide 10 text

DEMO: SINGLE SERVER

Slide 11

Slide 11 text

Flexible Server Customer Pain Points: Addressed ü Lower Latency – AZ colocation, no GW ü Performance – Good out-of-box performance. ü Customer controlled maintenance schedule ü Availability Zone resiliency ü Telemetry Accuracy/Richness: Example – IOPS ü Connections: Configure up to 5000 connections ü Developer Challenges ü Connection string does not require @server as part of username ü Simplified Provisioning workflow with good defaults ü Stop/Start the service when not in-use ü Competitive starter SKU (MySQL $12, PG $25) ü Scale up/down across all SKUs ü Integrated PGBouncer ü Guided E2E developer experience with AKS and App Service

Slide 12

Slide 12 text

Data Platform Virtual Summit 2020 is a community initiative by DataPlatformGeeks FLEXIBLE SERVER OFFERING FOR POSTGRESQL AND MYSQL

Slide 13

Slide 13 text

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

Slide 14

Slide 14 text

Out of Box Performance & Latency Note: 1 Test configuration: US East region, 4 vCore General Purpose servers Select 1 Test Read Only Test Read Write Test Latency (ms) Transactions Per Second (TPS) 2.76 ms 0.54 12k 59k Single Server Flexible Server 2.77 ms 0.86 12k 37k Single Server Flexible Server 26.13 ms 8.83 1.2k 3.6k Single Server Flexible Server 80% reduction 70% reduction 66% reduction +390% +220% +200 % Measures connection latency Indicative of perf for read-only workloads Indicative of perf for read + write workloads "It's two times as fast" "Nothing needs to be changed in our product side almost the same experience as RDS " “I did very simple benchmark, the latency was 4-5x better and tps 3-4x better” Early Adopter Feedback Flexible Server Flexible Server Flexible Server Single Server Single Server Single Server

Slide 15

Slide 15 text

Out of Box Performance & Latency Note: 1 Test configuration: US East region, 4 vCore General Purpose servers Select 1 Test Read Only Test Read Write Test Latency (ms) Transactions Per Second (TPS) 2.76 ms 0.54 12k 59k Single Server Flexible Server 2.77 ms 0.86 12k 37k Single Server Flexible Server 26.13 ms 8.83 1.2k 3.6k Single Server Flexible Server 80% reduction 70% reduction 66% reduction +390% +220% +200 % Measures connection latency Indicative of perf for read-only workloads Indicative of perf for read + write workloads Flexible Server Flexible Server Flexible Server Single Server Single Server Single Server

Slide 16

Slide 16 text

Early Adopter Feedback for Flexible Server "It's two times as fast" "Nothing needs to be changed in our product side almost the same experience as RDS " “I did very simple benchmark, the latency was 4-5x better and tps 3-4x better”

Slide 17

Slide 17 text

SIMPLIFIED DEVELOPER EXPERIENCE

Slide 18

Slide 18 text

Easy Create – Smart defaults

Slide 19

Slide 19 text

Easy CLI Experience Setup Environment (Once) 1. az account set --subscription “Your Azure subscription name” 2. az group create --name resource-group-name --location southeastasia 3. curl ifconfig.me (What is my IP address) Provision a new Flexible Server 4. az mysql flexible-server create --resource-group resource-group-name --name servername - -admin-username user --admin-password “password” --version 5.7 --sku-name Standard_B1ms --public-access OR az mysql flexible-server create –l

Slide 20

Slide 20 text

NATIVE CONNECTION EXPERIENCE (IT JUST WORKS !!!) mysql -h mydemoserver.mysql.database.azure.com -u myadmin –p password psql -h mydemoserver.postgres.database.azure.com -u mydemouser –p password

Slide 21

Slide 21 text

Simple Cost Optimization for development needs • Use low-cost Burstable SKU starting $13 per month for all development needs.

Slide 22

Slide 22 text

Simple Cost Optimization for development needs • Use low-cost Burstable SKU starting $13 per month for all development needs. • Stop the Server when not in use. Pay for storage only while the server is stopped

Slide 23

Slide 23 text

Demo DEMO: Simplified deployment of Flexible Server

Slide 24

Slide 24 text

MAXIMUM CONTROL FOR YOUR DATABASES

Slide 25

Slide 25 text

Control your planned maintenance • System defined schedule or Custom schedule for patching • Schedule your maintenance per server • 1-hour maintenance window • Downtime less than 60 seconds • Next planned maintenance schedule only after 30 days • 5 days advance notification

Slide 26

Slide 26 text

Network Isolation

Slide 27

Slide 27 text

More Server Parameter Control

Slide 28

Slide 28 text

ZONE RESILIENCY

Slide 29

Slide 29 text

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

Slide 30

Slide 30 text

Demo DEMO: Maximum Control and Zone Resiliency with Flexible Server

Slide 31

Slide 31 text

Flexible Server: Key Takeaway Build resilient apps across availability zones Maximum control for your databases Simplified developer experience

Slide 32

Slide 32 text

When to use Single Server—vs. Flexible Server?

Slide 33

Slide 33 text

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)

Slide 34

Slide 34 text

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

Slide 35

Slide 35 text

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

Slide 36

Slide 36 text

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

Slide 37

Slide 37 text

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

Slide 38

Slide 38 text

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

Slide 39

Slide 39 text

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)

Slide 40

Slide 40 text

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)

Slide 41

Slide 41 text

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)

Slide 42

Slide 42 text

Frequently asked questions • When will Flexible Server GA?

Slide 43

Slide 43 text

Frequently asked questions • When will Flexible Server GA? • Is Flexible Server available at same cost as Single Server?

Slide 44

Slide 44 text

Frequently asked questions • When will Flexible Server GA? • Is Flexible Server available at same cost as Single Server? • Is Flexible Server available in all Azure regions today

Slide 45

Slide 45 text

Frequently asked questions • When will Flexible Server GA? • Is Flexible Server available at same cost as Single Server? • Is Flexible Server available in all Azure regions today • How will I migrate from Single Server to Flexible Server?

Slide 46

Slide 46 text

Frequently asked questions • When will Flexible Server GA? • Is Flexible Server available at same cost as Single Server? • Is Flexible Server available in all Azure regions today • How will I migrate from Single Server to Flexible Server? • Where can I learn more information and news about Flexible Server?

Slide 47

Slide 47 text

aka.ms/postgres-flexible-server-docs MySQL Postgres aka.ms/mysql-flexible-server-docs What is Flexible Server for Postgres What is Flexible Server for MySQL aka.ms/postgres-cloud9 aka.ms/mysql-tenthline [email protected] [email protected]

Slide 48

Slide 48 text

OSS Database Sessions in DPS 2020 • Best Practices for Migrating your workloads to Azure Database for MySQL and PostgreSQL Arun Kumar Thiagarajan and Sunil Agarwal • Build Modern Cloud Native applications with Kubernetes and OSS Databases on Azure Sunitha Muthukrishna • Turbocharge your MySQL engine to make it fast, resilient and scalable Amol Bhatnagar • What is Azure Arc enabled PostgreSQL Hyperscale Jean-Yves Devant (JY)

Slide 49

Slide 49 text

Data Platform Virtual Summit 2020 is a community initiative by DataPlatformGeeks Sunil Agarwal @S_u_n_e_e_l @AzureDBPostgreSQL @talktosavjani @AzureDBMySQL Parikshit Savjani thank you merci grazie ध"यवाद ευχαριστώ gracias ధన#$ా&'ల) 谢谢

Slide 50

Slide 50 text

Any Questions?

Slide 51

Slide 51 text

No content