Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Multiple mysql remote servers

Discussion in 'General Discussion' started by copilas12, Oct 13, 2009.

  1. copilas12

    copilas12 Registered

    Joined:
    Aug 1, 2008
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    51
    Hey guys.

    I want to make something like this:
    -i have a cpanel web server, let's say: 192.168.1.2
    -i have a mysql server with 4 mysql running instances on 4 different ports with 4 IP's: 192.168.1.3:1234 ; 192.168.1.4:1235 ; 192.168.1.5:1236 ; 192.168.1.5:1236

    I want to know if i can setup all these servers for remote mysql in cpanel. What i need is that when i create a new account, and when i login to cpanel, when i click mysql databases, i want to select the remote server where i will create the database.
    Can this be done ?
    It works with one remote mysql server with standard port.
    Any help or ideas will be appreciated.
    Thanks,

    Raul
     
    #1 copilas12, Oct 13, 2009
  2. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,554
    Likes Received:
    9
    Trophy Points:
    168
    Location:
    Houston, Texas, U.S.A.
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    At the present time only one MySQL server is supported at a time. While it would involve more setup work, it is technically possible to manually install and configure a custom phpMyAdmin installation, and then also manually configure any hosted scripts to use the desired MySQL server hostname or IP address and applicable port numbers.

    I recommend to consider requesting multiple MySQL server functionality as a feature request in the following area on our forums; this will help bring more attention to your request and if enough interest gathers it may be considered for implementation:
    Feature Requests for cPanel and WHM - cPanel Forums
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelDon, Oct 13, 2009
  3. Spiral

    Spiral BANNED

    Joined:
    Jun 24, 2005
    Messages:
    2,023
    Likes Received:
    8
    Trophy Points:
    193
    Can this be done? Absolutely and I have done it many times!

    However, this is something that has to be done manually and there is a bit of work to get it working correctly and a bit more work to prevent Cpanel from blowing it away at the next system update.

    Unless you are already very comfortable setting up MySQL clustering, I would highly advise against setting up such a configuration anyway.
     
    #3 Spiral, Oct 13, 2009
  4. copilas12

    copilas12 Registered

    Joined:
    Aug 1, 2008
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    51
    Hey

    Thanks for your responses.
    I will think about clustering, but right now i have all those 4 mysql servers into one linux server.
    So i wanted without clustering and proxy and roundrobin

    Spiral, can you give me a clue for starting? Or what to consider for starting ?
    Or some steps that i have to make.

    Thanks.
     
    #4 copilas12, Oct 14, 2009
(You must log in or sign up to post here.)
Loading...
Similar Threads - Multiple mysql remote
  1. geekbaaz

    Multiple cPanel servers with a common MySQL server?

    geekbaaz, Jun 21, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    122
    cPanelMichael
    Jun 21, 2018
  2. urgido

    Multiple MySQL Processes

    urgido, Sep 21, 2016, in forum: CloudLinux
    Replies:
    10
    Views:
    2,424
    Bazinga
    Oct 18, 2016
  3. arunnair555

    Multiple WHM/cPanel servers transfer to a single WHM/cpanel account

    arunnair555, Aug 16, 2018 at 4:54 AM, in forum: General Discussion
    Replies:
    1
    Views:
    29
    cPanelMichael
    Aug 16, 2018 at 11:52 AM
  4. K Pork

    WHM with Multiple Custom Name Servers

    K Pork, Aug 15, 2018 at 11:26 AM, in forum: General Discussion
    Replies:
    3
    Views:
    35
    cPanelMichael
    Aug 15, 2018 at 11:38 AM
  5. ShuiLeeHnetinka

    Host multiple domains on one account?

    ShuiLeeHnetinka, Aug 8, 2018, in forum: General Discussion
    Replies:
    2
    Views:
    57
    cPanelMichael
    Aug 9, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice