Creating an Always Free DB System

Use the Console or a command-line interface to create a HeatWave Always Free DB system.

Using the Console

Use the Console to create an Always Free DB system.

  1. Open the navigation menu, and select Databases. Under HeatWave MySQL, click DB systems.
  2. Click Create DB system.
  3. Select Always Free: Sets up a Always Free standalone DB system with recommended defaults. Shape, storage, and HeatWave cluster nodes are restricted.
    • High availability: Not available
    • Shape: A shape with 8GB memory size
    • Storage size: 50GB
    • Automatic backups: Enabled
    • Point-in-time recovery: Not available
    • Delete protected: Enabled
    • Automatic backups retention: Enabled
    • Final backup: Require final backup
  4. 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.
  5. 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.
    Note the username and password of the DB system administrator. You can later change the password using SQL commands such as ALTER USER or SET PASSWORD.
  6. Standalone is selected as the type of DB system. High availability is not available in Always Free DB system.
  7. 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.
  8. Configure placement:
    • Availability domain: The availability domain that contain a service limit of MySQL.Free shape is selected automatically.
    • Fault domain: Oracle chooses a fault domain for you based on available resources.
  9. Configure hardware:
    • DB system shape: MySQL.Free
    • HeatWave shape: HeatWave.Free
      • If you want to enable HeatWave Lakehouse, click the Edit link on the right, click Configure HeatWave cluster, select HeatWave Lakehouse, and click Save changes.
      • If you want to disable the HeatWave cluster, click the Edit link on the right and deselect Enable HeatWave cluster.
    • Storage size: 50 GB
  10. Configure backup plan: The configuration is fixed for an Always Free DB system, and you cannot change it .
    • Enable automatic backups: Enabled.
    • Backup retention period: 1 day.
    • Enable point-in-time recovery: Disabled.
    • Select backup window: Not configurable, Oracle determines the backup window.
  11. Show advanced options: Click to open a group of tabs that enable you to further configure the DB system. See Advanced Options.
  12. To create the DB system, click Create.
  13. (Optional) To save the resource configuration as a stack, click Save as stack. You can later use the stack to install, configure, and manage the resources through the Resource Manager service. See Managing Stacks.
The DB system is created.
Note

If you encounter OutOfHostCapacity work request error while creating a DB system, see Resolving OutOfHostCapacity Error.

Using the CLI

Use the command-line interface to create an Always Free DB system.

This task requires the following:
  • A compartment Oracle Cloud Identifier (OCID).
  • A policy that permits you to create DB systems in the compartment or tenancy.
  • A properly configured CLI installation and the requisite SSH keys. See Command Line Interface.
  • A properly configured VCN. See Creating a Virtual Cloud Network.
  1. Open the command-line interface and run the following command to create an Always Free DB system:
    oci mysql db-system create 
     --compartment-id <CompartmentOCID>
     --shape-name MySQL.Free 
     --subnet-id <SubnetOCID> 
     --availability-domain <AD-Name>
     --admin-username <AdminUsername> 
     --admin-password <AdminPassword>
     --display-name <DBSystemName> 
     --description <Description>
    • compartment-id: Specify the OCID of the compartment in which you create the DB system.
    • shape-name: Specify MySQL.Free as the shape name.
    • subnet-id: Specify the OCID of the VCN subnet to which the DB system is attached.
    • availability-domain: Specify the name of the availability domain which contains a non-zero limit for the MySQL.Free shape.
    • 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.
    • 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.
The command creates an Always Free DB system and you get a response similar to the following, which summarizes the request and creates the DB system:
Note

This does not create a HeatWave cluster together with the DB system, you can add a HeatWave cluster to the DB system after it has been created successfully.
{
  "data": {
    "availability-domain": "<AD-name>",
    "backup-policy": {
      "defined-tags": null,
      "freeform-tags": null,
      "is-enabled": true,
      "pitr-policy": {
        "is-enabled": false
      },
      "retention-in-days": 1,
      "window-start-time": "19:37"
    },
    "channels": [],
    "compartment-id": "ocid1.compartment.oc1..<alphaNumericString>",
    "configuration-id": "ocid1.mysqlconfiguration.oc1..<alphaNumericString>",
    "crash-recovery": "ENABLED",
    "current-placement": {
      "availability-domain": null,
      "fault-domain": null
    },
    "data-storage-size-in-gbs": 50,
    "database-management": "DISABLED",
    "defined-tags": {},
    "deletion-policy": {
      "automatic-backup-retention": "RETAIN",
      "final-backup": "SKIP_FINAL_BACKUP",
      "is-delete-protected": false
    },
    "description": null,
    "display-name": "<DBSystemName>",
    "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": "",
    "lifecycle-state": "CREATING",
    "maintenance": {
      "window-start-time": "THURSDAY 09:06"
    },
    "mysql-version": "9.0.1",
    "point-in-time-recovery-details": null,
    "port": null,
    "port-x": null,
    "secure-connections": {
      "certificate-generation-type": "SYSTEM",
      "certificate-id": null
    },
    "shape-name": "MySQL.Free",
    "source": null,
    "subnet-id": "ocid1.subnet.oc1.iad.<alphaNumericString>",
    "time-created": "2024-08-08T01:37:25.711000+00:00",
    "time-updated": "2024-08-08T01:37:25.711000+00:00"
  },
  "etag": "<alphaNumericString>",
  "opc-work-request-id": "ocid1.mysqlworkrequest.oc1.iad.<alphaNumericString>"
}

Related Topics