Create an Amazon® RDS™ Instance
Last modified: January 27, 2023
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:
- Click the Region menu in the upper-right corner of the page.
- 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:
RDSin the Search text box at the top of the page,
- 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:
- In the left sidebar, click Parameter groups. A new interface will appear.
- Click Create parameter group. A new interface will appear.
- From the Parameter group family menu, select the database family that you wish to use.
Important:We only support the
mysql8.0database families. We recommend that you select
- Select the Type of parameter group you want to use.
- Enter your desired Group name for the parameter group. We recommend that you use the name
- Enter a Description for the parameter group.
- Click Create. The Parameter groups interface will reappear.
- Click the
cpanel-whmparameter group. A new interface will appear.
- In the Filter parameters text box, enter
- Click Edit parameters.
- In the Values menu, select
- Click Save changes.
Create the database
To create the database, perform the following steps:
- In the left sidebar, click Dashboard.
- Click Create database. The Create database interface will appear.
- Select the Standard create method of database creation.
- 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.
- In the Templates section, select the template that meets your needs.
- In the Availability and durability section, select the non-cluster deployment option that meets your needs.
- In the Settings section, enter your desired DB instance identifier name.
- In the Settings section, click the arrow next to Credentials Settings, and enter the following information:
rootfor 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.
- 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.
- Desired DB instance class.
- 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.
- 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.
- In the Monitoring section, select if you would like to enable Enable Enhanced monitoring. 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:
- Enter your desired Initial database name.
If you do not specify a database name, Amazon RDS does not create a database.
- From the DB parameter group menu, select the
- From the Option group menu, select the
cpanel-whmoption you created previously.
- 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.
- 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.
- In the Log exports section, select your desired logs.
- In the Maintenance section, configure the following options:
- Desired Enable auto minor version upgrade status.
- Desired Maintenance window settings.
- In the Deletion protection section, select Enable deletion protection if you would like to enable database deletion protection.
- 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).