In a recent article, I explained how to test MySQL Database Service (aka MDS) on OCI without having to setup a VPN.
A VPN is the recommended way and of course using some man-in-the-middle exposing the MySQL Classic and X Protocol port is something you should absolutely avoid !
So, in this article we will see another way to test or use MDS without VPN but using a more secure option.
The solution uses a SSH tunnel between your machine (laptop, etc..) and OCI.
How does it work ?
We have a MDS instance (10.0.1.3), and a compute instance (10.0.0.2). The compute instance is in the public subnet and has a public IP assigned to it.
Then we open a SSH tunnel to the compute instance’s public IP that forward all traffic to a certain port on localhost (we will use 3406) …[Read more]