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 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.
    Note

    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.
  • Database version: Select the version of the DB system. See MySQL Server Versions and DB System Upgrades.
    Note

    When creating an Always Free DB system, you cannot choose the version. It is always created with the highest version.
    Note

    When restoring a DB system combined with HeatWave cluster, you cannot choose a version. It defaults to the version of the DB system when the backup is taken. If needed, you can upgrade the DB system and HeatWave cluster after the restore has completed.

Advanced Option: Connections

Use the Connections tab of the Create DB system or Restore to a new DB system panel to configure the Primary endpoint and Security Certificate details.

Primary endpoint:

  • Hostname: (Optional) Specify the hostname for the primary endpoint of 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.
  • Database port: (Optional) Specify the port on which the server listens. The default database port is 3306.
  • Database 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 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.
    Note

    You cannot disable crash recovery on an Always Free DB system.

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 or Restore to a new DB system panel to enable or disable Database Management.

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

    You cannot enable database management on an Always Free DB system.

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

      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