Starting, Stopping, or Restarting a DB System

You can start, stop, or restart a DB system.

Using the Console

Use the Console to start, stop, or restart a DB system.

  1. Open the navigation menu, and select Databases. Under MySQL HeatWave, click DB systems.
  2. Choose your compartment from the List scope.
  3. In the list of DB systems, find the DB system you want to start, stop, or restart, and do one of the following:
    • Choose the DB system by selecting the check box. Click the Actions button at the top of the page.
    • Click the Actions menu present on the same line as your DB system.
    • Click the name of the DB system to open the DB system details page.
  4. Click one of the following:
    • Start: Start a stopped DB system. After the DB system is started, the Stop action is enabled, and the Start option is disabled.
    • Stop: Stop a running DB system. After the DB system is powered off, the Start action is enabled.
    • Restart: Shut down a DB system, and restart it.
      Note

      After you restart a DB system, the data is automatically loaded in the HeatWave cluster.
  5. If you click Stop or Restart, the Stop (or Restart) DB system dialog box is displayed. Select one of the following shutdown types:
    • Fast: Flush dirty pages before shutting down the DB System. The DB system performs some flush operation during the next startup, increasing the duration of the startup.
    • Slow: Flush dirty pages and purge undo log pages for older transactions. The shutdown itself can take longer, but the subsequent startup is faster.
    • Immediate: Does not flush dirty pages and does not purge any undo log pages. It stops MySQL DB System immediately. Page flushing and log purging happen during the next startup, increasing the duration of the startup.
  6. Click the Stop or Restart button, depending on the intended action.