Results 1 to 8 of 8
  1. #1
    Join Date
    Dec 2002
    Posts
    82

    Massive Mysql Usage - Recommendations

    Our site currently uses InvisionPowerBoard and have around 550+ users on at peak times in a 60 minute interval. The site and forums are integrated together and the server load buckles at times.

    We have already looked at using other software, but choose not to go that route because we have spent months working on the different codings using InvisionPowerBoard.

    We have a 2.8 ghz server with hyperthreading and 1024 ram.

    We are going to be expanding soon and using the same database we are planning on adding a different site of the same size.

    So in essence, we will double the use of this one single mysql database if not more. What is recommended to handle such a load? What type of server upgrade or load balacing?

    Thanks much.

  2. #2
    Join Date
    Feb 2003
    Location
    Potsdam, NY
    Posts
    648
    just throw your database on another server, a dual xeon 2.8 would be good. SCSI would also be a very good idea.

    Leave the server you have now for simple HTTP requests.

  3. #3
    Join Date
    Nov 2004
    Location
    Dallas
    Posts
    740
    Load balancing may be useful or like 2uantuM said, 2 servers, one for the database may be useful too

  4. #4
    Join Date
    Jan 2003
    Posts
    1,715
    Forums are read-mostly. Adding enough RAM (probably another gig) to hold the whole database in disk cache would go a long way.
    Game Servers are the next hot market!
    Slim margins, heavy support, fickle customers, and moronic suppliers!
    Start your own today!

  5. #5
    Try MySQL's builtin query caching as well for read-intensive applications.

    HTH,
    Brian

  6. #6
    Join Date
    Nov 2003
    Posts
    385
    definitely use SCSI

  7. #7
    It would be a far better investment, as hiryuu suggested, for memory. A gigabyte of additional memory will yield a much better return than adding SCSI hard drives.

  8. #8
    Join Date
    Dec 2002
    Posts
    82
    Thanks for the reply guys, will consider.

Posting Permissions

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