Innovations to boost productivity with Azure-managed MySQL, PostgreSQL, and MariaDB databases

OPEN SOURCE IS THE FUTURE > 60% By 2022, more than 70% of new in- house applications will be developed on an OSDBMS or OSDBMS-based dbPaaS2 DBaaS (Relational) is the top public cloud service used3 90% > 40% Through 2020, relational technology will continue to be used for at least 85% of new applications and projects1 State of the relational and open source databases 1. Gartner: “State of the Open-Source DBMS Market, 2018” 2. Gartner: “State of the Open-Source DBMS Market, 2019” 3. Source: “RightScale 2019 State of the Cloud Report from Flexara”

MariaDB is a community-developed fork of MySQL with strong focus on the user community MySQL is a leading open source relational database for LAMP stack apps PostgreSQL is the most loved and wanted database for modern apps 54% 3x DBMS of the Year #1 Relational database choices on Azure

Key opportunities driving OSS Growth

Relational Database Services Platform Azure storage Azure compute Azure Database for PostgreSQL Azure Database for MySQL Azure Database for MariaDB Global Azure in 54 regions Elastic On-demand scaling, resource governance Trusted Built in HA Database Services Platform Security/Compliance Advanced Threat Protection Intelligent Recommendations, tuning, monitoring Integration Azure functionality integration Hyperscale Cloud native scale out

Ignite Announcements

Delivering innovations to boost your productivity Managing resource uptime Enterprise Security Performance Optimization Improve developer agility Use Azure Anywhere

… Azure Storage MySQL or PostgreSQL Server Secure container X MySQL or PostgreSQL Server Secure container X PostgreSQL: 5432 MySQL: 3306 MySQL Client Azure 3 copies of data for data reliability Compute redundancy Built-in HA helps achieve 99.99% SLA

Elasticity Built-in elasticity for quick scaling Benefits • Scale compute up or down in seconds • Scale storage instantaneously PostgreSQL: 5432 MySQL: 3306 Azure Storage MySQL or PostgreSQL Server MySQL or PostgreSQL Server Secure container Secure container MySQL Client Azure

Improve performance and decrease cost with comprehensive database monitoring, Query insights, recommendations, and automatic tuning Query Store : Automatically track and log query performance over time Heading Query Performance Insights : Visualize query performance data to identify how your longest running queries change over time Heading Performance recommendations : Azure analyzes the workloads across your server to generate customized performance recommendations Heading Intelligent insights to optimize workloads

DEMO

Protect data with layers of security Ø Azure provides multiple layers of security to safeguard your data both at rest and in motion unblocks customers across different industries Built-in encryption for data at rest and in motion Secure SSL connectivity Server firewall rules Virtual Network (SE) Native authentication Azure Active Directory *NOW* Private Link *Dec* Bring Your Own Key *Dec*

Source: Verizon 2017 & 2018 Data Breach Investigations Report ?******? The modern security challenge • No organization is immune • More frequent attacks • More sophisticated techniques • 76% of breaches were financially motivated • 28% involved internal actors, while 72% perpetrated by outsiders

Defend malicious action with Advanced Threat Protection Azure portal Developer Azure Security Center (ASC) Advanced threat protection Just turn it on Actionable alerts

Beyond standalone databases

Hyperscale (Citus) | Azure Database for PostgreSQL (GA ) Optimized for multi-tenant, SaaS applications and real-time operational analytics.

Any hardware OEM hardware AKS Any Kubernetes GKE EKS Kubernetes OPENSHIFT … Azure data service Cloud native scale on-premise – Azure Arc

Demo

Innovate faster through integration with Azure services Power BI Azure App Services Azure Data Factory Azure Analysis Services Azure Machine Learning Azure Cognitive Services Azure Bot Service Azure Kubernete s Service

DEMO

Building a real time IOT application on Azure Edge IoT devices IoT Hub Storage Blob Azure Data Factory Azure PostgreSQL w/TimescaleDB Power BI High Speed ingestion

So What’s next?

Azure Compute / Azure storage Global Azure in 54 regions • Compute optimizations • Low latency IO Ø Compute optimizations Ø Low latency IO Ø Manageability Ø Governance Ø Cost/resource opt. Ø Compliance Database Platform Ø Enterprise security Ø Flexible deployment options Ø Multi-AZ Ø Customer managed maintenance window Ø Autonomous DB (automatic self tuning) Ø Fast High Availability Community Core PostgreSQL Hyperscale MySQL Hyperscale Ø Support larger node sizes (storage) Ø Expansion of use case Ø PL/pgSQL push-downs Ø Write scale out (MX) Ø Storage scale out Ø Instant read replica scale-out Ø Low latency Azure Platform A Z U R E A R C Azure Integrations

Learn more… Session ID Session Topic THR2124 Running Postgres at scale on-premises and in the cloud BRK2064 Why developers love Postgres THR2120 Deploy an app in Azure Kubernetes and App Services with MySQL THR2123 Why enterprises are moving from Oracle to Azure Postgres BRK3019 Migrate or build internet-scale applications using MySQL

Documentation and resources Resources / URL Infopedia Landing page http://aka.ms/ossdb MySQL homepage MariaDB homepage PostgreSQL homepage http://aka.ms/mysql http://aka.ms/mariadb http://aka.ms/postgresql MySQL documentation MariaDB documentation PostgreSQL documentation http://aka.ms/mysqldocs http://aka.ms/mariadbdocs http://aka.ms/postgresqldocs Participate in the Early https://aka.ms/hybrid-data-services Ask Questions: AskAzureDBforMySQL@service.microsoft.com AskAzureDBforMariaDB@service.microsoft.com AskAzureDBforPostgreSQL@service.microsoft.com

Questions