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!