Need a solution for a high traffic video site

Discussion in 'Site & Server Administration' started by heropage, Feb 28, 2008.

0
  1. #1
    My video sharing site has high traffic, alexa rate:3,000
    My site has 2 servers to split the load. 2 servers share a mysql server. Using rrdns to load the balance.
    Server A running mysql 5.0,lighttpd
    Server B running lighttpd.
    Server B connect to A's mysql database.

    During peak time. B can not connect to A's mysql server. It says server not responding. But A still running fine.
    When I check mysql log file.
    /usr/libexec/mysqld: Forcing close of thread .....

    And when run top, the load average is 20.

    The spec of Server A
    Intel(R) Xeon(TM) CPU 3.06GHz dual core.
    2G Ram.

    Here is the my.cnf
    My question, do I need another maching C to run lighttpd, and just keep mysql on A.
    Or I can do some mysql optimization on A.

    Also, if my site keeps going, can I have 1 mysql server and 5 http servers?

    I need a good solution.

    Thank you
     
    heropage, Feb 28, 2008 IP
  2. jamesmoey

    jamesmoey Peon

    Messages:
    34
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Answer already posted on webhostingtalk.com
     
    jamesmoey, Feb 29, 2008 IP
  3. gate2vn

    gate2vn Peon

    Messages:
    809
    Likes Received:
    33
    Best Answers:
    1
    Trophy Points:
    0
    #3
    You might need to optimize your mysql again. Cannot say exactly what needs to be changed, cause it really depends on the current status values. Putting more RAM into server A would help too.
     
    gate2vn, Feb 29, 2008 IP