How-to Guides

Creating and Managing Instances

• Creating instances

  Create a new Cloud SQL SQL Server instance.

• Using customer-managed encryption keys (CMEK)

  Create a new instance with a customer-enabled encryption key.

• Viewing instance information

  View instance settings.

• Editing instances

  Edit an existing instance.

• Starting, stopping, and restarting instances

  Start, stop, or restart an instance.

• Deleting instances

  Delete an instance.

• Configuring private IP connectivity

  Enable or configure private IP for an instance.

• Configuring public IP connectivity

  Add or remove authorized IP addresses for an instance.

• Configuring organization policies

  Add organization policies to control access to and from Cloud SQL instances.

• Configuring SSL/TLS

  Configure SSL/TLS for an instance, including enforcing the use of SSL/TLS and certificate management.

• Configuring database flags

  Update database flags for an instance.

• Labeling instances

  Add, update, or delete labels for an instance.

• Finding and setting maintenance windows

  Find or set maintenance windows on instances.

Connecting to Instances

• Authorization with the Cloud SQL Proxy

  Authorize a Cloud SQL Proxy connection to a Cloud SQL instance.

• Connecting sqlcmd using IP addresses

  Connect to an instance by authorizing access to an IP address or range of addresses.

• Connecting sqlcmd using the proxy

  Connect to an instance by using the Cloud SQL Proxy.

• Connecting from App Engine standard environment

  Connect to an instance from an App Engine standard environment application.

• Connecting from App Engine flexible environment

  Connect to an instance from an App Engine flexible environment.

• Connecting from external applications

  Connect to an instance from an external application.

• Connecting from Google Kubernetes Engine

  Connect to an instance from an application running in Google Kubernetes Engine.

• Connecting from Cloud Functions

  Connect to an instance from code running in Cloud Functions.

• Connecting from Cloud Run (fully managed)

  Connect to an instance from Cloud Run (fully managed).

• Managing Database Connections

  Best practices for managing database connections in your applications.

Data Management

• Enabling and disabling high availability on an instance

  Configure an instance to fail over to a different zone in case of a zonal outage or disable high availability on an instance.

• Creating and managing on-Demand and automatic backups

  Schedule and disable automatic backups, create and manage on-demand backups, and view backups for your instance.

• Restoring an instance

  Restore an instance from a backup.

• Importing data into Cloud SQL

  Import data from Cloud Storage to an instance.

• Exporting data

  Export data from an instance to Cloud Storage, or from an instance you manage to the local file system.

• Checking the status of import and export operations

  Check the status of import and export operations.

Managing Databases and Users

• Creating and managing databases

  Create, list, and delete databases on an instance.

• Creating and managing users

  Create and manage users on an instance.

Using the Cloud SDK

• Using the Cloud SDK

  Use the gcloud command-line tool in the Cloud SDK to manage instances.