Cloud SQL

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.

   
3. Complete the fields as required.

   Name

   Enter a name for the Cloud SQL database. This will be used as the resource identifier.

   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.

   Disk Size (in GB)

   Enter the disk size for the Cloud SQL instance.

   Labels

   (Optional) 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.

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.