Replication options

This page describes the replication options offered by Cloud SQL.

Introduction

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

To reduce load on the master 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 Master Replica Benefits and use cases More information
Read replica Cloud SQL instance Cloud SQL instance
  • Additional read capacity
  • Analytics target
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 (external master for 2nd Generation) MySQL instance external to Cloud SQL Cloud SQL Second Generation instance
  • Migration path to Cloud SQL Second Generation
  • Data replication to Google Cloud Platform
  • Analytics target
External master MySQL instance external to Cloud SQL Cloud SQL First Generation instance
  • Data replication to Google Cloud Platform
  • Analytics target

What's next