Due to server load issues on my current dedicated server, I'm planning to get a second server which I'll run just as a mysql server, while all files are on the original server.

I'd like to figure how much bandwidth I should look for on the second server. I'm confused about how much bandwidth would be used by a server which does not have any html or php files accessible by the browser, but just handles the mysql data.

Is there a general rule of thumb I should consider for this?

Hi,

I asked this in the past to my Server Admin. He said that the accesses to the MySQL don't consume bandwidth.

Regards.

Carlos Cadena.

If you access a MySQL database on the same server, it doesn't consume bandwidth. If it's on a different server, it will. I'm not sure about it, it depends on how often the database is accessed, and how much data is pulled. See if you can get the MySQL server on a local/internal network with your other server, that way you don't have to pay for bandwidth costs.

- Matt

run:

# mysqladmin -u<yourusername> -p'<password>' extended-status

it will return many nice stats, among which are Bytes_send and Bytes_received

at the bottom, you will get Uptime (in seconds). Now, take out that calculator and do some math to derive bandwidth per month. it should not be too much at any rate, I'd bet that 100Gigs would cover even the most extensive mysql usage, especially if you employ output caching.

If you use colocation you could just plug your mysql server into a second network card on your main server (use a cross-over), and it would eliminate any use of bandwidth (free!).

It's not a good idea to have your SQL server live to the world anyhow. You should either do some VLANs or a crossover cable :)

To get the data from the mysql query from a physically different server means that the data gets sent back uncompressed to the 'web' server which then has the option of sending it gzip compressed to the requesting client

If you have very busy forums this uncompressed traffic could be 10+ gigs a day just from the result of mysql queries alone

you could also look at servermatrix.com offers. If you move the both servers there you can get free connection between both boxes via second nics for $25/mth