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 Remote MySQL

Discussion in 'General Discussion' started by Silent Ninja, Sep 15, 2008.

  1. Silent Ninja

    Silent Ninja Well-Known Member

    Joined:
    Apr 18, 2006
    Messages:
    198
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Buenos Aires, Argentina
    Hello, I was checking the Remote MySQL setting on cPanel that allows automagical clusterization for the mysql, but I would like to know if there's any posibility to...


    a) Use the same MySQL server to multiple cPanel servers (especially if the servers have repited users in between themselves)... for example:

    SERVER 1: users paul, john, foo
    SERVER 2: users mike, john, carl

    SERVER MYSQL: paul, foo, mike, carl, john & john ?

    The user john is repeted, how is it that cPanel handle files from both servers? Will they work both separarely or this option just works for 1 clustered mysql and 1 web server ?


    b) Will in the future cPanel be able to clusterizate multiple mysql servers for the same server? Something like:

    SERVER PHP
    SERVER MYSQL4
    SERVER MYSQL5

    And the user (or administraror prefferely) will then be able to choose what accounts will be using the MYSQL4 and which others MYSQL5. It would also work as a load balancing by having 2 mysql servers and choosing some accounts on the first one and some others on the second.
     
  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
    You can use 1 remote MySQL server with multiple cPanel/WHM servers. However, reconciling duplicate usernames is not functionality that is natively available at this time. This is something you need to handle if you are going to implement such a setup.

    If this is strictly a shared hosting setup (no resellers etc.), you could build an application that uses the XML-API on multiple cPanel/WHM servers to see if that username is already in use on any cPanel/WHM server. If so, during the sign-up process, the user is prompted for another username.


    I'm not going to venture to speculate here. However, we do have presentation slides that explain how our remote MySQL capabilities work and possibilities for perhaps expanding on such capabilities. You can view these slides at:

    http://www.cpanel.net/conference/08/files/RemoteMYSQLServer.pdf
     
  3. Silent Ninja

    Silent Ninja Well-Known Member

    Joined:
    Apr 18, 2006
    Messages:
    198
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Buenos Aires, Argentina
    I've seen the PDF file, but it doesn't tell me if there will be any chance that on the future I will be able to do what I wanted.

    My ideal of the server would be this:

    PHP SERVER
    MYSQL4 SERVER
    MYSQL4 SERVER
    MYSQL5 SERVER

    Both M4 servers can be selected on the PHP server (there's no load balancing here, you just choose one or the other). M5 can be selected if the user needs to have that access.

    It's kinda easy to setup a MySQL server and install phpMyAdmin, but I would need to manually create eacha account of the user on the corresponding server and give them a separate access to it. I want my clients to create the databases via cPanel and use the internal phpMyAdmin depending on which server I've choosen for that user to use.

    This is impossible now since the cPanel Remote MySQL setup only works or it's only meant to work with one MySQL server (1 local or 1 remote only).
     
  4. jabotto

    jabotto Registered

    Joined:
    Jun 16, 2004
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Mar del Plata - BUE - AR
    Hi,

    cPanel guys should implement a new space name for users “outside” a single Apache/Mysql structure but, on the other hand, I know is a deeply change… meanwhile, I’ve wrote a couple of scripts that plays within "creation account" process and checks for user existence (to avoid duplicates) on other servers (you can configure the server look up list).

    First, checks locally and then performs a servers search until found some user or not. The main process is called by an AJAX code inserted, as mentioned, on the main "creation account" template. Once a user name is "a valid one", the process dispatchs the cPanel's creation procedure. I've tested on many platforms and browsers and works fine.

    No matter if is a strictly a shared hosting setup (no resellers etc.), always works.

    For those interested on, you can contact me... do not fear, it's free and, of course, a GPL code.
     
    #4 jabotto, Dec 5, 2008
    Last edited: Dec 5, 2008
  5. Silent Ninja

    Silent Ninja Well-Known Member

    Joined:
    Apr 18, 2006
    Messages:
    198
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Buenos Aires, Argentina
    It would be good to have the chance to use multiple servers (like windows does), because I'm now mounting a clusterized solution with an apache server, mysql remote, remote mail and ftp. But cPanel doesn't support remote mails (without messing with links and nfs), and it cannot compile (neither does rpm files) to do a remotely apache configuration.

    It would be good to implement some more clustering on cPanel, and stop thinking that you'll allways use only one server for everything.
     
  6. jabotto

    jabotto Registered

    Joined:
    Jun 16, 2004
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Mar del Plata - BUE - AR
    Absolutely!!!

    We needs move to a cluster solution for Apache and Mysql (at least!) due to an increment on dynamic sites over the past years. The relation static/dynamic changed.

    On our case, next step will be the email outside but… what is the cPanel vision regarding such a clusterization? As you mentioned, today is almost impracticable (not impossible)...
     
Loading...

Share This Page