Step-by-step Provisioning of MySQL Heatwave Database in OCI | Create Compartment, VCN, Policy, Security List in Oracle Cloud

Introduction:

In this article, I will show you how to provision MySQL Heatwave database in Oracle Cloud. You will also learn-

1. How to create a compartment.
2. How to create policy for the compartment.
3. How to create VCN.
4. Configure security list(Ingress Rules) to allow MySQL incoming connections
5. Provisioning Heatwave DB systems

Before getting into it. Here is the quick brief of MySQL Heatwave-

MySQL HeatWave Database Service is a fully managed service, running on Oracle Cloud Infrastructure. It enables you to:

• Instantly provision MySQL instances and connect to a production ready, pre-configured MySQL database.
• Automate database specific tasks such as configuration, security patching, backup, high availability, and monitoring.
• Choose from multiple compute shapes, depending on your application and capacity requirements.
• Provision fast, reliable, and secure cloud storage for all enterprise workloads.
• Set up fast, predictable networking with end-to-end network security, including a virtual cloud network (VCN).
• Monitor the health of your resources, optimize the performance of your applications, and respond to anomalies in real time.
• Access to dozens of additional Oracle Cloud Services enabling organizations to embrace the shift to the cloud.
• Free up time of developers, Database Administrators (DBA), and DevOps to focus on value-added tasks that are core to your business.

Step 1: Create a Compartment

You must have an OCI tenancy subscribed to your home region and enough limits configured for your tenancy to create a MySQL HeatWave Database System. Make sure to log in to the Oracle Cloud Console as an Administrator. For testing, you can use oracle free tier account.

1. Click the Navigation Menu in the upper left, navigate to Identity & Security and select Compartments.

2. On the Compartments page, click Create Compartment.

3. In the Create Compartment dialog box, in the NAME field, enter MySQLHeatWave, and then enter a Description, select the Parent Compartment, and click Create Compartment.

Below screenshot shows a completed compartment.

Step 2: Create a policy for the compartment

1. Click the Navigation Menu in the upper-left corner, navigate to Identity & Security and select Policies.

2. On the Policies page, in the List Scope section, select the Compartment (root) and click Create Policy.

3. On the Create Policy page, in the Description field, enter MySQL_Services and select the root compartment.

4. Turn on the Show manual editor toggle switch in the Policy Builder section.

5. Click Create.

5. Enter the following required MySQL HeatWave policies. These policies define what actions the "Administrators" group can perform, with permissions ranging from inspecting compartments to fully managing MySQL database systems.

Allow group Administrators to {COMPARTMENT_INSPECT} in tenancy
Allow group Administrators to {VCN_READ, SUBNET_READ, SUBNET_ATTACH, SUBNET_DETACH} in tenancy
Allow group Administrators to manage mysql-family in tenancy        

The following screenshot shows the completed policy creation:

3. Create a VCN

1. Click the Navigation Menu in the upper-left corner, navigate to Networking, and select Virtual Cloud Networks.

2. Click Start VCN Wizard.

3. Select VCN with Internet Connectivity and click Start VCN Wizard.

4. On the Create a VCN with Internet Connectivity page, in the Basic Information section, in the VCN Name field, enter HeatWave_VCN and from the Compartment drop-down list, select MySQLHeatWave.

5. Click Next at the bottom of the screen.

6. Review the Oracle Virtual Cloud Network (VCN), Subnets, and Gateways sections and click Create to create the VCN.

Note: The VCN creation is completed.

7. Click View Virtual Cloud Network to display the created VCN.

8. On the Virtual Cloud Network Details page, under Resources, select Security Lists (2).

Step 4: Configure security list to allow MySQL incoming connection HeatWave_VCNs

1. In the Security Lists in Compartment_Name Compartment section, click Security List for Private Subnet-HeatWave_VCN.

2. In the Security List for Private Subnet-HeatWave_VCN section, in the Ingress Rules section, click Add Ingress Rules.

3. In the Add Ingress Rule dialog box, add an ingress rule with Source CIDR 0.0.0.0/0 and destination port number 3306, 33060 and click Add Ingress Rule.

4. On the Security List for Private Subnet-HeatWave_VCN page, the new ingress rules will be shown in the Ingress Rules list.

Step 5: Create a MySQL HeatWave Database System.

1. Click the Navigation Menu in the upper-left corner, navigate to Databases, and select Database Systems.

2. Click Create MySQL HeatWave Database System.

3. Select the Development or Testing Option. Note: For your production deployment, Select the production one.

4. On the Create MySQL HeatWave Database System dialog box, complete the fields in each section:

• Provide basic information for the database system
• Set up your required database system
• Create administrator credentials
• Configure networking
• Configure placement
• Configure hardware
• Configure backups
• Show advanced options

Note: The New MySQL HeatWave Database System will be ready to use after a few minutes. The state will be shown as Creating during the creation.

Check the Status is Active Now.

Thanks for visiting. Subscribe and stay tuned.... :)

Mentions:

Oracle Cloud Computing Oracle Cloud Amazon Web Services (AWS) Microsoft Azure Google Cloud Oracle MySQL