Creating a DB System

Use the Console to create a DB system.

1. On the DB systems list page, select Create DB system. If you need help finding the list page, see Listing DB Systems - Using the Console.
2. Select one of the following:
   • Production: Set up a high availability DB system with the following default values suitable for a production environment.
   • Development or testing: Set up a standalone DB system the following default values suitable for a development or testing environment.
   See Create DB System Template for the template defaults.
3. Provide DB system information:
   • Create in compartment: If you want to launch the DB system in a compartment other than the current one, select the compartment from the list.
   • Name: Specify a display name for the DB system. The name need not be unique. An Oracle Cloud Identifier (OCID) uniquely identifies the DB system.
   • Description: (Optional) Specify a description of the DB System and its purpose.
4. Create Administrator credentials:
   • Username: Specify the user name of the administrator. See Reserved Usernames. The Administrator has a specific set of privileges that differs from the root user. See Default MySQL Privileges.
   • Password: Specify the administrator password.
   • Confirm password: Confirm the administrator password.
5. Select the type of DB system:
   • Standalone: Select for a single-instance DB system.
   • High availability: Select for a three-instance DB system that contains one primary instance and two secondary instances. If you select a regional subnet, the instances are spread across the availability domains. If you do not select a regional subnet, or your region comprises a single availability domain, the instances are spread across the fault domains. See High Availability.
6. Configure networking:
   • Virtual cloud network: Select the VCN in which you want to create the DB system.
   • Subnet: Select the private subnet of your VCN.
   • Show advanced options: (Optional) Select to configure network security groups.
     • Compartment: Select a compartment in which the network security group is configured.
     • Network security group: Select a network security group that you want to use.
       Note
       
       For the required policies, see Mandatory Policies: Network Security Groups.
     • To add multiple network security groups, select the Another network security group button to add another row.
       Note
       
       You can add up to a maximum of 5 network security groups.
7. Configure placement:
   • Availability domain: For Standalone DB systems, specify the availability domain in which the DB system resides. For high availability DB systems, selecting an availability domain affects instance placement. See High Availability.
   • Choose a fault domain: Choose this option to enable you to select a fault domain. If you do not choose a fault domain, Oracle chooses one for you. See Fault Domains.
8. Configure hardware:
   • Enable HeatWave cluster: Enabled by default. Deselect to create a DB system without HeatWave cluster.
     Note
     
     You can still add a HeatWave cluster to the DB system later if the DB system has a HeatWave cluster supported shape.
   • Shape details: If you want to change the default shape, select Change shape. In the Browse all shapes panel, do the following:
     1. Select the compute model.
        • ECPU: Based on an architecture-agnostic of ECPU with an abstracted measure of CPU cores, memory, and other resources.
        • OCPU: Based on physical core of a processor with hyper-threading enabled. Filter the shapes by selecting the machine type:
          • All types: Displays all available shapes.
          • Virtual machine: Displays the Virtual Machine-based shapes only.
          • Bare metal: Displays the Bare Metal-based shapes only.
          Note
          
          All OCPU shapes are deprecated and are not available to new users created after Sept 5, 2024; existing users can still use them until March 13, 2026.
     2. Select the checkbox to choose a shape. See Supported Shapes.
     3. Select Select a shape.
   • HeatWave cluster configuration: This option is shown when Enable HeatWave cluster is selected. If you want to change the default configuration, select Configure HeatWave cluster and do the following in the Configure HeatWave cluster panel:
     1. Shape details: The shape for the HeatWave nodes. If you want to change the shape, select Change shape to select a shape for the HeatWave nodes. See Supported Shapes.
     2. Node: Specify the number of HeatWave nodes to create. The minimum is 1 node and the maximum depends to the following:
        • HeatWave.Free shape: 1 node
        • HeatWave.32GB shape: 16 nodes
        • HeatWave.512GB or MySQL.HeatWave.VM.Standard shape: 64 nodes
        • HeatWave.512GB or MySQL.HeatWave.VM.Standard shape with Lakehouse enabled: 512 nodes
     3. MySQL HeatWave Lakehouse: Enable query processing on the data residing in Object Storage. Prior to MySQL 8.4.0-u3, MySQL HeatWave Lakehouse is supported on the MySQL.HeatWave.VM.Standard and HeatWave.512GB shapes only. See MySQL HeatWave Lakehouse.
        Note
        
        Prior to MySQL 8.3.0-u2, you must disable point-in-time recovery, high availability, read replicas, and outbound replication in order to enable MySQL HeatWave Lakehouse.
     4. Select Save changes.
   • Storage size: Configure the storage size of the DB system. The data storage size is independent of the shape you select.
     • Initial data storage size (GB): Specify the initial data storage size, in GB, to allocate to the DB system. The value should be greater than 50 and less than 131072.

       The initial storage value has an impact on your ability to increase the storage size later and the performance of the increased storage. See DB System Storage. Also, if you are importing data, ensure you specify sufficient data storage.

     • Automatic storage expansion: Enable automatic data storage expansion when space usage grows near to the database instance Health Monitor read-only limits for any instance in the DB system.
       Note
       
       Automatic storage expansion is enabled by default when high availability is enabled, and it cannot be disabled.
     • Maximum data storage size (GB): Specify the maximum data storage size, in GB, to which the storage size can be expanded. The value must be greater than the initial data storage size.
       Note
       
       Whenever the storage size is expanded, the billing for storage usage will increase accordingly. Use the maximum storage size to prevent cost overrun.
9. Configure backup plan: Select the option to enable automatic backups. If you do not select automatic backups, manage your backups manually. It is recommended to enable automatic backups.
   Backup plan:
   • Backup retention period: (Optional) Specify how many days you want to retain the backup. By default, the DB system retains the backup for seven days.
   • Enable point-in-time recovery: Select the option to enable you to restore a DB system at a point-in-time to a new DB system.
   • Select backup window: Select the option to enable you to select the backup window start time. If you do not enable this option, a default window start time will be chosen based on your region.
     • Window start time: Specify the time (in UTC timezone) when you want to start the backup of your DB system. Your backup starts within 30 minutes of the window start time.
       Note
       
       Do not set the backup window start time too near to the maintenance window start time. The automatic backup cannot start if a conflicting operation such as maintenance or upgrade is currently running. It has to wait until the conflicting operation completes. If the conflicting operation does not complete within two hours of the backup window start time, the automatic backup will be skipped and it will try again in the next backup window in the following day.
     • Show backup windows per region: Select the option to see the default window start time of your region.
   • Soft delete: Select this option to retain the backup to be deleted due to the retention policy in DELETE_SCHEDULED state for 7 additional days before permanently deleting it. This is enabled by default.
   Cross-region copy: Select the option to schedule cross-region copy. If enabled, each automatic backup is copied to selected destination region.

   • Destination region: Select a destination region to which the backup is copied.
   • Backup retention period: (Optional) Specify how many days you want to retain the backup in the destination region. If not defined, the default value is the same as the retention period of the source backup.

   Note
   
   You must have the MYSQL_BACKUP_COPY permission in order to enable cross-region copy. The MYSQL_BACKUP_COPY permission is not included in the mysql-family aggregate resource type. The tenancy must also subscribe to the destination region.
10. Provide contacts for operational notifications and announcements: (Optional) Enter one or more contact emails to receive operational notices and announcements as well as scheduled and unplanned maintenance notifications. Select Add contact to add more contacts. You can add up to a maximum of 10 contacts. Duplicate and invalid email addresses are not allowed.
    Note
    
    Oracle recommends that you set the contact emails so that administrators receive notifications related to the DB system.
11. Show advanced options: Select to open a group of tabs that enable you to further configure the DB system. See Advanced Options.
12. (Optional) To save the resource configuration as a stack, select Save as stack. You can later use the stack to install, configure, and manage the resources through the Resource Manager service. See Managing Stacks.
13. To create the DB system, select Create.

Use the command-line interface to create a DB system with a JSON payload and import data from an Object Storage bucket.

1. Open the command-line interface and run the following command with a JSON payload to create a DB system:

   oci mysql db-system create --from-json file://<File.json>

   The <File.json> file contains the following:

   {
     "adminUsername": "<AdminUsername>",
     "adminPassword": "<AdminPassword>",
     "compartmentId": "<CompartmentOCID>", 
     "configurationId": "<ConfigurationOCID>", 
     "shapeName": "<ShapeName>", 
     "dataStorageSizeInGbs": "<StorageSize>", 
     "description": "<Description>", 
     "displayName": "<DBSystemName>", 
     "hostnameLabel": "<HostName>",
     "availabilityDomain": "<Region>",
     "subnetId": "<SubnetOCID>",
     "backupPolicy": {
       "isEnabled": <Boolean>,
       "retentionInDays": <NumberOfDays>,
       "windowStartTime": "<Time>", 
       "softDelete": "<EnabledOrDisabled>",
       "pitrPolicy": {
         "isEnabled": <Boolean> 
       }, 
       "copyPolicies": [
         {
           "copyToRegion": "<Region>",
           "backupCopyRetentionInDays": <NumberOfDays>
         }
       ]
     },
     "deletionPolicy": { 
       "automaticBackupRetention": "<RetainOrDelete>",
       "finalBackup": "<SkipOrRequire>",
       "isDeleteProtected": <Boolean> 
     },
     "source": {
         "sourceType": "IMPORTURL",
         "sourceUrl": "https://objectstorage.<region>.com/p/<Secret>/n/<Namespace>/b/<BucketName>/o/"
       }
   }

   • adminUsername: Specify the username of the root user of the DB system. Some usernames are reserved and you cannot use them in the definition of a DB system. See Reserved Usernames.
   • adminPassword: Specify the password of the root user of the DB system.
   • compartmentId: Specify the OCID of the compartment in which you create the DB system.
   • availabilityDomain: Specify the name of the availability domain in which you create the DB system.
   • configurationID: (Optional) Specify the OCID of the configuration to apply to the DB system. If you do not define a configuration ID, the DB system uses the default configuration associated with the selected shape. If you define a custom configuration, use the same shape as you define in the request.
   • shapeName: Specify the name of the shape. For example, MySQL.8.
   • subnetId: Specify the OCID of the VCN subnet to which the DB system is attached.
   • dataStorageSizeInGbs: Specify the amount of data storage, in GBs, for the DB system. The value should be greater than 50 and less than 131,072, and ensure you define enough storage to accommodate imported data. The data storage size is independent of the shape you select.
   • hostnameLabel: (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:

     <hostnameLabel>.<subnet DNS label>.<VCN DNS label>.oraclevcn.com

     For example, if you specify a value of myhost for hostnameLabel, on a subnet named myprivatesubnet, on a VCN named myvcn the fully qualified domain name of your DB system is set to the following:

     myhost.myprivatesubnet.myvcn.oraclevcn.com

   • description: (Optional) Specify a brief description of the DB system.
   • displayName: (Optional) Specify the display name of the DB system. If you do not define a display name, Oracle generates one for you in the format mysqldbsystemYYYYMMDDHHMMSS.
   • backupPolicy: (Optional) Specify the container for the backup policy parameters. The following parameters define the schedule for automatic backups of your DB system:
     • isEnabled: Set it to true to enable backups.
     • retentionInDays: Specify the number of days to retain the automatic backups. By default, your data is retained for seven days.
     • windowStartTime: Specify the start of a 30-minute window for your daily automated backups. It uses the UTC timezone in HH:MM format. You can also define offsets, for example: 00:00-08:00, which sets the time to 8 hours behind midnight UTC.
     • softDelete: Enabled by default. Set to DISABLE to disable soft delete.
     • pitrPolicy: Set isEnabled to true to enable point-in-time recovery that restores data from a DB system to a new DB system at a given point-in-time.
     • copyPolicies: Set copyToRegion to the destination region to enable cross region copy of automatic backups. Optionally, set backupCopyRetentionInDays to the number of days to retain the automatic backups in the destination region. If no set, the retention defaults to the same as the source backup.
       Note
       
       You can only specify one copy policy.
   • deletionPolicy: (Optional) Specify the container for the deletion policy parameters:
     • automaticBackupRetention: Set to DELETE to delete any automatic backups created for the DB system when the DB system is deleted. The default is RETAIN which retains all automatic backups created for the DB system when the DB system is deleted.
     • finalBackup: Set to REQUIRE_FINAL_BACKUP to take a backup of the DB system when the DB system is deleted. The default is SKIP_FINAL_BACKUP which does not back up the DB system when the DB system is deleted.
     • isDeleteProtected: Set to true to prevent the DB system from being deleted. The default is false which allows the DB system to be deleted.
   • source: (Optional) Specify the container for the import parameters. The following parameters specify the data import type and source URL:
     • sourceType: IMPORTURL: Specify the import type as a PAR URL.
     • sourceUrl: Specify the Pre-Authenticated Request (PAR) URL for the bucket or bucket prefix.
   • mysqlVersion: (Optional) Specify the version of MySQL to use in your DB system. If you do not specify it, the latest LTS version is used. See DB System Upgrades and MySQL Server Versions.

Use the command-line interface to create a DB system without a JSON payload and import data from an Object Storage bucket.

1. Open the command-line interface and run the following command without a JSON payload to create a DB system:

    oci mysql db-system create 
    -c <CompartmentOCID> 
    --configuration-id <ConfigurationOCID>   
    --shape-name <ShapeName> 
    --availability-domain <Region>
    --subnet-id <SubnetOCID> 
    --admin-username <AdminUsername> 
    --admin-password <AdminPassword> 
    --data-storage-size-in-gbs <StorageSize> 
    --display-name <DBSystemName> 
    --description <Description>
    --hostname-label <HostName> 
    --backup-policy '{ "isEnabled": <Boolean>, "retentionInDays": <NumberOfDays>, "windowStartTime": "<Time>", 
                       "softDelete": "<EnabledOrDisabled>", "pitrPolicy": {"isEnabled": <Boolean>}, 
                       "copyPolicies": [ {"copyToRegion": "<Region>", "backupCopyRetentionInDays": <NumberOfDays>} ] }'
    --deletion-policy '{ "automaticBackupRetention": "<RetainOrDelete>",
                         "finalBackup": "<SkipOrRequire>",
                         "isDeleteProtected": <Boolean>}'
    --source '{"sourceType": "IMPORTURL", "sourceURL":"https://objectstorage.<region>.com/p/<Secret>/n/<Namespace>/b/<BucketName>/o/"}'

   • c: Specify the OCID of the compartment in which you create the DB system.
   • configuration-id: (Optional) Specify the OCID of the configuration to apply to the DB system. If you do not define a configuration ID, the DB system uses the default configuration associated with the selected shape. If you define a custom configuration, use the same shape as you define in the request.
   • shape-name: Specify the name of the shape. For example, MySQL.8.
   • availability-domain: Specify the name of the availability domain in which you create the DB system.
   • subnet-id: Specify the OCID of the VCN subnet to which the DB system is attached.
   • admin-username: Specify the username of the root user of the DB system. Some usernames are reserved and you cannot use them in the definition of a DB system. See Reserved Usernames.
   • admin-password: Specify the password of the root user of the DB system.
   • data-storage-size-in-gbs: Specify the amount of data storage, in GBs, for the DB system. The value should be greater than 50 and less than 131,072, and ensure you define enough storage to accommodate imported data. The data storage size is independent of the shape you select.
   • display-name: (Optional) Specify the display name of the DB system. If you do not define a display name, Oracle generates one for you in the format mysqldbsystemYYYYMMDDHHMMSS.
   • description: (Optional) Specify a brief description of the DB system.
   • hostname-label: (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:

     <hostnameLabel>.<subnet DNS label>.<VCN DNS label>.oraclevcn.com

     For example, if you specify a value of myhost for hostnameLabel, on a subnet named myprivatesubnet, on a VCN named myvcn the fully qualified domain name of your DB system is set to the following:

     myhost.myprivatesubnet.myvcn.oraclevcn.com

   • backup-policy: (Optional) Specify the container for the backup policy parameters. The following parameters define the schedule for automatic backups of your DB system:
     • isEnabled: Set it to true to enable backups.
     • retentionInDays: Specify the number of days to retain the automatic backups. By default, your data is retained for seven days.
     • windowStartTime: Specify the start of a 30-minute window for your daily automated backups. It uses the UTC timezone in HH:MM format. You can also define offsets, for example: 00:00-08:00, which sets the time to 8 hours behind midnight UTC.
     • softDelete: Enabled by default. Set to DISABLE to disable soft delete.
     • pitrPolicy: Set isEnabled to true to enable point-in-time recovery that restores data from a DB system to a new DB system at a given point-in-time.
     • copyPolicies: Set copyToRegion to the destination region to enable cross region copy of automatic backups. Optionally, set backupCopyRetentionInDays to the number of days to retain the automatic backups in the destination region. If no set, the retention defaults to the same as the source backup.
       Note
       
       You can only specify one copy policy.
   • deletion-policy: (Optional) Specify the container for the deletion policy parameters:
     • automaticBackupRetention: Set to DELETE to delete any automatic backups created for the DB system when the DB system is deleted. The default is RETAIN which retains all automatic backups created for the DB system when the DB system is deleted.
     • finalBackup: Set to REQUIRE_FINAL_BACKUP to take a backup of the DB system when the DB system is deleted. The default is SKIP_FINAL_BACKUP which does not back up the DB system when the DB system is deleted.
     • isDeleteProtected: Set to true to prevent the DB system from being deleted. The default is false which allows the DB system to be deleted.
   • source: (Optional) Specify the container for the import parameters. The following parameters specify the data import type and source URL:
     • sourceType: IMPORTURL: Specify the import type as a PAR URL.
     • sourceUrl: Specify the Pre-Authenticated Request (PAR) URL for the bucket or bucket prefix.
   • mysqlVersion: (Optional) Specify the version of MySQL to use in your DB system. If you do not specify it, the latest LTS version is used. See DB System Upgrades and MySQL Server Versions.

{
  "data": {
    "access-mode": "UNRESTRICTED",
    "availability-domain": "nnnn:<region>-AD-1",
    "backup-policy": {
      "copy-policies" : [
         {
            "backup-copy-retention-in-days" : 7,
            "copy-to-region" : "<region>"             
         }
      ],
      "is-enabled": true,
      "pitr-policy": {    
         "is-enabled": true
      },
      "retention-in-days": 7,
      "softDelete": "ENABLED",
      "window-start-time": "00:10",
    },
    "channels": [],
    "compartment-id": "ocid1.compartment.oc1...<alphaNumericString>",
    "configuration-id": "ocid1.mysqlconfiguration.oc1...<alphaNumericString>",
    "crash-recovery": "ENABLED",
    "current-placement": {
      "availability-domain": null,
      "fault-domain": null
    },
    "customer-contacts": null,
    "data-storage": {
      "allocated-storage-size-in-gbs": 50,
      "data-storage-size-in-gbs": 50,
      "data-storage-size-limit-in-gbs": 32768,
      "is-auto-expand-storage-enabled": false,
      "max-storage-size-in-gbs": null
    },
    "data-storage-size-in-gbs": 50,
    "database-management": "DISABLED",
    "database-mode": "READ_WRITE",
    "defined-tags": {
      "Oracle-Tags": {
        "CreatedBy": "<userEmail>",
        "CreatedOn": "2021-06-04T10:02:32.140Z"
      }
    },
    "deletion-policy": {
      "automatic-backup-retention": "DELETE",
      "final-backup": "SKIP_FINAL_BACKUP",
      "is-delete-protected": false
    },
    "description": "This is my DBSystem",
    "display-name": "MyDBSystem",
    "endpoints": [],
    "fault-domain": null,
    "freeform-tags": {},
    "heat-wave-cluster": null,
    "hostname-label": null,
    "id": "ocid1.mysqldbsystem.oc1.iad.<alphaNumericString>",
    "ip-address": null,
    "is-heat-wave-cluster-attached": false,
    "is-highly-available": false,
    "lifecycle-details": null,
    "lifecycle-state": "CREATING",
    "maintenance": {
      "window-start-time": "TUESDAY 06:46"
    },
    "mysql-version": null,   
    "point-in-time-recovery-details": null
    "port": null,
    "port-x": null,
    "read-endpoint": {
      "exclude-ips": [],
      "is-enabled": false,
      "read-endpoint-hostname-label": null,
      "read-endpoint-ip-address": null
    },
    "secure-connections": {
      "certificate-generation-type": "SYSTEM",
      "certificate-id": null
    },
    "shape-name": "MySQL.2",
    "source": {
      "source-type": "IMPORTURL",
      "sourceURL":"PARURL"
    },
    "subnet-id": "ocid1.subnet.oc1.iad.<alphaNumericString>",
    "time-created": "2025-04-04T10:02:37.186000+00:00",
    "time-updated": "2025-04-04T10:02:37.186000+00:00"
  },
  "etag": "<alphaNumericString>",
  "opc-work-request-id": "ocid1.mysqlworkrequest.oc1.iad.<alphaNumericString>"
}