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.

cPanel control separate web and mysql server?

Discussion in 'General Discussion' started by NDanecker, Jul 4, 2010.

  1. NDanecker

    NDanecker Member

    Joined:
    May 24, 2010
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    51
    Location:
    Point Pleasant, NJ USA
    cPanel Access Level:
    Root Administrator
    Can cPanel control separate hardware boxes, 1 for mysql, 1 for Apache and 1 for Mail?

    It doesn't seem to make sense (from a performance aspect) to have 1 box with cPanel, MySQL, Apache and Mail.

    Sorry if this seems academic for you guys. I'm new to both cPanel and Linux so be easy! :eek:

    Thanks! :)
     
    #1 NDanecker, Jul 4, 2010
  2. cPanelJared

    cPanelJared Technical Analyst
    Staff Member

    Joined:
    Feb 25, 2010
    Messages:
    1,840
    Likes Received:
    19
    Trophy Points:
    143
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    cPanel is not designed for this type of configuration. This is planned for a future version, but there is no timeframe for this. That said, cPanel does provide support for DNS clustering. The following section of our documentation explains the DNS cluster feature:

    Guide to DNS Cluster Configuration

    Also, you can use a remote MySQL server. This requires shutting down MySQL on the local server and using only the remote MySQL server. The remote MySQL server does not need to be running cPanel, but you do need to have root access to it. The following section of our documentation explains this feature:

    Setup Remote MySQL Server

    DNS and MySQL are the only features that cPanel can control in any way on remote servers. You are free to host your mail remotely, by modifying your domains' MX records, but cPanel will have no control over the remote mail server. It will not be able to create or remote mailboxes or control the remote mail server in any other way.
     
    #2 cPanelJared, Jul 6, 2010
  3. NDanecker

    NDanecker Member

    Joined:
    May 24, 2010
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    51
    Location:
    Point Pleasant, NJ USA
    cPanel Access Level:
    Root Administrator
    Do you see an advantage to moving MySQL off the hosted web server/cPanel and onto a dedicated MySQL box? And does this box need to be Linux based or can it be MS Server 2008? I certainly wouldn't want to lose the ability to have cPanel control MySQL for database & user creation, updates, etc.

    I like the way Encompass is marketed with being able to move/control separate web servers, MySQL, etc.

    Thanks!

    EDIT: Sorry - I posted this before reading the MySQL page you linked above. Thanks.
     
    #3 NDanecker, Jul 6, 2010
    Last edited: Jul 6, 2010
  4. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,277
    Likes Received:
    9
    Trophy Points:
    313
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    For most situations, the main advantage would be if you built a server from the ground-up intending it to only be a database server and used that as your remote MySQL machine. This allows you to have a purpose-built machine designed to maximize MySQL performance with a cPanel/WHM environment running on separate hardware.

    There is a specific situation where many users are trying to use the MySQL database very much (e.g. a machine hosting many internet forums). In this scenario as well, there would be a benefit to offloading MySQL to another server.

    Situations where it's not such a good idea:
    - You're only hosting a handful of sites that don't heavily use MySQL
    - You're intending to use a MySQL server located far (geographically speaking) from the cPanel/WHM server. Ideally, the MySQL server should be in the same facility, preferably the same rack and on the same switch.
     
    #4 cPanelDavidG, Jul 13, 2010
  5. Miraenda

    Miraenda Well-Known Member

    Joined:
    Jul 28, 2004
    Messages:
    243
    Likes Received:
    3
    Trophy Points:
    168
    Location:
    Coralville, Iowa USA
    cPanel Access Level:
    Root Administrator
    Another big benefit of having a remote MySQL machine could be security. Because that machine would only have MySQL running on it, all connections to it other than the cPanel server could be blocked. This would allow only the ports needed for MySQL and SSH (to edit settings) to be opened and all others that might be attacked shut off entirely. It's a lot easier to lock down a machine that is only running one service (MySQL).
     
    #5 Miraenda, Jul 13, 2010
(You must log in or sign up to post here.)
Loading...
Similar Threads - cPanel control separate
  1. Miguel G

    Cpanel SSL certificates get The system failed to fetch the DCV (Domain Control Validation)

    Miguel G, Nov 15, 2016, in forum: Security
    Replies:
    3
    Views:
    487
    cPanelMichael
    Nov 15, 2016
  2. martin MHC

    cPanel Control Panel "Last Login" clarification

    martin MHC, Oct 25, 2016, in forum: General Discussion
    Replies:
    3
    Views:
    664
    cPanelMichael
    Oct 28, 2016
  3. Wabun

    cPanel Market not showing in control panel

    Wabun, Jun 10, 2016, in forum: General Discussion
    Replies:
    2
    Views:
    715
    cPanelMichael
    Jun 16, 2016
  4. jds1

    New Thread Cannot Install WordPress 4.8.1 cpAddon in cPanel 66

    jds1, Aug 22, 2017 at 7:34 PM, in forum: General Discussion
    Replies:
    0
    Views:
    23
    jds1
    Aug 22, 2017 at 7:34 PM
  5. rappie

    cPanel notifications when EXIM is disabled

    rappie, Aug 22, 2017 at 12:14 PM, in forum: E-mail Discussions
    Replies:
    1
    Views:
    21
    cPanelMichael
    Aug 22, 2017 at 12:23 PM

Share This Page