$30 off During Our Annual Pro Sale. View Details »

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 olivier.dasini@oracle.com Blogs : www.dasini.net/blog/en : www.dasini.net/blog/fr Linkedin: www.linkedin.com/in/olivier-dasini Twitter : @freshdaz
  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
  3. Copyright © 2022, Oracle and/or its affiliates. All rights reserved.

    3 MySQL 3 The world’s most popular open source database
  4. MySQL powers Open Source applications Copyright © 2022, Oracle and/or

    its affiliates Custom Apps Development Content management and eCommerce Learning platforms 4
  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
  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
  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
  8. MySQL Database Service - Highlights Copyright © 2022, Oracle and/or

    its affiliates. All rights reserved. 8 100% developed, managed, and supported by Oracle MySQL
  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
  10. Copyright © 2022, Oracle and/or its affiliates. All rights reserved.

    10 MySQL HeatWave 10 In-Memory Query Accelerator
  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
  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
  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
  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
  15. 15 Let me show you... MySQL HeatWave dramatically speeds up

    analytic queries LIVE DEMO Analytics Dashboard Copyright © 2022, Oracle and/or its affiliates
  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/
  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
  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
  19. Copyright © 2022, Oracle and/or its affiliates In-database machine learning

    with MySQL HeatWave Accelerate ML initiatives, increase security, and reduce costs 19
  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
  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
  22. Copyright © 2022, Oracle and/or its affiliates HeatWave ML vs

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

    Redshift ML: Benchmarks 2/3 23
  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
  25. Copyright © 2022, Oracle and/or its affiliates. All rights reserved.

    25 MySQL HeatWave 25 Wrap-up
  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
  27. Copyright © 2022, Oracle and/or its affiliates MySQL HeatWave -

    OLTP + OLAP + ML Example : Banking data valorization made easy 27
  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
  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
  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/
  31. Copyright © 2022, Oracle and/or its affiliates. All rights reserved.

    31 Resources
  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
  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
  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/
  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/
  36. Copyright © 2022, Oracle and/or its affiliates. All rights reserved.

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

    37 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
  38. None