Importing Data to Oracle HeatWave
Use MySQL Shell to connect to the database system and import your data to Oracle HeatWave with MySQL Shell's dump and dump loading utilities.
For instructions to set up client connections to a database system and to install MySQL Shell, see Connecting to Oracle HeatWave.
Here's a summary of a process with Oracle Database Service for Azure to export data from a local MySQL server instance, and import it to the database system for the HeatWave Cluster:
- On your local network, use one of MySQL Shell's dump utilities to export the data from the MySQL server instance to a set of local dump files. Apply the compatibility options for MySQL Database Service.
- Transfer the dump files with your preferred file transfer method to an Azure VM that can connect to the database system.
- On the Azure VM, use MySQL Shell's dump loading utility to import the dump files to the database system, then use Oracle HeatWave's Auto Parallel Load feature to load the data into the HeatWave nodes.
If you want to try out this process with sample dump files already created by MySQL Shell's dump utilities, you can use the
airportdb
download (approximately 640MB in size). To download and unpack it, use these commands:
wget https://downloads.mysql.com/docs/airport-db.tar.gz
tar xvzf airport-db.tar.gz
or:
wget https://downloads.mysql.com/docs/airport-db.zip
unzip airport-db.zip
On Windows, use the URL given to download the Zip archive. Unpacking the compressed tar or Zip archive results in a directory named airport-db
, which contains the data files.
Here are the process steps in detail:
Now that the data has been imported to the database system, you can use HeatWave Autopilot to estimate a suitable number of HeatWave nodes for the HeatWave Cluster. See Provisioning HeatWave Nodes for instructions.