a year ago
Hi there,
I am aware this pertains more to GCP but hoping to see if anyone here has some advice that is perhaps more applicable to Railway.
I have a GCP CloudSQL Database that I am trying to connect to from my Railway services. My current method of Authenticating with my GCP database is to whitelist inbound IP addresses. Unfortunately, to get a static IP address from Railway I need to upgrade to the Pro plan. Now, even if I did do this, it is mentioned in the documentation that these IP addresses can change sometimes and are often shared with other customers. I am aware that utilising the 'IP whitelist' method is not the best but I am not really sure how to set up alternate methods that work with say, a NextJS app?
Has anyone had similar issues and has a good guide/solution on how to connect/auth to a CloudSQL database in a non-ip-whitelist way?