Oracle Database Service for Azure portal lets you provision a HeatWave Cluster, consisting of a MySQL database system and one or more HeatWave nodes.

1. Use your Azure account credentials to login to the OracleDB for Azure portal.
2. Do either of the following:
   • Select the Create a resource icon. In the Create a resource blade, click Create under Oracle MySQL HeatWave Cluster.
   • Select the Oracle MySQL HeatWave Cluster icon. In the Oracle MySQL HeatWave Cluster blade, click Create.
3. On the Basics tab in the Create Oracle MySQL HeatWave Cluster blade, enter the basic information for this Oracle MySQL HeatWave Cluster deployment.

   Figure 1-109 Create Oracle MySQL HeatWave Cluster - Basics Tab

   
   

   
   

   
   
   You can click the Review + create button at any time. When you do, OracleDB for Azure checks whether you have filled in all the required settings, and alerts you if any are missing.
   1. Under Project details, for Subscription, select any subscription that has been linked to your OCI tenancy through OracleDB for Azure. If you do not have any subscription, see Manage OracleDB for Azure Subscriptions. If you only have a single subscription, you cannot change the value in this field. If you have multiple subscriptions linked to your OCI tenancy, you can change the default value for this field following the instructions in Setting Account UI Settings.
   2. For Resource group, select the resource group that contains your Azure VNet. For more information on resource groups, see Microsoft Azure Resource Groups.
   3. Under Instance details, for Database system name, enter a name for the MySQL database system that manages the HeatWave Cluster. The name must be unique for your subscription.
   4. For Description, you can optionally add details about the database system. This description is displayed in the overview page for the deployment.
   5. For Region, select the region where you want Oracle MySQL HeatWave Cluster to be provisioned. If you only have a single region configured in OracleDB for Azure, you cannot change the value. If you have multiple regions configured, you can change the default value following the instructions in Setting Account UI Settings. To view the regions where OracleDB for Azure is available, see Regional Availability.
4. Select the Next: Configuration > button to open the Configuration tab. On this tab, you can configure the database system and (optionally) the nodes in the HeatWave Cluster.

   Figure 1-110 Create Oracle MySQL HeatWave Cluster - Configuration Tab

   
   

   
   

   
   
   1. Under Infrastructure details, for System model (shape), select the shape to use for the MySQL database system from the drop-down list of supported shapes. The shape determines the resources allocated to the database system, and its system configuration.
   2. For Data storage size (GB), specify the amount of storage to allocate to the database system for all data, log files, and temporary files.
   3. For MySQL version, you can optionally select a MySQL Server version for the database system from the list of supported versions. If you don't select one, the most recent MySQL Server version supported by OracleDB for Azure is used.
   4. Under HeatWave details, check the Enable HeatWave Cluster box if you want to create HeatWave nodes now. If you prefer, you can wait until after you have loaded data into the database system, and then create the HeatWave nodes. After the data has been loaded, you can use Oracle MySQL HeatWave Cluster’s MySQL Autopilot feature to estimate a suitable number of nodes.
   5. If you are creating a HeatWave Cluster now, for Node count, specify the number of HeatWave nodes to create. The minimum number of nodes is 1, and the maximum is 64.
   6. For HeatWave shape, select the shape to use for the HeatWave nodes from the drop-down list. The shape determines the resources allocated to each HeatWave node, and their system configuration. See Supported Shapes.
5. Select the Next: Networking > button to open the Networking tab. On this tab, you can configure networking for the Oracle MySQL HeatWave Cluster deployment.

   Figure 1-111 Create Oracle MySQL HeatWave Cluster - Networking Tab

   
   

   
   

   
   
   1. Under Database system networking, for Hostname, you can optionally specify a hostname prefix that OracleDB for Azure prepends to the fully qualified domain name (FQDN) of the endpoint of the database system (the instance FQDN). The hostname prefix must be unique in your subnet or it cannot provision. If you don't specify a hostname prefix, OracleDB for Azure does not create an instance FQDN, and you will need to connect to the database system using its IP address. If you specify a hostname, it must be a unique resolvable hostname for the database system and will be used to connect externally to the system. The hostname must begin with an alphabetic character, can contain only alphanumeric characters and hyphens, and not exceed 12 characters in length.
   2. For Database system IP address, you can optionally specify a private IP address to assign to the endpoint of the MySQL database system. The address must be available within the subnet range of the CIDR blocks that you are going to use for the OCI VCN. If you don't enter one, OracleDB for Azure assigns a private IP address from the address space that you specify (you can find this later in the Connect tab of the deployment's details page). For more information on setting an appropriate range of IP address, see Network CIDR Sizing.
   3. Under Network peering, for Virtual network, select a suitable Azure VNet from the choices available in the resource group that you selected on the Basics tab. You cannot use a VNet that has already been peered with an OCI VCN for Oracle Database Service for Azure.
      If you don’t see the right VNet in the dropdown, the VNet cannot be peered with an OCI VCN due to Azure routing limitations. See Azure VNet Not Displayed in Provisioning Workflow and Virtual Network Overview.
   4. For Network virtual appliance, you can optionally give an IP address in the Azure VNet to be used by a network virtual appliance for traffic management. If you leave this blank, a network virtual appliance is not used. For more information on NVAs, see Deploy highly available NVAs.
   5. For OCI CIDR, specify the address space for OracleDB for Azure to create a subnet in a virtual network (VCN) on Oracle Cloud Infrastructure. OracleDB for Azure will create the subnet and the OCI VCN for you when provisioning Oracle MySQL HeatWave Cluster. You cannot peer an existing OCI VCN with the Azure VNet. For more information on OCI VCNs, see Networking Overview.
      The CIDR blocks must be specified in CIDR notation. The address space must not overlap with the address space for the Azure VNet that you are peering with it - the OCI VCN and the Azure VNet need to have separate address spaces. For more information on setting this properly, see Network CIDR Sizing.
6. Select the Next: Security > button to open the Security tab. On this tab, you can set up the credentials for the MySQL database system administrator account, which you can use to connect to and manage the database system. The administrator account is granted a predefined set of MySQL Server privileges.

   Figure 1-112 Create Oracle MySQL HeatWave Cluster - Security Tab

   
   

   
   

   
   
   1. Under Database system administrator credentials, for Username, specify a username to use for the MySQL database system administrator account.
      The maximum length is 32 characters. The username cannot contain quotes and backticks, and it cannot be any of these reserved names: ocirpl, ociadmin, administrator, mysql.sys, mysql.session, mysql.infoschema.
   2. For Password, specify a password to use for the MySQL database system administrator account.
      The password must be 8 to 32 characters including at least one number, one uppercase letter, one lowercase letter, and one special (nonalphanumeric) character.
   3. For Confirm password, re-enter the password.
7. Select the Next: Management > button to open the Management tab. On this tab, you can choose options for automatic backups, backup deletion, and crash recovery.

   Figure 1-113 Create Oracle MySQL HeatWave Cluster - Management Tab

   
   

   
   

   
   
   1. Under Backup, for Enable automatic backups, check the box if you want Oracle Database Service for Azure to create scheduled backups for the MySQL database system. Backups require storage during the retention period. Enabling this feature also enables crash recovery. You can also enable or disable automatic backups after provisioning.
   2. For Backup retention period, select a number of days for each automatic backup to be retained.
   3. For Window start time, specify the start of the time period during which the MySQL database system will be backed up automatically.
   4. Under Deletion plan, check the box for any deletion protection feature that you want to apply. By default, all these features are disabled:
      • Delete protected prevents deletion of the MySQL database system unless you disable the feature in the settings for this database system.
      • Retain automatic backups keeps automatic backups after the MySQL database system is deleted. If you leave this box unchecked, they are deleted along with the database system.
      • Require final backups creates a final backup before deleting the database system. By default, the final backup is not created.
   5. Under Enable Crash Recovery, check the box if you want to protect the database system against data loss in the event of an unexpected server exit. You can disable this feature to increase the performance of large data imports. Disabling crash recovery disables automatic backups.
8. Select the Next: Tags > button to open the Tags tab. On this tab, you can enter any tags that you want to use to categorize this deployment. Any tags created here are applied to OCI provisioned resources. For more information on tags, see Tagging Overview.
9. Select the Next: Review + create > button to open the Review + create tab, and review the settings that you have selected. The Create Oracle MySQL HeatWave Cluster function checks whether you have filled in all the required settings, and alerts you if any setting is missing or is invalid.
   1. If you need to add or change any settings, go back to the relevant tab by selecting it or by using the Previous button.
   2. If your settings are all as you want them, click the Create button.
   3. If you want to cancel provisioning, select the X (close) icon or use the breadcrumbs or the menu to return to the OracleDB for Azure portal.
10. When you select the Create button, the provisioning process is queued. You can track its progress from the Deployments blade (select the Deployments icon on the OracleDB for Azure portal).
11. To see details about your deployment and access its actions and settings, you can select Go to resource from the deployment details page, or select its name from the list on the Oracle MySQL HeatWave Cluster blade.