9 months ago
Hi, I am using Prisma + Next.js deployed on Vercel, and communicating over public network with my Railway SQL database. This has been working fine for me, however I started traveling overseas and now I am having a hard time developing or communicating with the database at all because I constantly receive Can't reach database server at '[roundhouse.proxy.rlwy.net](roundhouse.proxy.rlwy.net)': 40050
. I have already looked through this Discord for solutions and implemented what was suggested here: https://stackoverflow.com/questions/68476229/m1-related-prisma-cant-reach-database-server-at-database5432, which helped a little bit but still inconsistent with my ability to connect + query. I believe this issue is very common for me now as I am in Asia and communicating with my db that is located in US East. How can I resolve or fix this? Is there something else I can do with Prisma to remedy this issue? My belief and reason for this post is that the issue is coming from Railway's ability to handle and serve requests that are across the globe and not near the region where most of my usage normally happens. Any help <@539512869780455445> would be greatly appreciated, thank you!
0 Replies
9 months ago
Railway is very good at handling requests from around the globe as they use edge proxies, you being in Asia means your request is handled by the edge proxy in Singapore and then routed internally to the us-east region.
but you can try to move the database to the Singapore region to reduce latency even further.
most of my customers are in US and east coast so that wouldn't make sense as solution, I just need to figure out how to connect + query consistently with Prisma when I am working abroad for the next few weeks
tomorrow I could try interacting with the db directly outside of Prisma and see how performance/reliability is
9 months ago
it could be an issue with the network with your internet?
just wondering if seen others run into this issue before (specifically with Prisma) and there is a common fix
9 months ago
the only issues I've seen in this regard would be networking issues on the users side of things
but generally unable to develop my Next.js project because db connections fail consistently, but network wise I am able to take Zoom calls etc no problem
If it does though that would confirm its a Railway issue and nothing with my personal network or Prisma
9 months ago
sounds good
9 months ago
no problem
9 months ago
to clarify, are you receiving this error when connecting to the database from your nextjs deployment (on railway) or from your development server (on your computer)
I tried running nc
command with both VPN off and on, seems to make a difference and works when its on
9 months ago
where are you vpn'ing to?
9 months ago
does your vpn have a Singapore region?
9 months ago
yes please
I guess its better for me to stay on Singpapore and let railway edge handle it for me?
9 months ago
i know you said youre in asia, but if its all right with you could you be a little more specific?
and will be going to Japan soon, before going back to US east where my company is based
9 months ago
can you send the specific nc command you used?
9 months ago
@alex - are you still in Indonesia, can you run that command for me? without a VPN
9 months ago
helo
9 months ago
@Brody any recommendations on what setup I should be using for best performance while in Asia? ie VPN to Singapore or US etc
9 months ago
novpn
9 months ago
what hotel are you in bro
9 months ago
check your isp rq
9 months ago
What the hell
9 months ago
hotel firewall is a big possibility
9 months ago
alex, you are staying at a residential house right?
9 months ago
yeah
9 months ago
our internet goes through a different pipe than the hotel, I believe
9 months ago
I can try hotel wifi but that means i have to go downstairs
ok but while I'm here and need VPN to fix, should I just connect to any local asia location and let railway edge handle requests? or connect back to US servers
9 months ago
use singapore imo
9 months ago
use the closest server to yourself to make the internet experience more bearable
9 months ago
i usually use the closest server that works
9 months ago
yeah id go with that too, google's continental datacenter connection is likely faster than your vpn
9 months ago
@bebop btw what bpm are you using
9 months ago
Vpn *
9 months ago
Based
9 months ago
Even more based
9 months ago
Buy it through a reseller like tailsvwle
9 months ago
Then you get more utility for your lonely
9 months ago
Money*
9 months ago
Although I guess that defeats the purpose of using mullvad
9 months ago
no problem!
9 months ago
you're pro right?
jw if other customers of urs have been able to get compliant etc without needing to migrate
9 months ago
theres this that was posted 4 months ago -
> Compliance Trust Center
>
> Because we were busy setting up our on-prem locations, currently we manually provide documents and bridge reports to customers needing to fulfill their SOC2 obligations. We are now pursuing our audit in earnest, and while we work to meet our auditors standard- we plan to make more of our security posture and architecture to our Business Class customers in an improved fashion.
with the wording used you may need to be on their enterprise plan, you can ask for more info by opening a private thread here -
def something to take care of Railway's end, if you want to support real business + enterprise customers outside of projects etc I think its a non-negotiable
9 months ago
its just at a bit of an odd time right now with the transfer to bare metal, but be sure to open that private thread so you can talk to the team about it