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 Remote Mysql instance

Discussion in 'Database Discussions' started by mahdy_sharifi, Sep 15, 2014.

  1. mahdy_sharifi

    mahdy_sharifi Well-Known Member

    Joined:
    Feb 26, 2012
    Messages:
    177
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Hello :

    Is it possible setup 2 remote mysql instance ? even with manually setting ?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Could you elaborate on the type of configuration you are planning? For instance, do you mean you want the databases hosted on both remote MySQL servers, or half of the databases on one server and half on the other?

    Thank you.
     
  3. mahdy_sharifi

    mahdy_sharifi Well-Known Member

    Joined:
    Feb 26, 2012
    Messages:
    177
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    half of the databases on one server and half on the other

    Regards
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    There is no native support for this type of configuration. You would have to manually setup the second remote MySQL server and update the configuration files for your scripts that use databases on that server so they connect directly to that MySQL server's IP address. All database activity for the second MySQL server would have to be handled manually on that server.

    Thank you.
     
Loading...

Share This Page