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