Czwartki z Azure - Open source'owe bazy danych na Azurze

Transcript

1. Open Source Databases on Azure Czwartki z Azure Alicja Kucharczyk EMEA Global Blackbelt OSS Data Tech Specialist @azuredbpostgres / @StiepanTrofimo
2. 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”
3. Open Source Investments are Fueling the Momentum SQL Server on Linux Microsoft joins Eclipse Foundation HD Insight managed service on Linux Azure Marketplace 60% of all images in Azure Marketplace are based on Linux/OSS Partnership with the Linux Foundation for Linux on Azure certification 600 Million+ Lines of open source code submitted to GitHub by Microsoft engineers Microsoft Open Source Hub 1 out of 3 1 out of 3 VMs on Azure run Linux, and more than half of all new VMs run Linux Acquisition Jenkins project on Azure Our Products Our Partnerships Our Offerings Ross Gardler President Apache SW Foundation Our Employees Partnership Run Linux on Windows natively C:\Users\markhill> bash root@localhost: #
4. Open Source Hub 4 Intranet site that tracks contributions by Microsoft engineers to open source projects on GitHub: # Repositories (product/project code base) # Contributors # Lines of code submitted today, life to date Details available per repository Take a look: https://opensourcehub.microsoft.com/ Open Source Resources for MS Engineers
5. Microsoft Azure Welcomes PostgreSQL Committers aka.ms/blog-postgres-committers
6. M A N A G E D C O M M U N I T Y V E R S I O N Focus on your apps by leaving the management and patching of your infrastructure and database to an enterprise- ready cloud service with: • Automatic updates • Automatic security fixes • Automatic new feature updates MySQL: 5.6, 5.7, and 8.0 (public preview) PostgreSQL: 9.5, 9.6, 10, and 11 MariaDB: 10.2
7. … 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
8. Elasticity Built-in elasticity for quick scaling How does our elastic scaling go beyond the traditional VM 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
9. = $285 vs $132 = = $285 vs $262 = HIGH AVAILABILITY AND SCALE High-Availability High-Availability
10. BACKUP AND RESTORE • Built-in backups • Choose LRS or GRS • Restore from geo-redundant backups for disaster recovery (RPO <= 1 hr.) • 1x Backup storage included • PITR up to 35 days (min. 7 days)
11. MONITORING AND ALERTING • Built-in monitoring • Enabled for database engine monitoring by default • Configurable alerts • Auto notifications
12. Innovate faster through integration with Azure services ➢Intuitive integration with popular Azure services; improving developer’s agility to build smart applications ➢Enables developers to easily deploy and scale enterprise grade web applications written in a variety of languages. ➢Integration with a multitude of services without ever worrying about infrastructure management Power BI Azure App Services Azure Data Factory Azure Analysis Services Azure Machine Learning Azure Cognitive Services Azure Bot Service Azure Kubernete s Service
13. Platform Services Infrastructure Services Datacenter Infrastructure Web Apps Infrastructure Mobile Backends API Management API App Infrastructure Business Process Automation Push Notifications Content Delivery Network (CDN) Live & OD Media Streaming B2B Integration Hybrid Connections Pub/Sub Queuing Simple Queuing Hybrid Operations Server Data Backup Hybrid/Intelligent Data Backup Disaster Recovery Bulk Data Import And Export Relational SQL Database Document Database Service Distributed In-Memory Cache Search Simple Key/Value Store Data Warehouse Directory Health Monitoring Privileged Identity Management Operational Analytics Stateless Compute Scheduled Compute Jobs Virtual App Streaming Distributed Compute Development Tools Application Instrumentation Software Development Kits Software Lifecycle Management Domain Join & Policy Management Big Data Analytics Predictive Analytics Data Stream Analytics Data Pipelines Device Data Collection Mobile Analytics Big Data Storage IoT Device Management Data Source Management Security & Management User/Group Directory Store Multi-Factor Authentication Scheduled Service Management Service Creation & Configuration Encryption Key Store Software/Solution Marketplace Identity Sign-Up and sign-in Task Scheduler
14. 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
15. Azure: The Most Trusted Cloud HIPAA / HITECH FedRAMP JAB P-ATO FIPS 140-2 FERPA DISA Level 2 ITAR-ready CJIS 21 CFR Part 11 IRS 1075 Section 508 VPAT ISO 27001 PCI DSS Level 1 SOC 1 Type 2 SOC 2 Type 2 ISO 27018 Cloud Controls Matrix Content Delivery and Security Association Shared Assessments European Union Model Clauses United Kingdom G-Cloud Singapore MTCS Level 3 Australia Signals Directorate Japan Financial Services China Multi Layer Protection Scheme China CCCPPF New Zealand GCIO China GB 18030 EU Safe Harbor ENISA IAF
17. 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
18. Save money, eliminate the risk of lock-in with the best of open source community along with the manageability and integration benefits of Azure Identity, security, management, and compliance Open Source Proven resilience & stability Rich feature set Fully managed Intelligent Performance Highly scalable High Availability Maximum control Integrated with Azure data ecosystem
19. Migrate to Azure Database to PostgreSQL Microsoft Azure On-premises workloads Azure Database Migration Service Azure migration resources Database Migration Guide http://aka.ms/datamigration Azure Database Migration Service Migrate with minimum downtime http://aka.ms/get-dms Sign up for Preview http://aka.ms/dms-preview
20. Microsoft Windows chooses Azure Database for PostgreSQL Hyperscale Windows was looking for a cloud-based database that could support the volume and velocity of transactions in its diagnostic metrics and improve customer experience during updates With PostgreSQL Hyperscale, ship/no-ship decisions for Windows were made based on on-the-fly analytics on billions of JSON events with sub-second responses. Data volume: 1.5 PB+​ Real-time analytics: 95% queries execute in <4s Response times: 75% of queries are <200ms Query volume: >6m daily
21. Demo
22. 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
23. Any questions?