Azure Database Services For MySQL, PostgreSQL, And MariaDB

October 2018

40%WHY OPENSOURCE? 60%90%

“Judge us by the actions we havetaken in the recent past, ouractions today and in the future.”— Satya Nadella, CEOMicrosoft

Cloud App OSS Data BackendWhen you need .Because But not for Web frameworks,transactionsTransactions, joins,structured data,familiar SQL queryQuickly changingdata schemasKey-value pairstore for heavyread-write, eventsLow-cost, fast,massive scaleRich queryHierarchical, web,mobileFlexible schema,familiar SQL query,low latencyComplex joinsCosmosDBHeavy read-write,events, IoTOpen-source,integration withHadoop analyticsOperationalsimplicityHBase onHDInsightGame state, UserSessionsIncreasing speed ofPrimary data storean appRedis CacheSearch serviceIntegrating searchinto an appAzure SearchPrimary data storeUse MySQL, PGSQL,MariaDBTables

o-production-databaseAzure Web App Auto scale enabled Custom docker image Pod K8S deploymentAzure Storage Uploaded Photos and Videos Secure upload and streaming Hot, Cool and Archive tiersClient UserMySQL Database 99.99% SLA Scale up or scale out Product OrdersRedis Cache Scale via add’l nodes App state Session cache

The journey deepens

Power BI, App Services, Data Factory,Analytics, ML, Cognitive, Bot A Z U R E R E L AT I O N A L DATA B A S E P L AT F O R MSQL DataWarehouseSQL DatabasePostgreSQLMySQLIntelligent: Advisors, Tuning, MonitoringDatabaseServicesFlexible: On-demand scaling, Resource governancePlatformTrusted: HA/DR, Backup/Restore, Security, Audit, IsolationAzure ComputeAzure StorageGlobal Azure with 43 RegionsMariaDBPREVIEW

SERVICE TIERSIntended Use CasevCoreCompute GenerationStorageIOPSGeneral PurposePerformance OptimizedIdeal for most business workloadsoffering balanced and scalablecompute and storage optionsCache more data for fastertransaction processing and higherconcurrency22BasicService TierBalanced IO and ComputeBuilt for workloads with light computeneeds and variable IO performance124816Memory Optimized324816Gen 4, Gen 5Gen 4, Gen 5Gen 5 only5 GB – 1 TBMagnetic Media5GB – 2TBRemote SSD5GB – 2TBRemote SSDVariable100-6000 IOPS100-6000 IOPS

SERVICE TIERSIntended Use CasevCoreCompute GenerationStorageIOPSGeneral PurposePerformance OptimizedIdeal for most business workloadsoffering balanced and scalablecompute and storage optionsCache more data for fastertransaction processing and higherconcurrency22BasicService TierBalanced IO and ComputeBuilt for workloads with light computeneeds and variable IO performance124816Memory Optimized324816Gen 4, Gen 5Gen 4, Gen 5Gen 5 only5 GB – 1 TBMagnetic Media5 GB – 4 TBRemote SSD5GB – 2TBRemote SSDVariable100-6000 IOPS100-6000 IOPS

SERVICE TIERSIntended Use CasevCoreCompute GenerationStorageIOPSGeneral PurposePerformance OptimizedIdeal for most business workloadsoffering balanced and scalablecompute and storage optionsCache more data for fastertransaction processing and higherconcurrency22BasicService TierBalanced IO and ComputeBuilt for workloads with light computeneeds and variable IO performance124816Memory Optimized324816Gen 4, Gen 5Gen 4, Gen 5Gen 5 only5 GB – 1 TBMagnetic Media5 GB – 4 TBRemote SSD5 GB – 4 TBRemote SSDVariable100-6000 IOPS100-6000 IOPS

S E C U R I T Y B U I LT I N Native authenticationIdentity Threat detection Secure SSL connectivity Server firewall rulesControl accessProtect data Virtual Network (SE) Built-in encryption at-restfor data and backups

VNET SERVICE ENDPOINTInternet Extend VNET private addressspace to Azure Database forMySQL and PostgreSQLMicrosoftAzureNot allowedCustomer VNET Easy to configure (usesMicrosoft.SQL service tag) Each VNET service endpointVNETUserService EndPoint(Azure MySQL Database)HDInsightHDI SubnetACLNot allowedFrontEnd Subnetapplies to only one AzureregionVNETVNETUserService EndPoint(Azure MySQL Database)BackEnd SubnetCustomer ServersIP ACLVNETACLAzure MySQLDatabaseCustomer ServersIP ACLVirtual NetworkGatewayOn-PremisesAzure PostreSQLDatabaseExpress Route Public Peering orInternet (using ACLed NAT IPs) in development

SECURE ANDCOMPLIANTProtect your data with up-to-date security andcompliance features with the Azure IP Advantage.SOC 2Type 2 SOC1 – Compliant SOC2 – Compliant SOC3 – Compliant ISO 27001:2013 – Compliant ISO 27018:2014 – Compliant CSA STAR Certification – Compliant HIPAA / HITECH Act – Compliant PCI DSS Level 1 – Compliant ISO 27017:2015 – Compliant ISO 27018:2014 – Compliant ISO 9001:2015 – Compliant ISO/IEC 20000-1:2011 – Compliant ISO 22301:2012 – PendingLevel 1CSA STARCertification

B U I LT - I N H I G H AVA I L A B I L I T YElastically scale your compute up or downIndependently scale up storage as needed seamlesslyUse replicas only if you need to!Server provisioning andmanagementUS WestMySQL IP:3306PGSQL IP:5432MySQL orPostgreSQLServerMySQL orPostgreSQLServerRetryAzure Storageserver server.mysql.database.azure.com

H I G H AVA I L A B I L I T Y A N D S C A L EHigh AvailabilityHigh Availability 285 285 vsvs 132 262

H I G H AVA I L A B I L I T Y I N AW S R D S VS . A D SHigh AvailabilityAWS RDS with a 99.95% SLA is 2xmore expensive* than AzureDatabase for MySQL/PostgreSQLHigh Availability* as of June 2018

S C A L E P E R F O R M A N C E O N T H E F LYScale your server compute up or down in seconds!Independently scale up storage as neededServer provisioning andmanagementUS WestMySQL IP:3306PGSQL IP:5432MySQL orPostgreSQLServerMySQL orPostgreSQLServerAzure Storageserver server.mysql.database.azure.com

B AC K U P A N D R E S TO R E Built-in backups Choose LRS or GRS Restore from geo-redundantbackups for disaster recovery(RPO 1 hr) 1x Backup storage included PITR up to 35 days (min. 7 days)

M O N I TO R I N G A N D A L E RT I N G Built-in monitoring Configurable alerts Auto notifications Enabled for database enginemonitoring by default

M YS Q L DATA - I N R E P L I C AT I O N Data-in Replication (for migration scenarios)ooReadRead

M YS Q L A N D P O S TG R E S Q L R E P L I C AT I O N Same region replica (for read scale-out)oReplica Each replica is a new MySQL/PostgreSQLserver MySQL: Native replication PostgreSQL: In previewRead WriteRead

M I G R AT I O N M E T H O D S1. MySQL dump and PG dumpNative commands, no additional setup2. Migration wizard-Native way, no additional setup-Use when application can toleratedowntime-Third-party solution, needs setup-Use when application cannottolerate downtime-Fully-orchestrated migration serviceGeneral Availability (H1 2018)hereNative or 3rd party tools3. ReplicationAttunity, near-zero down time migrationAzure Database Migration Service

K E Y L E A R N I N G S F O R AC H I E V I N GBEST PERFORMANCE Network latencyoo Best practicesoo

K E Y L E A R N I N G S F O R AC H I E V I N GBEST PERFORMANCE Storageoo Best practicesoooooopostgres (pg stat statements)

K E Y L E A R N I N G S F O R AC H I E V I N GBEST PERFORMANCE CPUooo Best practicesooooopostgres (pg stat statements)

Server provisioning and management server server.mysql.database.azure.com Retry Elastically scale your compute up or down Independently scale up storage as needed seamlessly Use replicas only if you need to! MySQL IP:3306 PGSQL IP:5432 US West Azure Storage MySQL or PostgreSQL Server MySQL or PostgreSQL Server