Documentation Home
MySQL HeatWave on AWS
Download this Manual
PDF (US Ltr) - 1.1Mb
PDF (A4) - 1.1Mb


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

3.3.1 Stopping, Starting, or Restarting a DB System

When you create a DB System, it is started automatically, so the Start button is disabled when you first see it. A running DB System shows the state Active (see Section 3.4.1, “MySQL DB System Details” for more information on the DB System states).

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

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

Note

Start, stop, or restart operations on a DB System also affect an associated HeatWave Cluster. When a HeatWave Cluster is stopped as a result of a stop or restart operation on the DB System, any data that was loaded in the HeatWave Cluster must be reloaded when the HeatWave Cluster is restarted.

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 choose the Start, Stop, or Restart button at the top of the list.

    • Click the name of the DB System to open the DB System Details page. On this page you can stop, start, or restart the DB System using the same set of buttons.

  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.