Advanced Options
Use the Advanced Options on the Create 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 your 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.
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.
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 define the the time and day to carry out essential maintenance on your 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.
Related Topics
Advanced Option: Networking
Use the Networking tab of the Create DB System or Restore to a new DB System panel to configure the hostname, IP Address, MySQL Port, and MySQL X Protocol Port of your DB system.
- Hostname: (Optional) Specify the hostname for your 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.
- 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.
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
MySQL Database 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