Hello,

I have a relatively big website so I am trying to serve web from one server and process MySQL on another server.

The problem is that when the website and database are on the same server , website pages are very fast but when I put the website on another server (both are in ev1servers.net) it becomes very very slow (2 seconds in comparison to 8 seconds or slower).

I have tested connection speed using FTP and I was able to transfer 15M Bits/s. Amount of data being transfered for each page is less than 20KBytes and website is not acive yet so this is the only data being transfered between two servers. (so why is it slow?!!!)

1- Would someone please advise if the problem is from connection speed between two servers?

2- Does a "Private Rack" service help with the problem? (as servers are on a dedicated high speed switch)

Regards,
Mac

We are experiencing a similar problem, though it is quite intermittent. The app (a discussion forum) will zip along most of the time, but then slow down horribly and start generating "can't connect to database" errors.

We think the problem is occurring because, for some reason, our database server is in a different EV1 datacenter. We tried connecting over PNET, but that was way slow. We are currently connecting over the public network while waiting for to move to a partial private rack where we can connect the two servers by direct cable.

We don't know what's causing the periodic extreme latency, but we're guessing it's some condition affecting the communications between the two data centers. We should know for sure later this week.

1. Make sure you are using pconnect.
2. Make sure your max connections is not set too low in my.cnf