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.
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.
See how you can quickly and easily query hundreds of terabytes of data and create machine learning models with MySQL HeatWave Lakehouse on AWS.
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.
Query processing is done entirely within the HeatWave engine, so you can take advantage of MySQL HeatWave Lakehouse for non-MySQL workloads as well as MySQL-compatible workloads.
Price-performance is significantly better.
Automate the pipeline to build, train, deploy, and explain ML models using data in object storage and MySQL Database, without moving the data to a separate ML cloud service and at no additional cost. Interact with HeatWave Lakehouse using natural language.
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.
“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
“Organizations looking for the best value in the cloud data lakehouse landscape must seriously consider MySQL HeatWave Lakehouse.”
“The ability of HeatWave to load and query data on such a massive number of nodes in parallel is the first in the industry.”
“For HeatWave Lakehouse to deliver record performance for both loading data and querying data is an unprecedented innovation in cloud data services.”
“With MySQL HeatWave Lakehouse, Oracle is presenting MySQL customers on AWS and Microsoft Azure with a proposition they may not be able to refuse.”
“MySQL HeatWave Lakehouse can simplify the life of data management professionals and should improve the customer experience.”
“Simply put: MySQL HeatWave Lakehouse enables you to stay ahead of the competition by taking swift action on meaningful business insights.”
“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.”
“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.”
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
Experience MySQL HeatWave Lakehouse at your own pace with step-by-step instructions.
Learn how to query hundreds of terabytes of data in various file formats in object storage using MySQL HeatWave Lakehouse. Discover how simple this process can be with MySQL Autopilot.Start this lab about analyzing data at scale in object storage with MySQL HeatWave Lakehouse
This is your chance to see what it means to be a "data athlete" for SailGP by helping the sailing teams increase their performance. SailGP provides the perfect playground to try out HeatWave Lakehouse; the high-speed, high-tech boats contain more than 800 IoT sensors that generate more than 12,000 data points.Start this lab about winning the race with MySQL HeatWave Lakehouse
Learn from experts as they demonstrate how to use MySQL HeatWave Lakehouse in different scenarios.
Access free step-by-step migration guides outlining best practices, technical training resources, and expert guidance from Oracle engineers and Oracle partners.
Request a free expert-led workshop to evaluate or get started with MySQL HeatWave Lakehouse.
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.