Importing Data to MySQL HeatWave
Use MySQL Shell to connect to the DB System and import your data to MySQL HeatWave with MySQL Shell's dump and dump loading utilities.
For instructions to set up client connections to a DB System and to install MySQL Shell, see Connecting to MySQL 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 MySQL DB 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 DB System.
- On the Azure VM, use MySQL Shell's dump loading utility to import the dump files to the DB System, then use MySQL 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 MySQL DB System, you can use
MySQL Autopilot to estimate a suitable number of HeatWave nodes for the HeatWave
Cluster. See Provisioning HeatWave Nodes for instructions.