Slow connection to db server from another server
Hi,
I have two servers, one with mysql db and other with app service. DB requests from app server to db server takes forever, while when app is on the same server as db, it's quite fast.
What could I be doing wrong?
1 Reply
bbigger
Linode Staff
Hey there! Not sure what differences you're seeing, but if your Linodes are in different data centers, latency will likely have a big impact on your app/database performance.
Otherwise, there may be networking issues between your Linodes that are interfering. We recommend running MTR reports between your two servers (both ways) to detect routing issues that may be slowing down your response times. To ensure the reports give us a clear picture, we recommend running them like so (note that this can take several minutes to complete):
mtr -rwzbc100 $ipaddress
You can then open up a Support ticket including your MTR outputs and we'll do what we can to resolve any detected problems.