How-to guides

Creating and managing instances

• Creating instances

  Create a new Second Generation 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.

• Cloning instances

  Clone an instance to create an independent copy of the 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.

• Migrating data between Cloud SQL and external servers

  Move your data into and out of Cloud SQL with minimal downtime.

• Upgrading MySQL

  Upgrade the MySQL version for an instance by exporting and reimporting your data.

• Finding and setting maintenance windows

  Find or set maintenance windows on instances.

Connecting to instances

• 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 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

  Connect to an instance from Cloud Run.

• Connecting from other MySQL tools

  Connect to an instance using MySQL administration tools.

• Managing database connections

  Best practices for managing database connections in your applications.

Replication, high availability, and backup and restore

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

• Legacy configuration for high availability

  The legacy configuration for a MySQL instance for high availability.

• 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

  A description of restoring an instance from a backup.

• Using point-in-time recovery

  Restoring an instance using point-in-time recovery.

• Creating read replicas

  Create read replicas for an instance.

• Managing read replicas

  Starting and stopping replication, getting replication status, and promoting replicas.

• Promoting replicas for regional migration or disaster recovery

  How to use and promote cross-region replicas for regional migration or disaster recovery.

• Configuring external replicas

  Configuring an external read replica for a primary Cloud SQL instance.

• Replicating from an external server

  Creating a Second Generation read replica for a MySQL server that you manage.

Importing and exporting data

• Best practices for importing and exporting data

  Best practices for importing and exporting data.

• Importing data into Cloud SQL

  Import data from Cloud Storage to an instance.

• Exporting data from Cloud SQL

  Export data from an instance to Cloud Storage.

• Exporting data for import into Cloud SQL

  Create SQL dump and CSV files from an external database for import into an instance.

• Checking the status of import and export operations

  Check the status of import and export operations.

Managing MySQL databases and users

• Creating and managing MySQL databases

  Create, list, and delete MySQL databases on an instance.

• Creating and managing MySQL users

  Create and manage MySQL users on an instance, including setting the root password.