Railway IP whitelist

I have a mysql database in Vultr that needs an IP whitelist so that it can be accessed from an Appsmith project that is in Railway. I have seen a solution, which is not ideal, which is to make a whitelist of all IPs in the Google Cloud installation zone where the project is located. But it doesn't seem very secure for a production site. Has anyone come up with a better way? Since I imagine this problem must happen to a lot of users, there should be a sufficiently secure solution. Ideally a static IP. Any solution from someone who has had this happen to them? thanks!
7 Replies
Percy
Percy2mo ago
Project ID: N/A
Brody
Brody2mo ago
railway does not yet offer static IPs. the secure solution would be to run the database on Railway and connect to it via the private network
sebak2003
sebak20032mo ago
Oh, but the connection is to a wordpress site that is already in production on a Vultr server.
Brody
Brody2mo ago
run it on railway too
sebak2003
sebak20032mo ago
It's not my site to move it. It's an ecommerce production site.
Brody
Brody2mo ago
fair enough
ThallesComH
ThallesComH2mo ago
if you really need to restrict the connection to the database you could whitelist GCP's entire IP Block and then use a VPN to access the database tailscale should work for your case