Changes in MySQL HeatWave 8.0.27-u3 (2021-12-15, General Availability)

Functionality Added or Changed

• Support was added for the CONVERT_TZ() and LAST_DAY() functions, which are used to manipulate temporal values. (WL #14768)

• The MySQL HeatWave Cluster recovery process was optimized to avoid applying a large volume of changelogs during recovery. Snapshots are now taken when the volume of changelogs and the time required to apply those changes exceed specific thresholds, and recovery from Object Storage is performed using those snapshots. (WL #14615)

• MySQL HeatWave now supports automatic data reload when the MySQL HeatWave Cluster is restarted. Previously, when a MySQL HeatWave Cluster was stopped by a stop or restart action, data had to be reloaded manually after the cluster was restarted. Now, when starting or restarting a MySQL HeatWave Cluster, data that was previously loaded is reloaded automatically. Data changes that occur on the DB System while the MySQL HeatWave Cluster is offline are included in the reloaded data.

  Automatic data reload does not occur if the MySQL HeatWave Cluster was stopped as a result of a stop or restart action performed on the DB System to which the MySQL HeatWave Cluster is attached. In this case, data loaded in the MySQL HeatWave Cluster must be reloaded manually after the MySQL HeatWave Cluster is restarted. (WL #14729)