MySQL HeatWave is designed as a pluggable engine for the DB System. You can manage the DB System and MySQL HeatWave Cluster using the same interface. This native integration provides a unified data management platform for Online Transaction Processing (OLTP), Online Analytical Processing (OLAP), machine learning, generative AI, and Lakehouse workloads.
MySQL HeatWave supports multiple ways of managing the service:
Using a web-based cloud console.
Using a command-line interface.
Using REST API. The Oracle Cloud Infrastructure APIs are typical REST APIs that use HTTPS requests and responses.
For more information, see the Ways to Access MySQL HeatWave Service section in OCI Service Guide and AWS Service Guide, and see the Connecting to MySQL HeatWave section in the Oracle Database Service for Azure documentation.
Clients and applications connect with MySQL HeatWave via the DB System, which is a MySQL instance, utilizing standard tools and ODBC/JDBC connectors. MySQL HeatWave complies with the same ANSI SQL standard and ACID properties as MySQL, supporting the most commonly used data types. This compatibility allows existing applications to leverage MySQL HeatWave without any modifications, facilitating quick and easy integration.
For more information, see Section 2.5, “Connect to the MySQL HeatWave DB System”.
Learn more about the supported cloud platforms from where you can access and manage MySQL HeatWave.