Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Innovations to boost productivity with Azure-managed MySQL, Postgres, & MariaDB databases | Ignite 2019 | Sunil Kamath

Innovations to boost productivity with Azure-managed MySQL, Postgres, & MariaDB databases | Ignite 2019 | Sunil Kamath

Cloud is fueling the growth of open source databases such as MySQL, PostgreSQL, and MariaDB. More than 70% of new applications are developed with these databases. Azure offers a fully-managed database service used in industries such as financial, retail, and manufacturing—powering mission-critical, LOB, and real-time operational analytical applications. These apps demand enterprise-grade security, hyperscale performance and scalability, high availability, and advanced performance management. This demo-filled session from the people who build the service focuses on new and upcoming innovations across these key areas. Gain a clear understanding of these innovative capabilities, and how you can apply them to boost productivity.

Azure Database for PostgreSQL

November 05, 2019
Tweet

More Decks by Azure Database for PostgreSQL

Other Decks in Technology

Transcript

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

    View Slide

  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”

    View Slide

  3. 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

    View Slide

  4. Key opportunities driving OSS Growth

    View Slide

  5. 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

    View Slide

  6. Ignite Announcements

    View Slide

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

    View Slide


  8. 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

    View Slide

  9. 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

    View Slide

  10. 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

    View Slide

  11. DEMO

    View Slide

  12. 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*

    View Slide

  13. 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

    View Slide

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

    View Slide

  15. Beyond standalone databases

    View Slide

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

    View Slide

  17. Any hardware OEM hardware
    AKS
    Any Kubernetes
    GKE EKS
    Kubernetes OPENSHIFT

    Azure data service
    Cloud native scale on-premise – Azure Arc

    View Slide

  18. Demo

    View Slide

  19. 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

    View Slide

  20. DEMO

    View Slide

  21. 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

    View Slide

  22. So What’s next?

    View Slide

  23. 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

    View Slide

  24. 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

    View Slide

  25. 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]

    View Slide

  26. Questions

    View Slide