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.

11.28, database mapping model, remote mysql server

Discussion in 'E-mail Discussions' started by abrakadabra, Dec 14, 2010.

  1. abrakadabra

    abrakadabra Member

    Joined:
    Dec 14, 2010
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    Hey,

    I'm interested on current status of a multiple cPanel servers connecting to a single remote MYSQL server.
    As far as i understand this functionality should be improved from cPanel version 11.28 with database mapping model.

    Few questions:

    1. Can multiple cpanel servers safely share single remote mysql server?
    2. Does cpanel new account creation gracefully fails to add new account if username already exists on another cpanel server which shares same remote mysql server, thus preventing username collisions?
    3. What happens to databases, such as "roundcubepass" (will cpanel servers fight over ownership to these databases)?


    Thank you,
     
  2. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    3 and 1. Right now, we still use some databases that may have overlapping names (e.g. horde for the webmail program Horde). This can cause potential issues. Another known issue is if you try to transfer an account from one cPanel&WHM server to another that is using that same remote MySQL server, the transfer tool will note the database already exists and that will adversely impact the transfer process.

    We are currently evaluating how to address the overlapping database name issue (Case 44970).

    Regarding the transfers issue, please subscribe to the following thread so you can receive updates via email: http://forums.cpanel.net/f145/accom...ers-sharing-mysql-database-server-171466.html

    2. There is nothing done to prevent collision of cPanel (system) usernames. However, database mapping does offer many advantages over the old database prefixing method with this regard. One cannot create a virtual MySQL user that already exists nor can someone create a database with a name that is already being used. This means a cPanel (system) user doesn't have access to a database (when using database mapping) just because of the name of the database. There's a bit more to it than this, but that's the short and simple version.
     
  3. abrakadabra

    abrakadabra Member

    Joined:
    Dec 14, 2010
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    Ok,

    Account transfer/move between servers won't be a problem, because i can always just create full account backup, terminate account and restore full account backup on another server, instead of using transfer/move functions within WHM.

    As it stands, the only issue i will be seeing is the db name overlapping of "horde", "roundcube", etc..
    Is there any way i can solve that problem?


    Thanks,
     
  4. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
  5. abrakadabra

    abrakadabra Member

    Joined:
    Dec 14, 2010
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    Your comments are greatly appreciated.
    Thank you.
     
Loading...

Share This Page