Last modified: March 1, 2024

Overview

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

Create an Amazon RDS Instance

To create an Amazon RDS instance, perform the following steps.

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 menu in the upper-right corner of the page.
2. Select the region in which you wish to create the RDS instance.

Open the RDS Console

To open the RDS Console, perform the following steps:

1. Enter RDS in the Search text box at the top of the page,
2. Click RDS in the Search results for ‘RDS’ interface. The RDS Management 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 steps:

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 database family that you wish to use.
   Important:

   We only support the mysql5.7 or mysql8.0 database families. We recommend that you select mysql8.0.
4. Select the Type of parameter group you want to use.
5. Enter your desired Group name for the parameter group. We recommend that you use the name cpanel-whm.
6. Enter a Description for the parameter group.
7. Click Create. The Parameter groups 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.

Create the database

To create the database, perform the following steps:

1. In the left sidebar, click Dashboard.
2. Click Create database. The Create database interface will appear.
3. Select the Standard create method of database creation.
4. In the Engine options section, select the following options:
   • MySQL® as your Engine type.
   • A version of MySQL 5.7 or 8.0 as your Engine Version. We recommend MySQL 8.0.
5. In the Templates section, select the template that meets your needs.
6. In the Availability and durability section, select the non-cluster deployment option that meets your needs.
7. In the Settings section, enter your desired DB instance identifier name.
8. In the Settings section, click the arrow next to Credentials Settings, and enter the following information:
   • root for the Master username.
   • Desired Master password or select Auto generate a password.
     • If you entered a master password, enter it again in Confirm master password.
9. 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.
10. In the Storage section, select the following options:
    • Desired Storage type setting.
    • Desired Allocated storage value.
    • If the option appears, select the desired Provisioned IOPS value.
    • Desired autoscaling status.
    • Desired Maximum storage threshold value.
11. In the Connectivity section, configure the following options:
    • Desired Compute resource setting.
    • Desired Virtual private cloud (VPC) setting.
      Note:

      If you host servers with AWS, we recommend that you use the same VPC for each server.
    • Desired DB subnet group setting. 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. We recommend that you use the default value.
12. In the Database authentication section, select your desired authentication option:
    • Password authentication.
    • Password and IAM database authentication.
    • Password and Kerberos authentication.
13. In the Monitoring section, select Enable Enhanced monitoring if desired. If you enable Enable Enhanced monitoring, select the following options:
    • Desired Granularity value.
    • Desired Monitoring Role setting.

Configure additional database settings

In the Additional configuration section, perform the following steps:

1. Enter your desired Initial database name.
   Important:

   If you do not specify a database name, Amazon RDS does not create a database.

2. From the DB parameter group menu, select the cpanel-whm option.
3. From the Option group menu, select the cpanel-whm option you created previously.
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 you will connect to in one of the following interfaces:

• In cPanel & WHM version 118 and earlier, the Endpoint value represents the hostname you will connect to in WHM’s Manage MySQL® Profiles interface (WHM » Home » SQL Services » Manage MySQL® Profiles).
• In cPanel & WHM version 120 and later, the Endpoint value represents the hostname you will connect to in WHM’s Manage Database Profiles interface (WHM » Home » Database Services » Manage Database Profiles).