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.
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.
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.
The option is not available when you edit a DB system.
Advanced Option: Connections
Use the Connections tab to configure Networking or Security Certificate details. Networking enables you to configure the hostname, IP Address, MySQL Port, and MySQL X Protocol Port of the DB system.
- 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
<hostname>.<subnet DNS label>.<VCN DNS label>.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.
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.
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.
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.
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,
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.