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.

External dedicated mysql and email server

Discussion in 'E-mail Discussions' started by bizzness, Nov 18, 2004.

  1. bizzness

    bizzness Member

    Joined:
    Feb 25, 2004
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    I would like to know if it's possible to explode the architecture in order to have an external mysql server ans email server, managed by cpanel, in order to have bests êrformance.

    Regards

    Bizzness
     
  2. wills

    wills Well-Known Member

    Joined:
    Jan 29, 2003
    Messages:
    202
    Likes Received:
    1
    Trophy Points:
    18
    I'm going to dig this post up :)

    I too would like to see something like this. Is this even remotely possible with cPanel?
     
  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
    Setting up a remote MySQL server is possible. In WHM, on the left side of the screen scroll past the "SQL Services" header and click on "Setup Remote MySQL Server" and fill in the information on the screen so cPanel and WHM can communicate with the remote MySQL server.

    Regarding external e-mail servers, currently the most you can do is edit the MX entry in DNS, but that means that cPanel's mail features will be worthless since they do not actually affect the external mail server.
     
  4. wills

    wills Well-Known Member

    Joined:
    Jan 29, 2003
    Messages:
    202
    Likes Received:
    1
    Trophy Points:
    18
    Thanks for the info David. One more question, after setting up the remote MySQL server, do we need to run the local MySQL services? Will it be utilized for anything?
     
  5. SoftDux

    SoftDux Well-Known Member

    Joined:
    May 27, 2006
    Messages:
    983
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Johannesburg, South Africa
    cPanel Access Level:
    Root Administrator
    I have to say, it would be a great idea if some of the services, like MySQL & Email could be "split up" in order to run on another server. My question is this, if you set the MySQL server to run on another server, and a user on server A creates a MySQL, is it automatically created on server B?
     
  6. wills

    wills Well-Known Member

    Joined:
    Jan 29, 2003
    Messages:
    202
    Likes Received:
    1
    Trophy Points:
    18
    Yep. That's the idea behind this whole thing. I got my remote MySQL server setup and I see that cPanel setups the database remotely. Nicely done! A feature that has been long awaited by the most of us :)
     
  7. SoftDux

    SoftDux Well-Known Member

    Joined:
    May 27, 2006
    Messages:
    983
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Johannesburg, South Africa
    cPanel Access Level:
    Root Administrator
    That's good to hear.

    Quick question: what's the real benefit from doing this?

    Let's think about this, apart from needing two servers with the same amount of space, one will also need a lot of bandwidth. And if you have a particularly busy site, network lag could be a problem, especially if the MySQL server is with another host. Also, how will server B know what the MySQL quota should be for the different users?
     
  8. wills

    wills Well-Known Member

    Joined:
    Jan 29, 2003
    Messages:
    202
    Likes Received:
    1
    Trophy Points:
    18
    Let's see:

    1. Less I/O on a server that's supposed to be a web server. Adding a high transactional application server only increase the disk I/O and MEM usage.

    2. If you're servers are next to each other, which should be, then there is no lag :) Well a 1ms lag but c'mon! Besides, that's how we have MS-SQL servers setup, I don't see customers complaining about the network latency.

    3. Since cPanel has developed this, you can be sure that the quota is still provisioned on the remote server.
     
  9. 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
    It's been a while since I've come across this thread... sorry for not answering sooner on the previous questions.

    The main reason people generally do this is to remove the CPU drain of processing SQL queries (especially more complicated ones involving joins and such) off the primary server and onto a secondary server. This is generally most useful if a single server has websites that are database intensive.

    Also keep in mind that in almost all scenarios, the Database Server and cPanel/WHM Server are on the same network to reduce latency/bandwidth issues. However, this setup is useful only if the time taken to transfer queries to the remote server, process them on the remote server and send back the results is less than if they had been done locally.
     
Loading...

Share This Page