MySQL HeatWave on AWS  /  ...  /  Stopping, Starting, or Restarting a DB System

3.3.1 Stopping, Starting, or Restarting a DB System

A DB System starts automatically after it is created, and the Start button is disabled. A running DB System shows the Active state. For information on DB System states, see MySQL DB System Details.

Restarting a DB System with the Restart button shuts down the DB System, and then restarts it immediately.

Stopping a DB System with the Stop button stops billing for it. However, billing continues for storage. Billing for the DB System resumes when the DB System starts again.

Start, stop, or restart operations on a DB System also affect an associated HeatWave Cluster. When a DB System restarts, the HeatWave Cluster also restarts, and it reloads data from the DB System. See: Data Load Progress and Status Monitoring.

To start, stop, or restart a DB System:

  1. In the MySQL HeatWave Console, select the MySQL tab.

  2. On the DB Systems tab, in the list of DB Systems, find the DB System you want to start, stop, or restart, and do one of the following:

    • Click on the row of the DB System to highlight it, and then click the Start, Stop, or Restart button.

    • Click the name of the DB System to open the DB System Details page, and then click the Start, Stop, or Restart button.

  3. When you select Stop or Restart, the Stop/Restart MySQL DB System dialog is displayed for you to choose the shutdown type:

    • Slow flushes dirty pages and purges undo log pages for older transactions. The shutdown itself can take longer, but the subsequent startup is faster.

    • Fast flushes dirty pages before shutting down the DB System. Some flush operations must be performed during next startup, potentially increasing the duration of the startup process.

    • Immediate does not flush dirty pages and does not purge any undo log pages. Stops MySQL immediately. Page flushes and log purging will take place during the next startup, increasing the duration of the startup process.

    Select a shutdown type and click the Stop or Restart button, depending on the action you are taking.