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.

    The 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.

    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.

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

Last updated

Was this helpful?