MySQL HeatWave Database Service - Single database for OLTP, Analytics and Machine Learning

MySQL HeatWave is a MySQL in-Memory Query Accelerator:

- Single MySQL database for OLTP & Analytics & Machine Learning applications
- All existing applications work without any changes
- Machine-learning–based automation with MySQL Autopilot
- Extreme performance: Accelerates MySQL by orders of magnitude, scales to thousands of cores
- Enables running analytics & Machine Learning on data stored on-premises
- Dramatically faster and lower cost compared to other cloud services

Transcript

1. MySQL HeatWave Database Service
   Single database for OLTP
   , Analytics and Machine Learning
   Olivier Dasini
   MySQL Cloud Principal Solutions Architect EMEA
   olivier.dasini@oracle.com
   Blogs : www.dasini.net/blog/en
   : www.dasini.net/blog/fr
   Linkedin: www.linkedin.com/in/olivier-dasini
   Twitter : @freshdaz
   

   View Slide

2. Me, Myself & I
   
   MySQL Geek
    Addicted to MySQL for 15+ years
    Playing with databases for 20+ years
   
   MySQL Writer, Blogger and Speaker
    Also former : 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 Slide

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

   View Slide

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

   View Slide

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

   View Slide

6. MySQL Database Service is also available in Marseille region
   Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
   6
   Included in all OCI regions
   • MySQL Database Service & MySQL HeatWave database cloud service are included in all Oracle Cloud
   Infrastructure regions including Marseille (France South region)
   – The region identifier is eu-marseille-1
   – The region key is MRS
   

   View Slide

7. MySQL Database Service is a fully managed cloud service
   Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
   7
   Automate many of the manual tasks
   

   View Slide

8. MySQL Database Service is...
   Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
   8
   100% Developed, Managed and Supported by the MySQL Team
   

   View Slide

9. MySQL Database Service is...
   Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
   9
   Easy to use, Secure and powered by MySQL Enterprise Edition
   

   View Slide

10. MySQL Database Service
    Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    10
    Allows you to save time and money
    

    View Slide

11. MySQL Database Service cost less
    Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    11
    MySQL Database Service: Standard E3 AMD 16GB/Core, all regions have the same price.
    Amazon RDS: Intel R5 16GB/Core, AWS US East.
    Azure: Memory Optimized Intel 20GB/Core, MS Azure US-East.
    Google: High Memory N1 Standard Intel 13GB/Core, GCP Northern Virginia.
    Configuration: 100 OCPUs, 1 TB Storage.
    MySQL Database Service Amazon RDS Microsoft Azure Google Cloud SQL
    $0
    $50,000
    $100,000
    $150,000
    $200,000
    $250,000
    $65,833
    $215,652 $212,974
    $170,244
    Annual cost for a 100 OCPUs, 1TB Storage configuration
    

    View Slide

12. MySQL DB Systems Types
    Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    12
    ●
    Standalone
    – Single-instance of the latest version of MySQL Server Enterprise Edition 8.0
    ●
    High Availability
    – A 3 node MySQL Group Replication cluster to provide standby replicas to protect your data and provide business
    continuity
    ●
    HeatWave
    – MySQL HeatWave clusters for accelerated processing of analytic queries and Machine Learning
    

    View Slide

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

    View Slide

14. MySQL HeatWave - MySQL in-Memory Query Accelerator
    14 Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    Easily run high performance analytics against your MySQL database, no ETL required
    Single MySQL database for
    OLTP & analytics applications
    All existing applications work
    without any changes
    Extreme performance: 400x
    faster than MySQL, scales to
    thousands of cores
    OLAP Applications
    OLTP Applications
    OLTP
    Engine
    Analytics
    Engine
    MySQL
    HeatWave
    Query
    Accelerator
    InnoDB
    

    View Slide

15. *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
    400G, 64 cores
    MySQL HeatWave dramatically speeds up analytic queries
    15 Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    

    View Slide

16. MySQL HeatWave – Performance and Price Comparison
    16 Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    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
    www.oracle.com/mysql/heatwave/performance
    

    View Slide

17. MySQL HeatWave ML - Run Machine Learning on existing cluster
    17 Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    Build, train, deploy, & explain machine learning models within MySQL HeatWave, at no additional cost
    Single MySQL database for all
    applications
    All existing applications work
    without any changes
    Train, inference & explain
    within the database
    No need to learn new
    language or ML packages
    

    View Slide

18. Example : Loan Approval
    MySQL HeatWave – OLTP + OLAP + ML
    18 Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    

    View Slide

19. MySQL HeatWave ML is 25x faster than Redshift ML
    25x faster on average without compromising accuracy
    19 www.oracle.com/mysql/heatwave/performance
    Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    

    View Slide

20. MySQL HeatWave ML is 1% of cost of Redshift ML
    1% of cost and no additional cost for MySQL HeatWave customers
    20 www.oracle.com/mysql/heatwave/performance
    Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    

    View Slide

21. All MySQL compatible analytics applications run without any changes
    21 Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    Oracle
    MySQL Database Service
    OLTP
    Applications
    OLAP BI &
    Analytics
    Social
    ECommerce
    FinTech
    SaaS
    OLTP
    Engine
    Analytics
    Engine
    Automatic, Real-time
    Data Propagation
    

    View Slide

22. End-to-end Integration from data ingestion to data visualization
    MySQL HeatWave is integrated with other Oracle services
    22 Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    Data Sources Data Consumers
    Enterprise
    Devices
    Events
    Social
    voice
    Any
    digital asset
    Sensors
    Applications
    Oracle Cloud Infrastructure
    Applications
    People
    Analytics
    Engine Oracle
    Analytics
    Cloud
    Data
    Visualization
    MySQL
    Database
    Service
    Data
    Integration
    Service
    Data
    Ingestion
    OLTP
    Engine
    

    View Slide

23. MySQL HeatWave - MySQL in-Memory Query Accelerator
    23 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 applications
    All existing applications work without any changes
    Machine-learning–based automation with MySQL Autopilot
    Extreme performance: Accelerates MySQL by orders of magnitude, scales to thousands
    of cores
    Enables running analytics & ML on data stored on-premises
    Dramatically faster and lower cost compared to other cloud services
    

    View Slide

24. Discovering MySQL Database Service
    Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    24
    Tutorials where I show you, step by step, how to use MDS and some other OCI services
    http://dasini.net/blog/en
    ●
    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/
    

    View Slide

25. MySQL Database Service—New Machine Learning Capabilities (2022)
    Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    25
    One MySQL Database for OLTP, OLAP, and machine learning (ML)
    ●
    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
    https://www.oracle.com/fr/events/live/mysql-heatwave-ml/on-demand/
    

    View Slide

26. MySQL Database Service—New HeatWave Innovations (2021)
    Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    26
    ●
    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
    https://www.oracle.com/events/live/mysql-heatwave-innovations/
    

    View Slide

27. Resources
    Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
    27
    MySQL Database Service & MySQL HeatWave starter kit
    • 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
    • Documentations
    – https://docs.cloud.oracle.com/en-us/iaas/mysql-database/index.html
    – https://www.oracle.com/mysql/
    • MySQL Database Service - Ebook
    – https://www.oracle.com/a/ocom/docs/mysql/mysql-database-service-ebook.pdf
    • HeatWave – A MySQL cloud feature to speed up your queries
    – http://dasini.net/blog/2021/04/13/heatwave-a-mysql-cloud-feature-to-speed-up-your-queries/
    • Data Migration from MariaDB to MySQL
    – http://dasini.net/blog/2022/03/09/data-migration-from-mariadb-to-mysql/
    • Create, Manage and Connect to MySQL Database Service using OCI Service Operator for Kubernetes
    – https://mysqlsg.blogspot.com/2021/09/create-manage-and-connect-to-mysql.html
    • MySQL Database Service - Infographic
    – https://www.oracle.com/a/ocom/docs/mysql/mysql-database-service-infographic.pdf
    

    View Slide

28. Follow us on Social Media
    28
    

    View Slide

29. Merci!
    Q&R
    Olivier Dasini
    MySQL Cloud Principal Solutions Architect EMEA
    olivier.dasini@oracle.com
    Blogs : www.dasini.net/blog/en
    : www.dasini.net/blog/fr
    Linkedin : www.linkedin.com/in/olivier-dasini
    Twitter : @freshdaz
    

    View Slide

30. View Slide