Cloud SQL for MySQL Connectivity to and fro from on-prem machine

[MaheshPatilGCP]

HI

Can anyone help on connecting or preparing replication steps between 
Google Cloud SQL instance and On-prem prod machine (own data center machine) 

basically I want replication command to be running from and to between them 
I am not sure how it works in Cloud SQL but using Amazon RDS it was straight forward to make replication work. 
i just want port 3306 to and fro within them , not sure how it works. Please help

[usman317]

So if the server is running behind a server what you need to do first is to allow traffic from outside to the server by port mapping.... I would check that if this port mapping has been correctly by trying connecting mysql workbench to mysql server from outside the network.... Once this forwarding rule is properly setup than you need to create the connection profile for the migration Job... In this profile give the address of your router and the port (if you are not behind the router then no need to do it).. Once done than you create the migration Job... Select ip allow list... You will get the ip address of the sql server which you have to allow permission to extract data from your server. You may also have to config some flags on mysql to let an out site application extract data from it