Results 1 to 8 of 8
-
12-07-2004, 07:57 PM #1Web Hosting Master
- Join Date
- Mar 2004
- Location
- Los Angeles
- Posts
- 622
cluster server, and internal bandwidth metering
Hi,
We have ran into a very strange thing, and i wonder if any of you has experienced a similar thing.
Lets say we have 2 servers at the same network, one is a server with only mysqld installed on it. The other server is the web server which is querying the cluster db pretty busy like 15-20 queries/sec. Internal bandwidth between this two servers seem like 20-25 mbit on MRTG. Sure this seems buggy, MySQL queries at 20-25 mbits must be funny, it must be seeing the bandwidth very wide because of the very small text transfers i am not sure.
We have blocked all the ports excluding the mysql to see if thats related to another issue but no.
We can not prove the datacenter this, so if any of you had similar issues in the past, i would appreciate your advises on this matter.
-
12-08-2004, 04:52 AM #2Junior Guru
- Join Date
- Oct 2002
- Posts
- 229
have you installed a mrtg/snmp on the mysql server
to see if you get the same results as your host ?
it might be a problem with their switch.
-
12-08-2004, 07:25 AM #3Web Hosting Master
- Join Date
- Mar 2004
- Location
- Los Angeles
- Posts
- 622
Our MRTG/Rrdtool graphs showing similar.
-
12-08-2004, 10:01 AM #4Junior Guru
- Join Date
- Oct 2001
- Location
- Ann Arbor, MI U.S.A.
- Posts
- 218
We have a couple groups of boxes setup like this and 20 - 25Mbps for a large, busy DB driven site is *not* abnormal. We've seen 40+ Mbps for some of our sites. The best thing to do is to get your own switch and run the MySQL DB on an internal network over the switch. You'll also need dual nics in each of your servers which access the DB server so you can aggregate internal/external traffic (and thus avoid being billed by your provider for bandwidth used).
Chris█ Chris Wells [clwells - at - nexcess.net]
█ Nexcess - Beyond Hosting
█ Dearborn, MI DC ● Southfield, MI DC
█ Wordpress Hosting, Magento Hosting & More!
-
12-08-2004, 11:02 AM #5Junior Guru
- Join Date
- Oct 2002
- Posts
- 229
I have no idea of what that database is doing,
but unless its transfering huge chunks of data from
one single query I don't see how that server could
do that much with 15-20 queries / second.
-
12-08-2004, 12:07 PM #6Junior Guru
- Join Date
- Oct 2001
- Location
- Ann Arbor, MI U.S.A.
- Posts
- 218
I have no idea of what that database is doing
but unless its transfering huge chunks of data from
one single query I don't see how that server could
do that much with 15-20 queries / second.
Chris█ Chris Wells [clwells - at - nexcess.net]
█ Nexcess - Beyond Hosting
█ Dearborn, MI DC ● Southfield, MI DC
█ Wordpress Hosting, Magento Hosting & More!
-
12-08-2004, 06:01 PM #7Web Hosting Master
- Join Date
- Mar 2004
- Location
- Los Angeles
- Posts
- 622
Simple sort/read queries. Not much big things. I am trying to cap the bandwidth to a 1 mbit through shaper/tc but not yet.
-
12-08-2004, 08:18 PM #8Web Hosting Master
- Join Date
- Jan 2003
- Posts
- 1,715
MRTG is probably right.
You will often see horridly coded applications (PHP Nuke) running queries like
mysql_query("SELECT * FROM tablename");
$count = mysql_num_rows();
That will proceed to download the entire table to the PHP server.Game Servers are the next hot market!
Slim margins, heavy support, fickle customers, and moronic suppliers!
Start your own today!