Create an Amazon® RDS™ Instance


Last modified: November 17, 2022

Overview

This document explains how to create an Amazon® RDS™ instance.

Create an Amazon RDS Instance

Log in to the Amazon Web Services Management Console

Log in to the AWS™ Management Console as the root user with your Amazon AWS account.

The AWS Management Console page will appear.

Select your region

To select the region in which to create the database, perform the following steps:

  1. Click the Region setting in the upper-right corner of the page.

  2. Select the region in which you wish to create the RDS instance.

Important:
We strongly recommend that you select the region in which you host your cPanel & WHM servers at Amazon.

Open the RDS Console

To open the RDS Console, perform the following steps:

  1. Enter RDS into the search box at the top of the page.

  2. Click RDS. The RDS Console will appear.

Create a parameter group

You must create a parameter group so that cPanel & WHM can properly connect to the database.

To create a parameter group, perform the following actions:

  1. In the left sidebar, click Parameter groups. A new interface will appear.

  2. Click Create parameter group. A new interface will appear.

  3. From the Parameter group family menu, select the version of MySQL® or MariaDB® that you wish to use.

    Note:
    We recommend MySQL 8.0 or MariaDB 10.6.

  4. Select the Type of parameter group you desire.

  5. Enter your desired Group name for the parameter group. We recommend that you use the name cpanel-whm.

  6. Enter a Description of the parameter group.

  7. Click Create. The Parameter group interface will reappear.

  8. Click the cpanel-whm parameter group. A new interface will appear.

  9. In the Filter parameters text box, enter log_bin_trust_function_creators.

  10. Click Edit parameters.

  11. In the Values menu, select 1.

  12. Click Save changes.

  13. In the left sidebar, click Dashboard.

Create the database

Click Create Database. The Create database interface will appear.

Select the Easy Create method if you would like to use Amazon’s best-practice settings. Select the Standard Create method of database creation if you would like to customize all of your settings.

Easy database creation

To complete the Easy Create database set up, perform the following steps:

  1. Select MySQL or MariaDB as your Engine Type.

    Note:
    We recommend MySQL 8.0 or MariaDB 10.6.

  2. Select a DB Instance size that suits your needs.

  3. Enter a DB instance identifier name for your database.

  4. Enter your desired Master username.

  5. Enter a Master password or select Auto generate a password.

  6. Confirm your password.

  7. Click Create database. A new interface will appear.

Read the Obtain the Endpoint section of this document for information on how to connect to your new database.

Standard database creation

To configure the Standard database settings, perform the following steps:

  1. In the Engine Options section, select the following options:

    • MySQL or MariaDB as your Engine Type.
    • MySQL or MariaDB as your Engine Version.
      Note:
      We recommend MySQL 8.0 or MariaDB 10.6.
  2. In the Templates section, select the template that meets your needs.

  3. In the Availability and durability section, select the deployment option that meets your needs.

  4. In the Settings section, enter your desired DB instance identifier name.

  5. Located in the Settings section, click the arrow next to Credentials Settings, and enter the following information:

    • Desired Master username.
    • Desired Master password or select Auto generate password.
    • Desired Master password again to confirm.
  6. In the Instance configuration section, select the following options:

    • Desired DB instance class.
      Important:
      Your instance type determines the rate at which AWS bills you. Make certain that you select an instance type that includes appropriate resources for the type of system that you wish to run.
    • Desired computational, memory, and network capacity for your needs.
    • Desired include previous generation classes status.
  7. In the Storage section, select the following options:

    • Desired Storage type setting.
    • Desired Allocated storage value.
    • Desired Provisioned IOPS value.
    • Desired Enable autoscaling status.
    • Desired Maximum storage threshold value.
  8. In the Connectivity section, configure the following options:

    • Desired Compute Resource setting.
    • Desired Virtual private cloud setting.
      Note:
      If you host servers with AWS, we recommend that yo use the same VPC for each server.
    • Desired DB Subnet group setting.
      Note:
      We recommend that you select the default value
    • Desired Public access setting.
      Important:
      If you select No, only cPanel & WHM servers that you host at Amazon will be able to access the database.
    • Desired VPC security group settings.
    • Desired RDS Proxy setting.
    • Click the arrow next to Additional configuration, and enter your desired Database port value.
      Note:
      We recommend that you use the default value.
  9. In the Database authentication section, select your desired Database authentication options type.

  10. In the Monitoring section, select if you would like to enable Turn on Performance Insights. If you enable Turn on Performance Insights, configure the following options:

    • Desired Retention period value.
    • Desired AWS KMS key setting.

    Click the arrow next to Additional configuration, and select your desired Enable Enhanced Monitoring status. If you enable Enable Enhanced Monitoring, configure the following options:

    • Desired Granularity value.
    • Desired Monitoring Role setting.
  11. If you wish to configure additional database settings, read the Configure additional database settings section of this document. If you do not wish to configure additional database settings, click Create database. A new interface will appear.

Read the Obtain the Endpoint section of this document for information on how to connect to your new database.

Configure additional database settings

In the Additional configuration section, perform the following steps:

  1. Enter your desired Initial database name.

  2. From the DB parameter group dropdown menu, select the cpanel-whm option.

  3. From the Option group dropdown menu, select the cpanel-whm option.

  4. In the Backup section, configure the following options:

    • Desired Enable automated backups status.
    • Desired Backup retention period value.
    • Desired Backup window setting.
    • Desired Copy tags to snapshots status.
  5. In the Encryption section, select Enable encryption if you would like to enable encryption on your database. If you enable Enable encryption, select your desired AWS KMS key setting.

  6. In the Log exports section, select your desired logs.

  7. In the Maintenance section, configure the following options:

    • Desired Enable auto minor version upgrade status.
    • Desired Maintenance window settings.
  8. In the Deletion protection section, select Enable deletion protection if you would like to enable database deletion protection.

  9. Click Create database.

Obtain the endpoint

Wait for the Status value of your new database to change to Available. Then, scroll down to the Connectivity & security section.

The Endpoint value represents the hostname to which you will connect in WHM’s Manage MySQL Profiles interface (WHM » Home » SQL Services » Manage MySQL Profiles).

Note:
When you suspend a cPanel account, the system will not suspend any of the account’s Amazon RDS remote databases.

Additional Documentation