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.

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:
    1
    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.
     
  2. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    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:
    1
    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)
     
Loading...

Share This Page