Slide 1

Slide 1 text

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

Slide 2

Slide 2 text

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”

Slide 3

Slide 3 text

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

Slide 4

Slide 4 text

Key opportunities driving OSS Growth

Slide 5

Slide 5 text

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

Slide 6

Slide 6 text

Ignite Announcements

Slide 7

Slide 7 text

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

Slide 8

Slide 8 text

… 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

Slide 9

Slide 9 text

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

Slide 10

Slide 10 text

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

Slide 11

Slide 11 text

DEMO

Slide 12

Slide 12 text

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*

Slide 13

Slide 13 text

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

Slide 14

Slide 14 text

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

Slide 15

Slide 15 text

Beyond standalone databases

Slide 16

Slide 16 text

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

Slide 17

Slide 17 text

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

Slide 18

Slide 18 text

Demo

Slide 19

Slide 19 text

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

Slide 20

Slide 20 text

DEMO

Slide 21

Slide 21 text

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

Slide 22

Slide 22 text

So What’s next?

Slide 23

Slide 23 text

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

Slide 24

Slide 24 text

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

Slide 25

Slide 25 text

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: [email protected] [email protected] [email protected]

Slide 26

Slide 26 text

Questions