OSS DB on Azure - microsoftazuresummit.com

1 OSS DB on Azure The growing global data platform market Global Data Platform Market is growing at CAGR Growth is expected to exceed $100B in FY22 Primary growth is driven by relational workloads (on-premise & cloud) Sustained double-digit growth is expected through adoption of newer architectures and data models (Hadoop, NoSQL) along with more investment in predictive analytics, ML, and AI- like capabilities FY17 FY18 FY19 FY20 FY21 FY22. Traditional, Relational Data Distributed Architectures / Data Models Advanced, Predictive Analytics Other Source: IDC + Internal Assessments Savings opportunity for modernizing your data estate is significant Platform (as a Service).

2 Infrastructure Intelligent On-premise costs tends to be driven by On-premises (as a Service) performance/security hardware and data center management costs Applications Applications Applications Infrastructure-as-a-Service reduces cost Data Data Data categories related to data center and compute High availability High availability High Availability/. Platform-as-a-Service off-loads customers' /DR/Backups /DR/Backups DR/Backups most administrative tasks to Azure , further Database Provision/ Database Provision/ Database Provision/. improving efficiency with machine-learning Patch/Scaling Patch/Scaling Patch/Scaling capabilities for performance and security O/S provision /patching O/S O/S.

3 The ML capabilities are key technology Virtualization Virtualization Virtualization differentiation of Azure vs AWS RDS. Hardware Hardware Hardware Azure provides SLA with built-in HA, significantly reduce financial burden on Datacenter Management Datacenter Management Datacenter Management customers compared to RDS. Open Source on-prem Open Source VMs Azure Database for deployment MySQL/PostgreSQL/MariaDB. Managed by customer Managed by Microsoft Machine-learning capability Open source database engines popularity 80% of companies invest in public cloud technologies1. By 2020, 74% of cloud workloads will be software-as-a-service (SaaS) workloads, up from 65 percent in 20151.

4 By 2018, more than 70% of new in-house apps will be developed on OSS databases2. PostgreSQL and MariaDB are the fastest growing relational database management systems3. PostgreSQL named 2017 Database of the year . by 1 CiscoGlobal Cloud Index: Forecast and Methodology, editions 2013-2018 & 2015-2020. 2 The State of Open Source RDBMSs, 2015, Gartner (Donald Feinberg and Merv Adrian). 3DB-Engines. DB-Engines Ranking . solid IT Gmbh, 2017. 4DB-Engines. Kerschberg, Ben. How Postgres and Open Source are Disrupting the Market for Database Management Systems . Forbes. 8 Mar 2016. Highlights of open source databases Free Community focused Straight forward deployment into Large number of updates and production compared to releases from PostgreSQL.

5 Runs on Linux commercial DBs that restrict free and everywhere developer version for production Less DBA needs, ease of use PostgreSQL runs on Linux, macOS, favored by developers Solaris, Windows, and more Wide community support with MySQL and MariaDB run on Linux developers adding and asking things of community Azure Database for MySQL, PostgreSQL, & MariaDB. Cloud scale Performance Security HA/DR. Get thescale Elastic full benefits in of #1 Benchmark-setting Query Store and Most secure Auditing, datavs. not-yet- Best-in-class Built-in HA and DR. High Availability the cloud and unlock seconds performance vs.

6 Great intelligent insights tops in the world classification, and of threat vs. just-enough and Disaster Recovery developer productivity performance for its security detection attacks purpose Solves for engine gaps with platform benefits DBaaS: common service fabric enabling best customer experience and value Azure SQL Data Azure SQL Azure Database Azure Database Azure Database Warehouse Database for PostgreSQL for MySQL for MariaDB. Database Services Platform Intelligent Flexible Trusted Advisors, tuning, On-demand scaling, HA/DR, backup/restore, monitoring resource governance security, audit, isolation Azure compute Azure storage Global Reach, Local Proximity More certifications than any other cloud provider GLOBAL.

7 CSA STAR CSA STAR CSA STAR. ISO 27001 ISO 27018 ISO 27017 ISO 22301 SOC 1 Type 2 SOC 2 Type 2 SOC 3. Self-Assessment Certification Attestation US GOV. Moderate High DoD DISA DoD DISA DoD DISA Section 508. SP 800-171 FIPS 140-2 ITAR CJIS IRS 1075. JAB P-ATO JAB P-ATO SRG Level 2 SRG Level 4 SRG Level 5 VPAT. INDUSTRY. PCI DSS Shared HIPAA / HITE GxP. CDSA MPAA FACT UK FISC Japan HITRUST MARS-E IG Toolkit UK FERPA GLBA FFIEC. Level 1 Assessments CH Act 21 CFR Part 11. REGIONAL. Argentina EU UK China China China Singapore Australia New Zealand Japan My ENISA Japan CS M Spain Spain India Canada Privacy Germany IT.

8 PDPA Model Clauses G-Cloud DJCP GB 18030 TRUCS MTCS IRAP/CCSL GCIO Number Act IAF ark Gold ENS DPA MeitY Privacy Laws Shield Grundschutz workbook My Azure Database for MySQL, PostgreSQL & MariaDB. Enterprise-ready performance, high availability and security on top of cloud scaling and integration Cloud HA & Scaling Save time and money with built-in High Availability (HA) and elastic scaling Enterprise-grade performance and security from Intelligent Insights and PaaS ++. Advanced Threat Protection (ATP). Productive development seamless use of App services and one-click connections Azure Integration to Azure ecosystem Truly Global Reach 2x global reach vs.

9 AWS RDS for OSS. My High Availability built-in: save effort and money Azure Database for MySQL/PostgreSQL AWS RDS for MySQL/PostgreSQL. Built-in HA: offers HA on a single node HA from Multi-AZ. Cloud HA & Scaling No additional configuration required Multi-AZ not configured out-of-the-box for HA. No extra cost from a 2nd node 2x costs due to required 2nd VM. SLA at for all open source DB services No SLA for single-AZ deployment; for Multi- PaaS ++ AZ deployment Azure Integration Secure container-enabled elastic scaling: VM based scaling takes minutes, and independently scale compute and storage; scale compute/storage not fully decoupled storage instantly and compute in seconds.

10 All based on Truly Global Reach Microsoft IP. My Intelligent insights and ATP to enhance performance and security Azure Database for MySQL/PostgreSQL AWS RDS for MySQL/PostgreSQL. ML-based, intelligent insights & recommendation Performance insights for MySQL/PostgreSQL*. (Preview) that learns your unique database patterns Based on historical, static query snapshots only Cloud HA & Scaling and provides customized recommendations, enabling customers to maximize the performance of PostgreSQL No time-series enabled drill-down on dynamics of database. each query processing. PaaS ++ No recommendation based on root-cause analysis for easy query plan fix Advanced Threat Protection (ATP) (Preview): the Azure Integration same ATP that protects SQL DB with data discovery &.