Results 1 to 8 of 8
  1. #1
    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.

  2. #2
    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.

  3. #3
    Join Date
    Mar 2004
    Location
    Los Angeles
    Posts
    622
    Our MRTG/Rrdtool graphs showing similar.

  4. #4
    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!

  5. #5
    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.

  6. #6
    Join Date
    Oct 2001
    Location
    Ann Arbor, MI U.S.A.
    Posts
    218
    I have no idea of what that database is doing
    This is where I'd start your search. Check out 'mytop' to view what queries are being run, or turn on query logging.

    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.
    Yep.

    Chris
    Chris Wells [clwells - at - nexcess.net]
    Nexcess - Beyond Hosting
    Dearborn, MI DC ● Southfield, MI DC
    Wordpress Hosting, Magento Hosting & More!

  7. #7
    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.

  8. #8
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •