Replication options

This page describes the replication options offered by Cloud SQL.

Introduction

Cloud SQL provides the ability to replicate a primary instance to one or more read replicas. A read replica is a copy of the primary that reflects changes to the primary instance in almost real time.

To reduce load on the primary instance, send queries to the read replica instance instead. Connect to the replica directly using its connection name and IP address.

Cloud SQL supports the following read replication scenarios:

Name Primary Replica Benefits and use cases More information
Read replica Cloud SQL instance Cloud SQL instance
  • Additional read capacity
  • Analytics target
Cross-region read replica Cloud SQL instance Cloud SQL instance
  • Additional read capacity
  • Analytics target
  • Additional disaster recovery capability
  • Improve read performance
  • Migrate data between regions
External read replica Cloud SQL instance MySQL instance external to Cloud SQL
  • Reduced latency for external connections
  • Analytics target
  • Migration path to other platforms
Replication from an external server MySQL instance external to Cloud SQL Cloud SQL for MySQL instance
  • Migration path to Cloud SQL
  • Data replication to Google Cloud Platform
  • Analytics target

What's next