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

Easily Make the Most of Your Data with MySQL HeatWave - Valorizing your data has never been so easy!

Easily Make the Most of Your Data with MySQL HeatWave - Valorizing your data has never been so easy!

MySQL HeatWave - MySQL in-Memory Query Accelerator
The only MySQL service with a massively-scalable, native query accelerator

During the last 20 years MySQL has democratized the usage of transactional
databases.

Now with MySQL HeatWave we are in the process of democratizing Analytics
and Machine Learning.

With MySQL HeatWave, valorizing your data has never been so easy!

Olivier DASINI

September 26, 2022
Tweet

More Decks by Olivier DASINI

Other Decks in Technology

Transcript

  1. Easily Make the Most of Your Data
    with MySQL HeatWave
    Valorizing your data has never been so easy!
    Olivier Dasini
    MySQL Cloud Principal Solutions Architect EMEA
    [email protected]
    Blogs : www.dasini.net/blog/en
    : www.dasini.net/blog/fr
    Linkedin: www.linkedin.com/in/olivier-dasini
    Twitter : @freshdaz

    View full-size slide

  2. Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    2
    Me, Myself & I

    MySQL Geek
     Addicted to MySQL for 15+ years
     Playing with databases for 20+ years

    MySQL Writer, Blogger and Speaker
     Also: DBA, Consultant, Architect, Trainer, ...

    MySQL Cloud Principal Solutions Architect EMEA at Oracle

    Stay up to date!
     Blog: www.dasini.net/blog/en
     Linkedin: www.linkedin.com/in/olivier-dasini/
     Twitter: @freshdaz
    Olivier DASINI

    View full-size slide

  3. Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    3
    MySQL
    3
    The world’s most popular open source database

    View full-size slide

  4. MySQL powers Open Source applications
    Copyright © 2022, Oracle and/or its affiliates
    Custom Apps
    Development
    Content management
    and eCommerce
    Learning platforms
    4

    View full-size slide

  5. Common MySQL use cases
    Copyright © 2022, Oracle and/or its affiliates
    Social
    applications
    E-Commerce
    Content management
    Users profile
    management
    Digital
    payments
    Fraud detection
    IoT monitoring
    systems
    Digital
    marketing
    Online gaming
    Retail POS
    systems
    Employee portals
    Authentication
    systems
    Logistics
    applications
    5

    View full-size slide

  6. Innovative organizations across many industries run MySQL
    Copyright © 2022, Oracle and/or its affiliates
    Social E-Commerce Tech Finance Manufacturing
    Because of its reliability, high-performance, and ease of use
    6

    View full-size slide

  7. Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    7
    MySQL Database Service
    7
    The MySQL Cloud Service
    100% developed, managed, & supported
    by the MySQL team

    View full-size slide

  8. MySQL Database Service - Highlights
    Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    8
    100% developed, managed, and supported by Oracle MySQL

    View full-size slide

  9. MySQL Database Service - Highlights
    Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    9
    A fully managed cloud service

    Standalone
    – Single-instance MySQL DB System

    High Availablility
    – Guarantees if one instance fails, another takes over, with zero data loss and minimal downtime

    Data Security
    – MySQL Database Service utilizes encryption to keep your data private

    Encryption at rest

    Encryption in transit (TLS)

    Replication
    – Inbound Replication: from a source to a DB system
    – Outbound Replication: asynchronous replication of your DB system database

    Audit Service
    – MySQL Database integrates with the Oracle Cloud Infrastructure Audit Service

    Metrics
    – Enable you to measure useful quantitative data of the MySQL DB system

    HeatWave
    – A distributed, scalable, shared-nothing, in-memory, hybrid columnar, query processing engine designed for
    extreme performance

    View full-size slide

  10. Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    10
    MySQL HeatWave
    10
    In-Memory Query Accelerator

    View full-size slide

  11. MySQL is optimized for OLTP, not designed for analytic processing
    Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    11
    OLTP Applications
    OLAP Applications
    OLTP DB
    OLAP DB
    ETL Service
    Separate analytics
    database
    Complex ETL
    No real-time analytics
    Security & compliance
    risks
    Increased costs

    View full-size slide

  12. Why is ETL a Problem?
    Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    12
    Data Extraction
    • Requires complex logic to
    extract relevant data
    Maps
    Routes
    Processes
    Data Movement
    • Requires data
    transformation, security
    access and loading to new
    DB across networks
    Multiple DB to Manage
    • Need to manage analytic
    and MySQL DB separately
    Stale Data
    • Data recently added or
    updated is not available for
    analytics
    12

    View full-size slide

  13. One database is better than two
    Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    13
    Analytics tools and
    applications
    Transactional
    applications
    OLTP
    engine
    HeatWave
    analytics
    cluster
    One service for OTLP & OLAP
    No ETL duplication
    Unmatched performance, at a
    fraction of the cost
    Real-time analytics
    Improved security
    Applications work without
    changes
    1>2 with MySQL HeatWave
    Easily run high performance analytics against your MySQL database, no ETL required
    Query
    Accelerator
    InnoDB

    View full-size slide

  14. *Benchmark queries are derived from the TPC-H benchmark, but results are not comparable to published TPC-H benchmark results since they do not comply with the TPC-H specification
    14
    400G, 64 cores
    MySQL HeatWave dramatically speeds up analytic queries
    Copyright © 2022, Oracle and/or its affiliates

    View full-size slide

  15. 15
    Let me show you...
    MySQL HeatWave dramatically speeds up analytic queries
    LIVE
    DEMO
    Analytics
    Dashboard
    Copyright © 2022, Oracle and/or its affiliates

    View full-size slide

  16. MySQL HeatWave performance and price comparison
    Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    16
    30TB TPCH, MySQL HeatWave is faster, cheaper & easier to use than all the competitive database services
    See documented performance comparisons that show how HeatWave is 6.5X faster than Amazon Redshift at half the cost, 1400X faster than Amazon Aurora at half the cost, and 5400X faster than Amazon RDS for MySQL at two-thirds the cost
    See Benchmark details:
    https://www.oracle.com/mysql/heatwave/performance/

    View full-size slide

  17. Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    17
    MySQL HeatWave ML
    17
    Build, Train, Deploy, & Explain Machine Learning
    models within MySQL HeatWave,
    at NO additional cost

    View full-size slide

  18. Copyright © 2022, Oracle and/or its affiliates
    Need to ETL data to a separate ML solution for training and inference
    And it gets worse when
    using other databases...
    • Complex, time-consuming
    • Increases costs and risks
    • Need to learn new tools/languages
    18

    View full-size slide

  19. Copyright © 2022, Oracle and/or its affiliates
    In-database machine learning with MySQL HeatWave
    Accelerate ML initiatives, increase security, and reduce costs
    19

    View full-size slide

  20. Copyright © 2022, Oracle and/or its affiliates
    MySQL HeatWave ML uses a set of SQL routines
    Machine Learning with MySQL HeatWave is so simple
    You only need to use a limited set of SQL routines:

    ML_TRAIN: Trains a machine learning model for a given training dataset

    ML_PREDICT_ROW: Makes predictions for one or more rows of data

    ML_PREDICT_TABLE: Makes predictions for a table of data

    ML_EXPLAIN_ROW: Explains predictions for one or more rows of data

    ML_EXPLAIN_TABLE: Explains predictions for a table of data

    ML_SCORE: Computes the quality of a model
    20

    View full-size slide

  21. 21
    Let me show you...
    Machine Learning with MySQL HeatWave is so simple
    LIVE
    DEMO
    Iris Dataset
    Copyright © 2022, Oracle and/or its affiliates

    View full-size slide

  22. Copyright © 2022, Oracle and/or its affiliates
    HeatWave ML vs Redshift ML: Benchmarks 1/3
    22

    View full-size slide

  23. Copyright © 2022, Oracle and/or its affiliates
    HeatWave ML vs Redshift ML: Benchmarks 2/3
    23

    View full-size slide

  24.  Produces more accurate results
     Trains models 25X faster on average
     1% of the cost
     Scales as more modes are added
    HeatWave ML vs Redshift ML: Benchmarks 3/3
    Copyright © 2022, Oracle and/or its affiliates
    See Benchmark details:
    https://www.oracle.com/mysql/heatwave/performance/
    24

    View full-size slide

  25. Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    25
    MySQL HeatWave
    25
    Wrap-up

    View full-size slide

  26. During the last 20 years MySQL has democratized the usage of transactional
    databases.
    Now with MySQL HeatWave we are in the process of democratizing Analytics
    and Machine Learning.
    With MySQL HeatWave, valorizing your data has never been so easy!
    Copyright © 2022, Oracle and/or its affiliates
    MySQL HeatWave - MySQL in-Memory Query Accelerator
    The only MySQL service with a massively-scalable, native query accelerator
    26

    View full-size slide

  27. Copyright © 2022, Oracle and/or its affiliates
    MySQL HeatWave - OLTP + OLAP + ML
    Example : Banking data valorization made easy
    27

    View full-size slide

  28. MySQL HeatWave - MySQL in-Memory Query Accelerator
    28 Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    The only MySQL service with a massively-scalable, native query accelerator
    Single MySQL database for OLTP &
    Analytics & Machine Learning
    All existing applications work without
    any changes
    Extreme performance: Accelerates
    MySQL by orders of magnitude, scales to
    thousands of cores
    ML-based automation with MySQL
    Autopilot
    Dramatically faster and lower cost
    compared to other cloud services

    View full-size slide

  29. Why MySQL HeatWave for new and existing applications?
    Copyright © 2022, Oracle and/or its affiliates
    Unmatched price
    performance
    Integrated in-memory query
    accelerator
     6.5X faster than Redshift at
    half the cost
     7X faster than Snowflake at
    20% the cost
     1,400X faster than Aurora
    at half the cost
    MySQL Autopilot: automation
    to achieve high query
    performance at scale
    Real-time, secure
    analytics
    Analytics queries always
    access the most up-to-date
    data
    Avoid security risks of moving
    data between databases and
    ML services
    Data always encrypted
    Simplicity of one
    managed service for
    OLTP, OLAP, and ML
    No separate analytics
    database and machine
    learning services
    No complex, costly ETL
    duplication
    MySQL and Amazon
    Aurora-based applications
    work without changes
    29

    View full-size slide

  30. Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    30
    Test Drive MySQL
    Database Service For
    Free Today
    Get $300 in credits
    and try MySQL Database Service
    free for 30 days.
    https://www.oracle.com/cloud/free/

    View full-size slide

  31. Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    31
    Resources

    View full-size slide

  32. Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    32
     Introducing the MySQL Database Service
    https://blogs.oracle.com/mysql/introducing-the-mysql-database-service
     Migrate from on premise MySQL to MySQL Database Service
    https://blogs.oracle.com/mysql/migrate-from-on-premise-mysql-to-mysql-database-service
     Setup Disaster Recovery for OCI MySQL Database Service
    https://lefred.be/content/setup-disaster-recovery-for-oci-mysql-database-service/
     Cost Estimator
    https://www.oracle.com/cloud/cost-estimator.html
     OCI Free Trial
    https://www.oracle.com/cloud/free/
     Documentations
    https://docs.cloud.oracle.com/en-us/iaas/mysql-database/index.html
    https://www.oracle.com/mysql/
     Iris Data Set with MySQL HeatWave Machine Learning & Zeppelin
    https://dasini.net/blog/2022/07/18/iris-data-set-with-mysql-heatwave-machine-learning-zeppelin/
     Configure Apache Zeppelin for MySQL HeatWave
    https://dasini.net/blog/2022/07/05/interactively-explore-visualize-your-mysql-heatwave-data-with-apache-zeppelin/
    MySQL HeatWave Database Service Resources

    View full-size slide

  33. Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    33
     Discovering MySQL Database Service – Episode 1 – Introduction
    http://dasini.net/blog/2021/08/03/discovering-mysql-database-service-episode-1-introduction/
     Discovering MySQL Database Service – Episode 2 – Create a compartment
    http://dasini.net/blog/2021/08/10/discovering-mysql-database-service-episode-2-create-a-compartment/
     Discovering MySQL Database Service – Episode 3 – Create a Virtual Cloud Network
    http://dasini.net/blog/2021/08/17/discovering-mysql-database-service-episode-3-create-a-virtual-cloud-network/
     Discovering MySQL Database Service – Episode 4 – Dump your MySQL data into an Object Storage bucket
    http://dasini.net/blog/2021/08/24/discovering-mysql-database-service-episode-4-dump-your-mysql-data-into-an-object-storage-bucket/
     Discovering MySQL Database Service – Episode 5 – Create a MySQL DB system from a MySQL Shell dump
    http://dasini.net/blog/2021/08/31/discovering-mysql-database-service-episode-5-create-a-mysql-db-system-from-a-mysql-shell-dump/
     Discovering MySQL Database Service – Episode 6 – Update the Private Subnet Security List
    http://dasini.net/blog/2021/09/07/discovering-mysql-database-service-episode-6-update-the-private-subnet-security-list/
     Discovering MySQL Database Service – Episode 7 – Use a Bastion SSH port forwarding session
    http://dasini.net/blog/2021/09/14/discovering-mysql-database-service-episode-7-use-a-bastion-ssh-port-forwarding-session/
     Discovering MySQL Database Service – Episode 8 – Connect to MySQL Database Service Using MySQL Shell
    http://dasini.net/blog/2021/09/21/discovering-mysql-database-service-episode-8-connect-to-mysql-database-service-using-mysql-shell/
     Discovering MySQL Database Service – Episode 9 – Connect to MySQL Database Service Using MySQL Workbench
    http://dasini.net/blog/2021/09/28/discovering-mysql-database-service-episode-9-connect-to-mysql-database-service-using-mysql-workbench/
     Discovering MySQL Database Service – Episode 10 – Connect to MySQL Database Service Using OCI Cloud Shell
    http://dasini.net/blog/2021/10/05/discovering-mysql-database-service-episode-10-connect-to-mysql-database-service-using-oci-cloud-shell/
    Discovering MySQL HeatWave Database Service
    Tutorials where I show you, step by step, how to use MDS and some other OCI services
    www.dasini.net/blog/en

    View full-size slide

  34. Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    34
    MySQL HeatWave — New Machine Learning Capabilities (2022)

    What is MySQL HeatWave?
    – https://www.youtube.com/watch?v=cTUCzsYAi94

    MySQL HeatWave Database Service
    – https://www.oracle.com/mysql/

    In-Database Machine Learning with MySQL HeatWave
    – https://blogs.oracle.com/mysql/post/in-database-machine-learning-with-mysql-heatwave

    MySQL HeatWave ML
    – https://www.oracle.com/a/ocom/docs/mysql/mysql-heatwave-ml-technical-brief.pdf

    Estuda.com increases query responses by 300X with MySQL HeatWave
    – https://www.youtube.com/watch?v=9cedEkFEKLs

    VRGlass increases database performance 5X with MySQL HeatWave
    – https://www.youtube.com/watch?v=D4z-Ewk9bh8

    Genius Sonority speeds game analytics by 90X with MySQL HeatWave
    – https://www.youtube.com/watch?v=zwmVYq0MsPs
    One MySQL Database for OLTP, OLAP, and machine learning (ML)
    https://www.oracle.com/fr/events/live/mysql-heatwave-ml/on-demand/

    View full-size slide

  35. Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    35
     Highlights: Announcing MySQL Database Service—New HeatWave Innovations
    https://youtu.be/FUbnOTlJ7mI
     Demonstration of MySQL HeatWave Autopilot
    https://youtu.be/CyuBxBryJVA
     Tetris.co speeds real-time insights with MySQL HeatWave
    https://www.oracle.com/customers/tetris-co/
     Red3i increases insights by 1,000X with MySQL HeatWave
    https://www.oracle.com/customers/red3i/
     FANCOMI accelerates ad analytics by 10X with MySQL HeatWave
    https://www.oracle.com/customers/fancomi/
     Customer feedack: Tetris.co
    https://youtu.be/TrYAluHRXXs
     Customer feedack: Fan Communications
    https://youtu.be/SiBHyYPlSNU
    MySQL Database Service — New HeatWave Innovations (2021)
    https://www.oracle.com/events/live/mysql-heatwave-innovations/

    View full-size slide

  36. Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    36
    Follow us on Social Media

    View full-size slide

  37. Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    37
    Merci!
    Q&R
    Olivier Dasini
    MySQL Cloud Principal Solutions Architect EMEA
    [email protected]
    Blogs : www.dasini.net/blog/en
    : www.dasini.net/blog/fr
    Linkedin: www.linkedin.com/in/olivier-dasini
    Twitter : @freshdaz

    View full-size slide