Create an Amazon® RDS Instance

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

Click to view a screenshot…


Log in to the AWS Management Console with your Amazon AWS account.

The AWS Management Console page will appear.

Select your region

Click to view a screenshot…


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

Click to view a screenshot…


To open the RDS Console, perform the following steps:

  1. Click the Services setting in the upper-left corner of the page.

  2. Click RDS. The RDS Console will appear.

Create a parameter group

Click to view a screenshot…



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

To create a DB 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® that you wish to use.

    Note:

    • cPanel & WHM versions 86 and earlier only support connections to MySQL 5.7.

    • cPanel & WHM versions 88 and later on CentOS 7 and 8, CloudLinux 7 and 8, and Red Hat® Enterprise Linux® 7 support connections to MySQL 5.7 and 8.0.

    • cPanel & WHM versions 94 and later on AlmaLinux 8 support connections to MySQL 5.7 and 8.0.

  4. Enter a Group name for the parameter group. We recommend that you use the cpanel-whm name.

  5. Enter a Description of the parameter group.

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

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

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

  9. Click Edit parameters.

  10. In the Values menu, select 1.

  11. Click Save changes.

  12. In the left sidebar, click Dashboard.

Create the database

Click to view a screenshot…


Click Create the Database. A new interface will appear.

Select the database engine

Click to view a screenshot…


Select the MySQL database engine, and then click Next. A new interface will appear.

Remember:

  • cPanel & WHM versions 86 and earlier only support connections to MySQL 5.7.

  • cPanel & WHM versions 88 and later on CentOS 7 and 8, CloudLinux 7 and 8, and Red Hat Enterprise Linux 7 support connections to MySQL 5.7 and 8.0.

  • cPanel & WHM versions 94 and later on AlmaLinux 8 support connections to MySQL 5.7 and 8.0.

Select your use case

Click to view a screenshot…


Select the use case for your database and click Next. A new interface will appear.

Specify the database details

Click to view a screenshot…


To specify the details for your database, perform the following actions:

  1. Select the default License model.

  2. Select the DB engine version that you wish to use.

    Remember:

    • cPanel & WHM versions 86 and earlier only support connections to MySQL 5.7.

    • cPanel & WHM versions 88 and later on CentOS 7 and 8, CloudLinux 7 and 8, and Red Hat Enterprise Linux 7 support connections to MySQL 5.7 and 8.0.

    • cPanel & WHM versions 94 and later on AlmaLinux 8 support connections to MySQL 5.7 and 8.0.

  3. Select the DB instance class. 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.

  4. Select whether to deploy the database in Multiple Affinity Zones (Multi-MZ).

  5. Select the Storage type.

  6. Select the amount of storage space.

  7. For MySQL servers, select the Provisioned IOPS rate. This value determines the number of I/O operations per second that the database can support.

Configure the database settings

Click to view a screenshot…


To configure the database settings, perform the following actions:

  1. Scroll down to the Database Settings section.

  2. Enter a name for the database.

  3. Enter root as the username. If you do not enter root as the username, some functions in cPanel & WHM will not function properly.

  4. Enter the password and then confirm it.

  5. Click Next. A new interface will appear.

Configure the advanced settings

Click to view a screenshot…


To configure the advanced settings for the database, perform the following actions:

  1. Select the desired Virtual Private Cloud (VPC) for the database instance. If you host servers with AWS, we recommend that yo use the same VPC for each server.

  2. Select the desired Subnet group for the database. We suggest that you select the default value.

  3. Select whether the public will have access to the database. If you select No, only cPanel & WHM servers that you host at Amazon will be able to access the database.

  4. Select the desired Availability Zone for the database instance. We recommend that you select the No preference value.

  5. Select the desired VPC security groups for the database instance. If you host servers with AWS, we recommend that you use the same security groups for each server.

  6. Select the desired Port for database connections. We recommend that you use the current value.

  7. From the DB parameter group menu, select the cpanel-whm DB parameter group.

  8. Select your desired Option group. We recommend that you use the current value.

  9. Select whether to enable or disable IAM DB authentication for MySQL.

  10. Select the desired Encryption settings.

  11. Select the desired Failover settings.

  12. Configure your Backup settings for the amount of days to retain backups, the time window in which to run backups, and whether to copy tags to snapshots.

  13. Configure your Monitoring settings. We recommend that you select the Default monitoring role and retain a 60 second granularity.

  14. Select whether to post log files to Amazon CloudWatch.

  15. Select whether you wish to allow automatic updates of the database engine for minor versions.

  16. Select whether you wish to disable deletion of the database. This will prevent accidental deletion of the database.

  17. Click Create database.

View the details

Click to view a screenshot…


Click View DB instance details. The database console page will appear.

Obtain the endpoint

Click to view a screenshot…


Wait for the Info value 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.