MySQL HeatWave Lakehouse

MySQL HeatWave Lakehouse allows you to query data in object storage, MySQL databases, or a combination of both with record speed—and automatically build, train, run, and explain machine learning (ML) models. It’s available on Oracle Cloud Infrastructure (OCI), Amazon Web Services (AWS), and Microsoft Azure.

First Principles: Inside MySQL HeatWave Lakehouse on OCI

Discover the novel techniques that power MySQL HeatWave Lakehouse, enabling users to process and query as much as half a petabyte of data in object storage.

Demo: MySQL HeatWave Lakehouse on AWS

See how you can quickly and easily query hundreds of terabytes of data and create machine learning models with MySQL HeatWave Lakehouse on AWS.

Demo: MySQL HeatWave Lakehouse performance

Check out query performance and price-performance comparisons from McKnight Consulting Group's 100 TB TPC-H benchmark of MySQL HeatWave Lakehouse versus Snowflake, Amazon Redshift, Databricks, and Google BigQuery.

How MySQL HeatWave Lakehouse works

MySQL HeatWave Lakehouse processes data in a variety of file formats, such as CSV, Parquet, Avro, and exports from other databases. You can query data in object storage and, optionally, combine it with transactional data in MySQL databases. Applications can use large language models to interact with HeatWave Lakehouse in natural language. Data loaded into the HeatWave cluster for processing is automatically transformed into the HeatWave in-memory format, and object storage data is not copied to the MySQL database. You can also take advantage of HeatWave AutoML, a built-in feature that automates the pipeline to build, train, deploy, and explain ML models using data in object storage, the database, or both. No need to move the data to a separate ML cloud service. No need to be an ML expert.

How MySQL Heatwave Lakehouse works diagram, details below:
Transactional data in MySQL Database as well as object storage data in a variety of file formats, such as CSV, Parquet, Avro, and exports from other databases is replicated in real-time into the HeatWave Cluster, enabling customers to get real-time analytics across all this data. Since machine learning capabilities are built in HeatWave, customers can also use data from the database and object storage to build, train, deploy, and explain machine learning models.

Customer perspectives on MySQL HeatWave Lakehouse

  • “HeatWave Lakehouse scales out very well for loading data from object storage and for running queries on object store. The load time and the query times are nearly constant as the size of the data grows and the HeatWave cluster size grows correspondingly. This scale out characteristic of HeatWave Lakehouse for data management is key to efficiently processing very large amounts of data.”

    —Henry Tullis, Leader, Cloud Infrastructure and Engineering, Deloitte Consulting

  • “Data is growing exponentially and so is the amount of data we store in our data lake. The ability to use standard MySQL syntax to query data across our database and object storage to get real-time insights is very important for Natura. This opens up new opportunities to explore and could represent new competitive advantages if we can analyze all this data faster than our competition.”

    —Fabricio Rucci, Solution Architect at Natura &Co

  • “HeatWave Lakehouse allows us to easily and quickly load data on object storage into HeatWave and combine it with MySQL data for analysis.”

    —Takashi Kinoshita, Chief Producer, e-Book Division, NTT SOLMARE Corporation

See what top industry analysts say about MySQL HeatWave Lakehouse

  • IDC logo

    “Organizations looking for the best value in the cloud data lakehouse landscape must seriously consider MySQL HeatWave Lakehouse.”

    Carl Olofson
    Research Vice President, Data Management Software, IDC
  • Wikibon logo

    “The ability of HeatWave to load and query data on such a massive number of nodes in parallel is the first in the industry.”

    Marc Staimer
    Senior Analyst, Wikibon
  • The Futurum Group logo

    “For HeatWave Lakehouse to deliver record performance for both loading data and querying data is an unprecedented innovation in cloud data services.”

    Ron Westfall
    Research Director, The Futurum Group
  • Omdia logo

    “With MySQL HeatWave Lakehouse, Oracle is presenting MySQL customers on AWS and Microsoft Azure with a proposition they may not be able to refuse.”

    Bradley Shimmin
    Chief Analyst, AI & Data Analytics, Omdia
  • Moor logo

    “MySQL HeatWave Lakehouse can simplify the life of data management professionals and should improve the customer experience.”

    Matt Kimball
    Vice President and Principal Analyst, Datacenter, Moor Insights & Strategy
  • NAND Research logo

    “Simply put: MySQL HeatWave Lakehouse enables you to stay ahead of the competition by taking swift action on meaningful business insights.”

    Steve McDowell
    Principal Analyst and Founding Partner, NAND Research
  • Constellation Research logo

    “The MySQL team has out-innovated the industry, providing five different core database use cases in a single database, which gives CxOs the peace of mind to have one database that can do it all—a truly universal database.”

    Holger Mueller
    Vice President and Principal Analyst, Constellation Research
  • KuppingerCole logo

    “MySQL HeatWave Lakehouse takes customers to a new level of capabilities: being able to query heterogeneous data across data warehouses and data lakes at petabyte scale using the familiar SQL syntax, while beating popular competitors at query performance, load times, and cost efficiency.”

    Alexei Balaganski
    Lead Analyst & CTO, KuppingerCole Analysts
JULY 20, 2023

Announcing: MySQL HeatWave Lakehouse General Availability

Nipun Agarwal, Senior Vice President, MySQL HeatWave

Today we announced the general availability of MySQL HeatWave Lakehouse and new capabilities in MySQL Autopilot that enable organizations to efficiently query data from object store using standard SQL syntax and without requiring database tuning expertise. With MySQL HeatWave Lakehouse, users can query up to half a petabyte of data from object storage and optionally combine it with transactional data from MySQL database in a single SQL query.

Read the complete post

Get started with MySQL HeatWave Lakehouse

Learn with step-by-step guidance

Experience MySQL HeatWave Lakehouse at your own pace with step-by-step instructions.

Migrate to MySQL HeatWave on OCI or AWS

Access free step-by-step migration guides outlining best practices, technical training resources, and expert guidance from Oracle engineers and Oracle partners.

Free MySQL HeatWave Lakehouse workshop

Request a free expert-led workshop to evaluate or get started with MySQL HeatWave Lakehouse.

Try MySQL Heatwave
Lakehouse for free

Sign up for a free trial of MySQL HeatWave Lakehouse on OCI or AWS. You’ll get US$300 in cloud credit to try the lakehouse, machine learning, and other capabilities of MySQL HeatWave for 30 days.