Tweet
Tweet

Slide 1

Slide 1 text

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

Slide 2

Slide 2 text

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

Slide 3

Slide 3 text

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

Slide 4

Slide 4 text

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

Slide 5

Slide 5 text

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

Slide 6

Slide 6 text

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

Slide 7

Slide 7 text

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

Slide 8

Slide 8 text

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

Slide 9

Slide 9 text

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

Slide 10

Slide 10 text

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

Slide 11

Slide 11 text

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

Slide 12

Slide 12 text

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

Slide 13

Slide 13 text

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

Slide 14

Slide 14 text

*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

Slide 15

Slide 15 text

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

Slide 16

Slide 16 text

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/

Slide 17

Slide 17 text

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

Slide 18

Slide 18 text

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

Slide 19

Slide 19 text

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

Slide 20

Slide 20 text

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

Slide 21

Slide 21 text

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

Slide 22

Slide 22 text

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

Slide 23

Slide 23 text

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

Slide 24

Slide 24 text

 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

Slide 25

Slide 25 text

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

Slide 26

Slide 26 text

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

Slide 27

Slide 27 text

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

Slide 28

Slide 28 text

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

Slide 29

Slide 29 text

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

Slide 30

Slide 30 text

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/

Slide 31

Slide 31 text

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

Slide 32

Slide 32 text

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

Slide 33

Slide 33 text

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

Slide 34

Slide 34 text

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/

Slide 35

Slide 35 text

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/

Slide 36

Slide 36 text

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

Slide 37

Slide 37 text

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

Slide 38

Slide 38 text

No content