RDS database

Create and connect to an RDS database instance

Create, configure, and manage RDS instances directly from the DuploCloud Portal.

DuploCloud supports the following RDS databases in AWS:

MySQL PostgreSQL MariaDB Microsoft SQL-Express Microsoft SQL-Web	Microsoft SQL-Standard Aurora MySQL Aurora MySQL Serverless Aurora PostgreSQL Aurora PostgreSQL Serverless

*Support for Aurora Serverless V1 database engines has been deprecated. Do not create V1 engines when using Terraform.

When upgrading RDS versions, use the AWS Console and see your Cloud Provider for compatibility requirements. Note that while versions 5.7.40, 5.7.41, and 5.7.42 cannot be upgraded to version 8.0.28, you can upgrade them to version 8.0.32 and higher.

Creating an RDS database

1. In the DuploCloud Portal, navigate to Cloud Services -> Database.

2. Click Add. The Create a RDS page displays.

   

   The Create a RDS page in the DuploCloud Portal
3. Complete the following fields:

   • RDS Name: Enter a unique name for the RDS instance. DuploCloud suggests using the Tenant name as a prefix, e.g., tenantname-db.

   • Create from Snapshot (Optional): Select an existing snapshot to restore from if applicable.

   • RDS Engine: Choose the database engine (e.g., MySQL, PostgreSQL, MariaDB).

   • RDS Engine Version: Select the engine version.

   • Encryption Key (Optional): Select an encryption key if needed for encryption at rest.

   • Storage Type (Optional): Choose the storage type (e.g., General Purpose SSD, Provisioned IOPS).

   • Storage Size in GB (Optional): Specify the storage size in GiB. (Minimum: 20 GiB, Maximum: 65,536 GiB.)

   • RDS Instance Size: Choose an instance type based on performance needs.

   • DB Parameter Group (Optional): Select a custom database parameter group if needed.

   • DB Subnet Group (Optional): Choose a subnet group for the database network configuration.

   • Backup Retention Period in Days: Enter a retention period between 1 and 35 days.

   • User Name: Enter the database username. (Required)

   • User Password: Enter a secure password for the database. (Required)

   • Optionally, select Enable Performance Insights.

   • Performance Insights Retention in Days (Optional): Enter the retention period for Performance Insights data. (Default: 7 days, Maximum: 731 days.)

   • Performance Insights Encryption (Optional): Select an encryption key for encrypting Performance Insights data. (If not specified, AWS will use the default key.)

   • Enable Additional Features (Optional):

     • Enable IAM Auth

     • Store Credentials in Secrets Manager

     • Enable Multi-AZ

     • Enable Logging

4. Click Create to provision the RDS database.

Creating an Aurora Serverless V2 Cluster database

You can create Aurora Serverless V2 Databases by selecting Aurora-MySql-Serverless-V2 or Aurora-PostgreSql-Serverless-V2 from the RDS Database Engine list box. Select the RDS Engine Version compatible with Aurora Serverless v2. The RDS Instance Size of db.serverless applies to both engines.

Creating a publicly available RDS database

1. Create a DB subnet group in AWS consisting only of public subnets from your VPC.

2. In the DuploCloud Portal, navigate to Cloud Services -> Databases

3. Select the RDS tab, and click Add. The Create a RDS page displays.

4. In the DB Subnet Group list box select the public DB subnet group you created in AWS.

5. Complete the remaining fields according to your requirements.

6. Click Create. The publicly available RDS database is created.

To create a public RDS database, you much first create a DB subnet group in AWS consisting only of public subnets from your VPC. Then follow the steps above to create an RDS database, selecting the DB subnet group you created from the DB Subnet Group list box.

The DB subnet group created in AWS must only contain public subnets from your VPC. This configuration is crucial for making the database public.

Connecting to the database

Once you create the database, select it and use the Instances tab to view the endpoint and credentials. Use the Endpoints and credentials to connect to the database from your application running in an EC2 instance. The database is only accessible from inside the EC2 instance in the current Tenant, including the containers running within.

For databases you intend to make publicly available, ensure proper security measures, including broad accessibility, are in place to protect your data.

The Instances tab on the RDS details page

Pass the endpoint, name, and credentials to your application using environment variables for maximum security.

Updating performance insights for an existing RDS

1. In the DuploCloud Portal, navigate to Cloud Services -> Database and select the RDS tab.

2. Click on the RDS name in the NAME column.

3. From the Actions menu, select RDS Settings and then Update Performance Insights. The Update Performance Insights pane displays.

4. Select Enable Performance Insights.

5. In the Performance Insights Retention in Days field, enter a retention period (1–731 days).

6. From the Performance Insights Encryption list box, select an encryption key or select No Encryption.

7. Click Update to apply the changes.