Advanced Options
Use the Advanced options on the Create DB system, Edit DB system, and Restore to a new DB system panels to configure a DB system.
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.
Related Topics
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:
For example:<hostname>.<subnet DNS label>.<VCN DNS label>.oraclevcn.com
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
.
Related Topics
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.
Related Topics
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.
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.
Related Topics
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