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

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

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

4b97b611ee1bb610c24f37506d21e366?s=128

Olivier DASINI

May 05, 2022
Tweet

More Decks by Olivier DASINI

Other Decks in Technology

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
  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
  3. MySQL Copyright © 2022, Oracle and/or its affiliates. All rights

    reserved. The world’s most popular open source database 3
  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
  5. MySQL Database Service Copyright © 2022, Oracle and/or its affiliates.

    All rights reserved. A fully managed cloud service 5
  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
  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
  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
  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
  10. MySQL Database Service Copyright © 2022, Oracle and/or its affiliates.

    All rights reserved. 10 Allows you to save time and money
  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
  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
  13. MySQL HeatWave MySQL in-Memory Query Accelerator Copyright © 2022, Oracle

    and/or its affiliates. All rights reserved. 13 13
  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
  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.
  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
  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
  18. Example : Loan Approval MySQL HeatWave – OLTP + OLAP

    + ML 18 Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
  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.
  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.
  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
  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
  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
  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/
  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/
  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/
  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
  28. Follow us on Social Media 28

  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
  30. None