In our previous blog, we have explained that to configure external replica for a CloudSQL instance. Here we are going to see how to configure external master for CloudSQL. Unlike native replication or the method which we explained in our previous blog, setting up external master for CloudSQL is pretty different way. Lets see how we can achive this.
Process Overview:
- Launch VM and configure MySQL 5.7(it should be 5.5+).
- Initiate the dump along with the binlog filename and its position.
- Upload the Backup file to Google Storage.
- Enable the CloudSQL Admin API.
- In the CloudSQL console, use migrate data.
- Select the CloudSQL instance type and its network.
- Provide the Master server’s IP …