July 2018
Intermediate to advanced
506 pages
16h 2m
English
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 ...