GKE: How to disconnect from a pod after port forwarding through bastion host

Question

I am using a local machine to work with a database in a pod deployed in Kubernetes. To connect to it, you first need to connect to the bastion host VM.

Basically, this is a double SSH tunnel: map port 3306 to the bastion host VM's port 3306, and then through the localhost's 3306 port.

gcloud beta compute ssh my-bastion-host --project my-gcp-project --zone us-west1-b --command "kubectl -n mynamespace port-forward app-mysqldb-12345-abcde 3306" -- -L3306:127.0.0.1:3306

However, when I terminate the command, the connection between the VM and the mysql pod is not terminated, I need to do it automatically: First, execute the following command on the bastion host:

ps -ef|grep port-forward

Find the process number PROCESS_NUMBER, and then execute the following command:

echo "kill -9 <PROCESS_NUMBER>

Terminate the connection.

Is there a way to automatically close the connection between the bastion host and the mysql pod when terminating gcloud beta compute ssh?

Answer 1

Try this:

gcloud beta compute ssh my-bastion-host --project my-gcp-project --zone us-west1-b --command "bash -c 'kubectl -n mynamespace port-forward app-mysqldb-12345-abcde 3306'; kill -9 $(pgrep -f port-forward)" -- -L3306:127.0.0.1:3306