2.9.9 Reloading Data

Reloading data is recommended in the following cases:

• After resizing the cluster by adding or removing nodes. Reloading data distributes the data among all nodes of the resized cluster.

• After a maintenance window. Maintenance involves a DB System restart, which requires that you reload data into HeatWave. On OCI, consider setting up a HeatWave Service event notification or Service Connector Hub notification to let you know when an update has occurred. For information about MySQL DB System maintenance:

  • For HeatWave on OCI, see Maintenance in the HeatWave on OCI Service Guide.

    For HeatWave on AWS, see Maintenance in the HeatWave on AWS Service Guide.

    For HeatWave for Azure, see the Oracle Database Service for Azure documentation.

  • For information about HeatWave Service events, see Managing a DB System in the HeatWave on OCI Service Guide.

  • For information about Service Connector Hub, see Service Connector Hub.

  • For table load instructions, see Section 2.2, “Loading Data to HeatWave MySQL”.

    Tip

    Instead of loading data into HeatWave manually, consider using the Auto Parallel Load utility, which prepares and loads data for you using an optimized number of parallel load threads. See Section 2.2.3, “Loading Data Using Auto Parallel Load”.

• When the HeatWave Cluster is restarted due to a DB System restart. Data in the HeatWave Cluster is lost in this case, requiring reload.