External replicas
Both first and second generation MySQL instances can be configured to perform replication using databases hosted externally from Google Cloud. First generation instances may be configured as either a master or a slave to external databases, while second generation instances only support external read-only replicas. PostgreSQL does not currently support external read-only replicas.
Configuring external replicas involves directly modifying the instance's users table to add a replica user, granting that user REPLICATION SLAVE rights, and configuring an authorized network to allow traffic from the external replica. Once configured, all data can be exported from the instance using the Cloud SQL export functionality and imported ...
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