Cloud SQL

Adding SQL Databases in DuploCloud

DuploCloud supports creating and managing Cloud SQL databases in Google Cloud Platform (GCP) through the DuploCloud Portal. You can provision MySQL, PostgreSQL, or SQL Server instances using preconfigured tiers or custom node types. This allows you to tailor your database setup for performance, cost, or compliance requirements including the ability to deploy dedicated PostgreSQL nodes using custom vCPU and memory settings.

Creating a Cloud SQL database

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

2. Click Add. The Add SQL DB page displays.

   

   Add SQL DB page in the DuploCloud Portal
3. Complete the fields as required.

   Name	Enter a name for the Cloud SQL database. This will be used as the resource identifier.
   Edition	Select from the supported Cloud SQL editions (Enterprise or Enterprise Plus)
   SQL Version	Select the database engine and version to use (e.g., PostgreSQL 15, MySQL 8).
   Tier	Select a predefined machine type (e.g., 1 vCPU 3.75 GB) or choose Custom Node and specify a custom machine tier by entering it manually in the Other Tier field. Refer to GCP Instance Settings to find valid tier names.
   Root Password	Enter a password for the root/admin database user.
   No Password	Enable to create the database without setting a root password. This is typically used when authentication will be managed through IAM or other external mechanisms.
   Disk Size (in GB)	Enter the disk size for the Cloud SQL instance.
   Labels	Optionally, add key-value pairs to organize or tag your database resources.

4. Click Create.

Viewing a Cloud SQL database

You can view database details and configure other options by navigating to Cloud Services -> Cloud SQL and selecting the Cloud SQL database from the NAME column.

The Cloud SQL database details page in the DuploCloud Portal

Additional Supported Actions

1. Navigate to Cloud Services -> Cloud SQL.

2. Click the menu icon ( ) on the left of the row listing your SQL database, and select GCP Console, Edit, Delete, Stop, Restart, or Reset Password.

Retaining Backups Before Cloud SQL Deletion

This setting ensures that a backup is automatically taken and stored in a designated Storage Bucket in GCP before a Cloud SQL instance is deleted, providing a safeguard for data recovery.

1. When deleting a Cloud SQL instance, enable the Retain backups option to retain backups.

The Delete SQL Database pane with Retain backups enabled