The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

2 Servers one for sql and another for forum files

Discussion in 'General Discussion' started by ASTRAPI, Sep 17, 2009.

  1. ASTRAPI

    ASTRAPI Well-Known Member

    Joined:
    Jul 8, 2008
    Messages:
    321
    Likes Received:
    0
    Trophy Points:
    16
    Hello

    I was wondering how can i setup this scenario as many users recommend it in high traffic forums.

    1)Let's say server one for my forum files (php) i will need a server using Centos and cpanel and nothing else i think or...

    2)Second server must have centos (32 or 64bit does matter?) and mysql only in it.

    3)So i will be able to upload my db to the second server using ssh as in the past?

    4)How can i connect both servers so my forum start working?

    5)Someone told me using Whm but which tool and how?

    Thank you
     
  2. thewebhosting

    thewebhosting Well-Known Member

    Joined:
    May 9, 2008
    Messages:
    1,201
    Likes Received:
    1
    Trophy Points:
    38
    Two connect two servers you will have to do a dns clustering which will connect two cpanels servers.
     
  3. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    This will do nothing for setting up a remote MySQL server to work with cPanel/WHM.
     
  4. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Also be sure to have Perl 5.8 installed on the MySQL server. For CentOS, 32-bit vs. 64-bit doesn't matter as far as cPanel software compatibility is concerned.

    Yes, just be sure to SSH to the MySQL server rather than the cPanel/WHM server.

    Yes, we have a tool in WHM. Go to WHM -> SQL Services -> Setup Remote MySQL server and complete the information in the wizard-like interface.

    Note, this tool does not move user databases, so set this up *then* import your databases (if you intend to do this via SSH).
     
  5. ASTRAPI

    ASTRAPI Well-Known Member

    Joined:
    Jul 8, 2008
    Messages:
    321
    Likes Received:
    0
    Trophy Points:
    16
    @cPanelDavidG

    Thnak you great.

    I am looking for the last answer about if i need on both servers cpanel as i think i don't for the sql server and a video tutorial or pdf about that?

    Do i have to do also those settings?

    Code:
    http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html
    Or any other system settings?

    Thank you
     
    #5 ASTRAPI, Sep 18, 2009
    Last edited: Sep 18, 2009
  6. Spiral

    Spiral BANNED

    Joined:
    Jun 24, 2005
    Messages:
    2,023
    Likes Received:
    7
    Trophy Points:
    0
    First, you should disregard all previous posts in this thread! :rolleyes:

    Second .... read carefully and I'll try to get you on the right track: ;)

    Doing what you ask (separate dedicated MySQL server) can help performance under certain conditions but trying to reduce the traffic load on a single high traffic forum site, really not the best solution and can actually even DECREASE the performance of your site just the exact opposite of what you had intended!

    You would be much better off using a caching reverse proxy front end to more efficiently handle connections and content delivery which should greatly enhance performance and traffic load handling abilities. This could be further enhanced by the separate database technique you asked about but by itself alone and for a single site, the cost in resources and work to deploy would significantly outweigh the limited gains you would get in doing that.

    Regarding your side footnote 32 bit or 64 bit question ..... 64 bit always gives much better performance and since all current processors support 64 bit and the missing library issues of old days long ago are more of a footnote in history now, I really do not see any reason not to go with 64 bit on ALL server deployments! As far as what would work best with Cpanel, CentOS 5.3 64 bit works amazingly well and what I have had the most consistent working installs!
    Are you talking about MySQL management on a MySQL clustered server?

    There is no difference .... operation is the same except that you would no longer use "localhost" as the database server with your programs. ;)

    (Well, not the way you are thinking and asking about doing it at least ;) )

    It's beyond the scope of this post, but there is another way to setup your MySQL called "Database Clustering" which similar to it's DNS counterpart, allows you to run databases on both machines and keep the contents of those databases in perfect synchronization allowing you to split the traffic loads between the two servers. Unfortunately, Cpanel does not directly support MySQL database clustering at this time but is not overly difficult to setup manually.

    I am not sure I follow the exact question you are asking here. Are you asking about what to put in your configuration settings fro your program or how to setup the servers?

    WHM is the administrative management front end to Cpanel. It can be configured to allow for external MySQL database connections but does not itself support "MySQL Clustering" which is something entirely different and closer to what you are asking about doing. For this, you must setup your database server and the links to it from your other server(s) manually.

    Just simply using WHM to link to a MySQL server on another server alone and could actually REDUCE your performance instead of improving it!

    If you are needing to find a solution to handle traffic loads better, I can certainly help you with that if you want to contact me. I have extensive experience setting up separate MySQL servers just as you have inquired but I am not convinced that is your best option based on what you have posted. A dedicated MySQL server is only one of item in a long list of things you can do to improve your performance and traffic handling capabilities for your site and not even necessarily the best one especially given the additional resources and management concerns required which might be better utilized in other far more effective ways!


    PS: To 'thewebhosting' ... As CpanelDavidG pointed out ahead of me, DNS Clustering has absolutely nothing to do with full server Apache site mirroring and / or MySQL clustering! Those are totally different topics entirely!
     
    #6 Spiral, Sep 18, 2009
    Last edited: Sep 18, 2009
  7. ASTRAPI

    ASTRAPI Well-Known Member

    Joined:
    Jul 8, 2008
    Messages:
    321
    Likes Received:
    0
    Trophy Points:
    16
    My main problem is that i own a forum and many hours per day i have a very high traffic and the forum needs 15-30 seconds to open any topic.

    I already contact some companies that specialize on that situations and after checking my server they told me that the problem is my cpu and sql.
    I need to do it faster and able to handle more connections per second.

    So does splitting forum files and database on 2 servers will fix my problem?

    I just want to be able to handle and process more requests per second.

    Thanks all of you

    My curent server specifications are:
    Dual Core Xeon 3065 (2.33GHz, 4MB, 1333MHz FSB)
    4gb ram
    and 100mbit unshared
     
Loading...

Share This Page