Advanced Options

Advanced Option: Deletion Plan

Use the Deletion plan tab of the Create DB system, Edit DB system, or Restore to a new DB system panel to select the deletion plan for your DB system.

  • Delete protected: Protects your DB system against delete operations. To enable you to delete your DB system, disable the option. By default, DB systems are not delete protected.
    Note

    Enabling the Delete protected option prevents you to select the other options present on the Deletion plan tab.
  • Retain automatic backups: Retains automatic backups after you delete the DB system. By default, automatic backups are deleted when you delete the DB system.
  • Require final backup: Creates a final backup before deleting the DB system. By default, the final backup is not created.

Related Topics

Advanced Option: Configuration

Use the Configuration tab of the Create DB system, Edit DB system, or Restore to a new DB system panel to select the configuration for the shape of the DB system.

  • Select configuration: (Optional) Enable you to change the default configuration available with the selected shape:
    • In the Edit DB system panel, when you click Change configuration, you can see the Compare configurations section that displays the differences in the user variables between the current and the selected configuration. If the two configurations differ in dynamic variables only, the configuration is updated without restarting the database. Changes to variables that are not dynamic restart the database, and the Console displays a warning.
    • You can select a Standalone configuration with a highly available (HA) DB system. However, it is recommended that you accept the default HA-specific configuration associated with the selected shape. HA-specific configurations are optimized for HA DB systems. If you intend to use a custom configuration for your HA DB system, ensure it is based on an existing HA-specific configuration.
  • Select a MySQL version: Select the MySQL version of the DB system. See MySQL Server Versions and MySQL Server Upgrades.
    Note

    The option is not available when you edit a DB system.

Advanced Option: Connections

Use the Connections tab to configure Networking details. Networking enables you to configure the hostname, IP Address, MySQL Port, and MySQL X Protocol Port of the DB system.

Security certificate enables you to either let MySQL HeatWave Service define a security certificate, or bring your own certificate to Oracle Cloud Infrastructure.

Networking:

  • Hostname: (Optional) Specify the hostname for the DB system. The option is available only if you enable USE DNS HOSTNAMES IN THIS VCN option on the selected VCN. The hostname must begin with an alphabetic character, contain only alphanumeric characters and hyphens (-), and not use more than 30 characters. The hostname must be unique within the subnet. If it is not unique, the DB system fails to provision. When you specify a hostname, Oracle assigns it to the VCN and subnet domain, which is automatically created during the instance launch, in the following format:
    <hostname>.<subnet DNS label>.<VCN DNS label>.oraclevcn.com
    For example:
    myhost.sub01031036431.myvcn.oraclevcn.com
  • IP address: (Optional) Specify a private IP address to assign to the endpoint of the DB system. The address must be available in the CIDR of the subnet. If you do not specify an IP address, Oracle automatically assigns a private IP address from the subnet.
  • MySQL port: (Optional) Specify the port on which the server listens. The default MySQL port is 3306.
  • MySQL X protocol port: (Optional) Specify the port that is supported by clients such as MySQL Shell. The default value of the port is 33060.

Security certificate:

  • Service defined: Let MySQL HeatWave Service define the security certificate.
  • User defined: Bring your own security certificate to Oracle Cloud Infrastructure. To bring your own certificate, specify the appropriate resource policy. See Resource Principals.
    • Select a security certificate: Select a security certificate from the list of certificates available in the selected compartment.
    • Enter a security certificate OCID: Enter the OCID of the security certificate in the format, ocid[0-9]+.certificate.oc[0-9]+.[region].[0-9a-z]{60}. For example, ocid1+.certificate.oc1.iad.1234567890abcdefghijklmnopqrstuvwxyz1234567890abcdefghijklmn.

Advanced Option: Crash Recovery

Use the Crash recovery tab of the Create DB system or Restore to a new DB system panel to enable or disable crash recovery on the DB system.

  • Enable crash recovery: If you enable crash recovery on the DB system, it protects the DB system against data loss in the event of an unexpected server exit. You can disable it to increase the performance of large data imports. Disabling Crash Recovery disables automatic backups.
    Note

    It is not recommended to disable crash recovery permanently.

Advanced Option: Maintenance

Use the Maintenance tab of the Create DB system, Edit DB system, or Restore to a new DB system panel to define the the time and day to carry out essential maintenance on the DB system.

  • Maintenance window start time: (Optional) Specify the day and time (in UTC timezone) you want to schedule the maintenance activity such as operating system or MySQL instance upgrades. If you do not specify a day and time, Oracle choses it for you. The maintenance starts within two hours of the Maintenance window start time that you define for the DB system.

Related Topics

Advanced Option: Management

Use the Management tab of the Create DB system, Edit DB system, or Restore to a new DB system panel to enable or disable Database Management. By default, Database Management is enabled.

  • Database Management: Enables you to monitor DB systems and obtain meaningful insights from metrics, and use Performance Hub to quickly diagnose performance issues.

Related Topics

Advanced Option: Data Import

Use the Data import tab of the Create DB system panel to import data from a MySQL Shell dump in an Object Storage bucket.

Note

Specify enough data storage to accommodate the imported data.
  • PAR source URL: (Optional) Specify the Pre-Authenticated Request (PAR) URL for the bucket or bucket prefix.
  • Click here to create a PAR URL for an existing bucket: (Optional) Click the link to create a PAR URL for an existing bucket, and provide the following information:
    • Select a bucket in CompartmentName: Select the Object Storage bucket that contains your dump.
    • Configure prefix:
      • Select the prefix: Select the prefix from the list of valid prefixes.
      • Enter a prefix: Select the option to enable you to define a bucket prefix, similar to a folder name. The prefix must exist in the selected bucket. Prefix names take the format prefixName/. Omitting the forward slash delimiter in the PAR results in an invalid URL. You can specify paths with multiple prefixes, prefixName/prefixName1/prefixName2/.
      Note

      MySQL HeatWave supports the folder-type of prefix only. The filename-matching prefix type is not supported.
    • Specify an expiration time for the PAR: Select an expiration time for the PAR. The default value is one week.
    • Create and set PAR URL: Click the option to generate the PAR URL and add it to the PAR source URL option.

Advanced Option: Tags

Use the Tags tab of the Create DB system, Edit DB system, or Restore to a new DB system panel to organize and track resources in your tenancy.

  • Tag namespace: Select the tag name.
  • Tag key: Select the tag key.
  • Tag value: Specify a value for the tag.
  • + Additional tag: Click this option to add more tags.

Related Topics