Supported Shapes

Use the Console to convert a DB system from OCPU to ECPU.

1. Open the navigation menu, and select Databases. Under MySQL HeatWave, click DB systems.
2. Choose your compartment from the List scope.
3. In the list of DB systems, find the DB system you want to convert and do one of the following:
   • Click the name of the DB system.
   • Click the Actions menu present on the same line as your DB system and select View details.
   The DB system details page is displayed.
4. Skip this step if the DB system does not have a HeatWave cluster attached to it.
   1. Do either of the following:
      • In the DB system information tab, under HeatWave cluster, besides the HeatWave cluster field, click Edit.
      • Under Resources, click HeatWave cluster, and then click Edit in the HeatWave cluster information frame.
   2. In the Edit HeatWave cluster panel, under Configure HeatWave cluster, do the following:
      • Select a shape: Click Change shape.
      • Select the shape of the HeatWave cluster, and click Select a shape.
        Note
        
        You must select a HeatWave capacity shape: either HeatWave.32GB or HeatWave.512GB. The MySQL.HeatWave.VM.Standard shape is equivalent to HeatWave.512GB.
   3. Click Save changes.
   The HeatWave cluster enters the Updating state. Wait until the update completes and the state of the HeatWave cluster becomes Active before continuing with the next step.
5. At the top of the DB system details page, click Edit.
   The Edit DB system is displayed.
6. In the Edit DB system panel, do the following:
   1. To apply the recommended shape and configuration:
      1. In the notification banner, review the recommended shape and configuration, then click Apply recommendation.
      2. In the Apply migration recommendation dialog, click Apply recommendation.
      Applying the recommendation updates the shape and configuration fields and disables manual selection.

      Note
      
      If the DB system uses a custom configuration, a new custom configuration based on the recommended shape is created when the update is applied to the DB system after you save the changes.
   2. To select a shape and configuration manually:
      1. In Select a shape, click Change shape to change the shape of the DB system.
      2. Select an ECPU shape for the DB system, and click Select a shape.
         Note
         
         You should choose an ECPU shape that has similar resources as the current OCPU shape.
      3. In Select a configuration, click Change configuration to change the configuration of the DB system.
      4. Select a configuration for the DB system, and click Select a configuration.
         Note
         
         If the DB system has high availability enabled, you must select a high availability compatible configuration. The default high availability configuration has a suffix HA.
      5. Check the differences in the current and newly selected configuration in the Compare configurations frame.
         Note
         
         If there are big differences, you can create a new custom configuration with the new ECPU shape to match the values of the variables in the current configuration.
   3. Click Save changes.
   The DB system enters the Updating state. Wait until the update completes and the state of the DB system becomes Active.

   Note
   
   Any read replica that inherits the shape from the DB system will also have the shape converted. The read replicas, if any are first converted in sequence before the DB system is converted. For high availability DB system, a rolling update is performed to reduce downtime.
7. Skip this step if the DB system does not have any read replica overriding the DB system shape. Do the following for each read replica that does not inherit the DB system shape:
   1. Under Resources in the DB system details page, click Read replicas.
   2. Click the name of the read replica to open the Read replica details page.
   3. If the read replica has an OCPU shape, do the following:
      • Click Edit.
      • In Shape details, click Change shape to change the shape of the read replica.
      • Select an ECPU shape for the DB system, and click Select a shape.
      • Click Show advanced options.
      • Click the Configuration tab.
      • In Select a configuration, click Select configuration to change the configuration of the read replica.
      • Select a configuration for the read replica, and click Select a configuration.
      • Click Save changes.
      The read replica enters the Updating state. Wait until the update completes and the state of the read replica will become Active.
   4. Click DB system details on the breadcrumb at the top of the page to view the DB system details page. Repeat the steps for the next read replica, if any.

Use the command-line interface to convert a DB system from OCPU to ECPU.

1. If the DB system has a HeatWave cluster with a HeatWave node shape (such as MySQL.HeatWave.VM.Standard) attached to it, run the following to change the HeatWave cluster shape to a HeatWave capacity shape:

   oci mysql db-system heatwave-cluster update  
    --db-system-id <DBSystemOCID>
    --shape-name <ShapeName> 
    

   • db-system-id: Specify the OCID of the DB system.
   • shape-name: Specify a HeatWave cluster capacity shape.
     Note
     
     You must select a HeatWave capacity shape: either HeatWave.32GB or HeatWave.512GB. The MySQL.HeatWave.VM.Standard shape is equivalent to HeatWave.512GB.
   You will get a response with the OCID of the work request when the operation has started.

   {
     "opc-work-request-id": "ocid1.mysqlworkrequest.<alphaNumericString>"
   }

   You need to wait until the process has completed before continuing with the following step. It takes about 15 minutes to complete, only the HeatWave cluster is not available, the DB system is still online. You can run the following to check the status of the operation:

   oci mysql work-request get --work-request-id <WorkRequestOCID> |jq .data.status

   When it returns "SUCCEEDED", the operation has completed and you can continue with the following step.
2. Run the following to change the shape of the DB system to use ECPU shape:
   Note
   
   Any read replica that inherits the DB system shape will be converted at the same time.

   oci mysql db-system update  
    --db-system-id <DBSystemOCID>
    --shape-name <ShapeName>
    --configuration-id <ConfigurationOCID>
    

   • db-system-id: Specify the OCID of the DB system.
   • shape-name: Specify an ECPU shape name. See ECPU Shapes.
   • configuration-id: Specify the OCID of a valid configuration of the shape.
     Note
     
     Ensure that the configuration matches the shape. If the DB system has high availability enabled, you must specify a high availability compatible configuration. The name of the default high availability configuration has a suffix HA.
   You will get a response with the OCID of the work request when the operation has started.

   {
     "opc-work-request-id": "ocid1.mysqlworkrequest.<alphaNumericString>"
   }

   You need to wait until the process has completed before continuing with the following step. For Standalone DB system, it takes about 15 to 30 minutes to complete, the DB system is not available for the whole duration. For High availability DB system, it takes about 60-80 minutes to complete, the DB system incur a short downtime of less than 1 minute around 2/3 into the process. Each read replica that inherits the DB system shape will required additional 15 minutes. You can run the following to check the status of the operation:

   oci mysql work-request get --work-request-id <WorkRequestOCID> |jq .data.status

   When it returns "SUCCEEDED", the operation has completed and you can continue with the following step.
3. If the DB system has any read replica with overridden shape, run the following on each read replica that has an OCPU shape:

   oci mysql replica update  
    --replica-id <ReadReplicaOCID>
    --replica-overrides '{"shapeName": "<ShapeName>", "configurationId": "<ConfigurationOCID>"}' 
    

   • replica-id: Specify the OCID of the read replica.
   • replica-overrides: Specify a JSON object containing the following key-value pairs:
     • shapeName: Specify an ECPU shape name.
     • configurationId: Specify the OCID of the configuration.
       Note
       
       Ensure that the configuration matches the shape.
   You will get a response with the OCID of the work request when the operation has started.

   {
     "opc-work-request-id": "ocid1.mysqlworkrequest.<alphaNumericString>"
   }

   It takes about 15 minutes to complete, the read replica that is being updated is not available, the DB system and other read replicas, if any are online. You can run the following to check the status of the operation:

   oci mysql work-request get --work-request-id <WorkRequestOCID> |jq .data.status

   When it returns "SUCCEEDED", the operation has completed

   You can do this on one read replica at a time so that other read replicas remain available to serve read operations. Repeat this step on the next read replica that has an OCPU shape.

Use the backup and restore method to convert a DB system from OCPU to ECPU.

1. (Optional) Stop the DB system to prevent and data updates. See Starting, Stopping, or Restarting a DB System.
2. Take a manual backup of the DB system. See Creating a Manual Backup.
3. Restore the backup to a new DB system. See Restoring From a Backup.
   Note
   
   Select an ECPU shape and a corresponding configuration for the new DB system. If the DB system has a HeatWave cluster, select a HeatWave capacity shape (HeatWave.32GB or HeatWave.512GB) for the HeatWave cluster.
4. (Optional) Add read replicas as required. See Creating a Read Replica.
   Note
   
   The read replica can inherit the ECPU shape from the DB system or override the DB system shape with another ECPU shape.