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.

Remote MySQL configuration

Discussion in 'General Discussion' started by JamesSmith, Apr 19, 2005.

  1. JamesSmith

    JamesSmith Well-Known Member

    Joined:
    Sep 17, 2003
    Messages:
    185
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    UK, Luton
    Hi - We're looking to setup a remote MySQL server, we have the machine purchased and ready to go. We intended to setup multiple processes of MySQL on different hosts / IPs for each of our web boxes on the MySQL server. This we have done.

    The problem we now face is configuring the cPanel web boxes to use the remote server.

    It seems the way cPanel has this implemented, the web server wants to "take over" the remote MySQL host, asking for the root password (not just mysql root), installing cPanel scripts and so on, on the remote MySQL server. This is not ideal, as we want to run multiple MySQL processes on the MySQL server to avoid any database name and username conflicts across our web boxes.

    Is there anyway at all this can be achieved, avoiding the way cPanel wants to do it and simply connect to the MySQL server? We need to get something sorted for this, if nothing can be done with remote MySQL the way we want it, we’re going to need to re-think our strategy of expanding our current capacity. The whole idea was to move MySQL off onto this new powerful remote server, reducing load and increasing performance across the board on our web boxes.
     
  2. dave9000

    dave9000 Well-Known Member

    Joined:
    Apr 7, 2003
    Messages:
    891
    Likes Received:
    1
    Trophy Points:
    16
    Location:
    arkansas
    cPanel Access Level:
    Root Administrator
    I logged a enhancement in bugzilla for something close to what your wanting a while back. What we need is people voting for it and cpanel will add it

    http://bugzilla.cpanel.net/show_bug.cgi?id=2263

    It would probably solve the issues your talking about
     
Loading...

Share This Page