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.

Multiple cPanel web server with one remote mysql Cluster

Discussion in 'Database Discussions' started by Spyros, Jan 26, 2016.

  1. Spyros

    Spyros Member

    Joined:
    Jul 1, 2014
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Athens, Greece, Greece
    cPanel Access Level:
    Root Administrator
    Hello,

    I have implement a Mysql cluster under one ip and i was possible to setup a cpanel web server for remote mysql access. also cluster work with some autonomous web servers.

    My problem is that i need to point 3 cpanel web server to the same mysql cluster. how can i do that without brake cpanel functionallity? i saw that when connect my web server for remote connection with the cluster , it create all database that cpanel need to be functional.


    Many Regards,
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

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

    You may find the following document helpful:

    Manage MySQL® Profiles - Documentation - cPanel Documentation

    In particular:

    While it may function, keep in mind that some database names are always the same on cPanel servers. EX:

    eximstats
    cphulkd
    modsec
    leechprotect
    whmxfer

    You will need to take this into account if you are using the same MySQL serer for multiple cPanel servers. Also, note a feature request for this also includes a helpful comment:

    Remote mySQL server for multiple cPanel server

    Thank you.
     
Loading...

Share This Page