CODEWITHSUNDEEP
google-cloud-sqlportforwardingcloud-sql-proxy
kislay kumar
kislay kumar

Reputation: 3

2 Cloud SQL server port forward to cloud proxy vm

I have 2 cloud sql server ( dev and qa) , How to do port forwarding for both sql server to 1 cloud proxy vm. I did port forwarding for dev sql server long back and its listening on 1433 in cloud proxy vm.

sudo iptables -t nat -I PREROUTING -p tcp --dport 1433 -j DNAT --to-destination 127.0.0.1:1433
sudo nohup ./cloud_sql_proxy -instances=project:region:dev-sqlserver=tcp:1433

Now i have another qa sql server which i want to do port forwarding in same cloud proxy vm.

I want the way to do port forwarding for both sql server in same cloud proxy vm.

Upvotes: 0

Views: 120

Answers (1)

Tatiane Tosta
Tatiane Tosta

Reputation: 169

The Cloud SQL Proxy supports multiple instances. As per documentation:

./cloud-sql-proxy --port 6000 <INSTANCE_CONNECTION_NAME_1> <INSTANCE_CONNECTION_NAME_2>

Consider migrating to v2, follow the Migration Guide.

Upvotes: 1

Related Questions