Page tree
Skip to end of metadata
Go to start of metadata

Overview

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

Create an Amazon RDS instance



Log in to the Amazon Web Services (AWS) Management Console

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

The AWS Management Console page will appear.





Select your region.

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

Then, 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 the Services setting in the upper-left corner of the page.

Then, 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 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 mysql5.7.

    Important:

    cPanel & WHM currently only supports connections to MySQL® 5.7.

  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 Create the Database. A new interface will appear.





Select the database engine.

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

Reminder:

cPanel & WHM currently only supports connections to MySQL® 5.7.





Select your use case.

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




Specify the database details

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.

    Reminder:

    cPanel & WHM currently only supports connections to MySQL 5.7.

  3. Select the DB instance class.

    Note:

    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

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.

    Important:

    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.

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 View DB instance details. The database console page will appear.




Obtain the endpoint.

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.




Additional documentation

There is no content with the specified labels

There is no content with the specified labels