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!

two servers Cpanel + one server mysql

Discussion in 'General Discussion' started by hostserver, Jul 23, 2007.

  1. hostserver

    hostserver Active Member

    Joined:
    May 27, 2005
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    151
    cPanel Access Level:
    Root Administrator
    Hi.

    Two servers Cpanel and one server of a database mysql. If to create identical accounts on a server, the database mysql will be the general for these accounts. How to adjust Cpanel, that at creation of new accounts there would be no duplicates.


    Thanks.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    166
    If you want to have a web front end and a database server, just use the script in whm to setup a remote database server.

    After this is established, any new account will use the remote connection. You can then move databases over the the new db server or leave them on the original and use local.

    phpmyadmin will reflect either local or the remote address of the database server currently configured. The connection script is not failsafe and may require manual setup as well.
     
  3. hostserver

    hostserver Active Member

    Joined:
    May 27, 2005
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    151
    cPanel Access Level:
    Root Administrator
    ok.

    server1 -> mysql server <- server2

    Create account testing (server1) + create mysql user testing
    Create account testing (server2) + create mysql user testing

    Mysql server <- testing(server1) = testing(server2)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

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.
    Dismiss Notice