Read-only replicas
Read-only replicas allow all data from a given instance to be replicated to another instance, which may be in the same zone, another zone within the same region, or hosted outside of the Google Cloud Platform. Read-only replicas are a great way to increase bandwidth on read-heavy databases. For both second generation MySQL instances and PostgreSQL instances, replication requires that automated backups and binary logging be enabled.
Managed read-only replicas may be created and managed through the Cloud Console or the gcloud CLI. A read-only replica is essentially a clone of the original instance, with all tables, including the users table, replicated across instances. Because the read-only replica is a separate Cloud SQL ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access