Enable Database Management for HeatWave
Database Management is automatically enabled for a DB system when it's created in the HeatWave service. If Database Management is not enabled for a HeatWave DB system, you can enable it in the HeatWave service interface or on the MySQL DB systems page in Database Management.
For information on how to:
- Ensure that Database Management is enabled when creating a new DB system in the HeatWave service, see Advanced Option: Management.
- Enable Database Management for a DB system in the HeatWave service, see Enabling or Disabling Database Management.
Note that before you enable Database Management for a DB system in the HeatWave service or on the MySQL DB systems page in Database Management, you must ensure that you have the required permissions. For information, see Permissions Required to Enable Database Management for HeatWave.
To enable Database Management for HeatWave DB systems on the MySQL DB systems page:
- Sign in to the Oracle Cloud Infrastructure console.
- Open the navigation menu, click Observability & Management. Under Database Management, click Administration.
- On the left pane, click MySQL Databases, select a compartment
in the Compartment drop-down list and
HeatWave in the Deployment type
filter.
The Heatwave DB systems in the compartment are listed. To further filter the list of Heatwave DB systems to only view those without Database Management enabled, use the Management status filter on the left pane.
- In the Management status column, click Enable Database Management for the HeatWave DB system.
- In the Database Management panel, select a Database Management monitoring option for HeatWave DB
systems:
- Full monitoring: This option includes advanced Database Management monitoring features at an additional cost. In addition to the features available as part of the Basic monitoring option, the Full monitoring option includes the full set of advanced monitoring metrics, Performance Hub, replication monitoring, and other features.
- Basic monitoring: This option is available at no additional cost and includes fleet management, basic monitoring metrics, SQL monitoring in Performance Hub, and configuration variable monitoring.
- Click Submit.
A confirmation message with a link to the Work requests page is displayed. Click the Work Request link to monitor the progress of the work request. After Database Management is successfully enabled, Enabled (<monitoring option>) is displayed in the Management status column.
You can click Manage in the Management status column to perform the following tasks in the Database Management panel:
- Change the monitoring option selected when enabling Database Management.
Note
When Database Management is automatically enabled for a new DB system in the HeatWave service, the Basic monitoring option is selected by default. However, you can click Manage and change the monitoring option to Full monitoring. - Disable Database Management.