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!

CPanel - mysql clustering

Discussion in 'Bind/DNS/Nameserver' started by sowell, Jun 26, 2007.

Page 1 of 2
  1. sowell

    sowell Member

    Joined:
    Jun 26, 2007
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    51
    Is it possible with cpanel to do mysql clustering where sql will reside on a server outside the webhosting environment??? Would it even make sense to do such a thing?

    We are in the midst of trying to configure a scalable, easy to use solution and we are extremely interested in cpanel so i am just curious if this is possible.



    </firstpost>
     
    #1 sowell, Jun 26, 2007
  2. dalem

    dalem Well-Known Member
    PartnerNOC

    Joined:
    Oct 24, 2003
    Messages:
    2,781
    Likes Received:
    94
    Trophy Points:
    353
    Location:
    SLC
    cPanel Access Level:
    DataCenter Provider
    its posible
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 dalem, Jun 26, 2007
  3. hostmedic

    hostmedic Well-Known Member

    Joined:
    Apr 30, 2003
    Messages:
    544
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Washington Court House, Ohio, United States
    cPanel Access Level:
    DataCenter Provider
    Very Easy

    In short - this is very simple to do.

    What you would do - is add a server into your network with a private IP
    add a private IP into your local machine - (suggest a gigabit connection :) but thats just me )

    now go into WHM and setup a remote SQL server...


    You can change the MySQL server from the local server ("localhost") to point to a remote server. This allows MySQL functions to be performed by another computer.


    Steps

    1 To access the SQL Services Menu, click on SQL Services, on the main screen of your WebHost Manager interface.

    2 Click on Setup Remote MySQL server.

    3 Enter the name (or ip) of the remote server in the Remote MySQL Host field and its password in the Remote Mysql Host's Root Password field.

    NOTE: Do not enter the root password for the remote MySQL server in the Remote MySQL Host's Root Password field.

    4 Click on Setup.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 hostmedic, Jun 27, 2007
  4. hostmedic

    hostmedic Well-Known Member

    Joined:
    Apr 30, 2003
    Messages:
    544
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Washington Court House, Ohio, United States
    cPanel Access Level:
    DataCenter Provider
    btw welcome

    By the Way - welcome to the community -
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 hostmedic, Jun 27, 2007
  5. hostmedic

    hostmedic Well-Known Member

    Joined:
    Apr 30, 2003
    Messages:
    544
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Washington Court House, Ohio, United States
    cPanel Access Level:
    DataCenter Provider
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 hostmedic, Jun 27, 2007
  6. sowell

    sowell Member

    Joined:
    Jun 26, 2007
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    51
    thanks ALOT for the detailed reply and help. If this is the way things go around here I'm glad to be a part. again homedic thanks for the reply.
     
    #6 sowell, Jun 27, 2007
  7. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,570
    Likes Received:
    45
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #7 cPanelKenneth, Jun 27, 2007
  8. hostmedic

    hostmedic Well-Known Member

    Joined:
    Apr 30, 2003
    Messages:
    544
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Washington Court House, Ohio, United States
    cPanel Access Level:
    DataCenter Provider
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #8 hostmedic, Jun 29, 2007
  9. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,570
    Likes Received:
    45
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    Yes we did record the presentations. They are currently undergoing post-production processing.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #9 cPanelKenneth, Jul 2, 2007
  10. SoftDux

    SoftDux Well-Known Member

    Joined:
    May 27, 2006
    Messages:
    999
    Likes Received:
    3
    Trophy Points:
    168
    Location:
    Johannesburg, South Africa
    cPanel Access Level:
    Root Administrator
    If a new domain is added to the main server, or a new DB is created by a cuser, will it automatically be created / replicated on the other server?
     
    #10 SoftDux, Jul 2, 2007
  11. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,570
    Likes Received:
    45
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    Once the Remote DB setup is performed, new databases, database users, etc, will be done on the remote server, not the local one (barring bugs).
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #11 cPanelKenneth, Jul 3, 2007
  12. expedio

    expedio Active Member

    Joined:
    Jun 30, 2007
    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    56
    Do you need only mysql cluster, or are interested in fully redundant cpanel servers?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #12 expedio, Jul 3, 2007
  13. katmai

    katmai Well-Known Member

    Joined:
    Mar 13, 2006
    Messages:
    537
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    Brno, Czech Republic
    small question. if the mysql is under heavy usage. how will i make 2 servers clustered to handle the mysql load? i mean .. the same database.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #13 katmai, Sep 18, 2007
  14. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,570
    Likes Received:
    45
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    It kind of depends upon the level of complexity you want. Generally speaking it would involve a threee server setup:

    Two MySQL servers
    One proxy server

    Along with customizing the application because such a setup would likely use Replication which mandates that data modification only happen on one server, the Master. Hence the application would need customized to send INSERT, UPDATE and DELETE type statements to the Master, while SELECT type statements would go to the proxy server for load balancing. Hopefully your application does far more SELECTing than UPDATEing.

    You might checkout http://forge.mysql.com/wiki/MySQL_Proxy for info about a proxy, or http://haproxy.1wt.eu/ for a more generalized solution. Also, it is possible to do soemthing like combinae the Master MySQL and Proxy onto one server.

    It's really difficult to give a pat answer to these types of questions because:

    1) There are numerous ways to reach the stated goal

    2) The particular requirements should be fully defined - which can be difficult to convey on a Forum


    Anyway, if the videos from the Seminar are posted, look for my presentation on MySQL replication and clustering.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #14 cPanelKenneth, Sep 18, 2007
  15. katmai

    katmai Well-Known Member

    Joined:
    Mar 13, 2006
    Messages:
    537
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    Brno, Czech Republic
    i was checking it now. thanks for the tips, i will be reading into this and see what i can come up with :)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #15 katmai, Sep 19, 2007
  16. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,570
    Likes Received:
    45
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    You're welcome. We are always here for Q & A. There might be some weak areas with the presentation, since it was originally to be 30 min, but was redone for a 60 min time slot a couple days before the seminar :D (love scheduling, so much fun ;))

    One thing I mentioned in a prior thread is we will be removing the current way of mapping MySQL database names to the cPanel account name. When and how this will happen is unknown, but once it happens it will simplify this entire topic.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #16 cPanelKenneth, Sep 19, 2007
  17. katmai

    katmai Well-Known Member

    Joined:
    Mar 13, 2006
    Messages:
    537
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    Brno, Czech Republic
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #17 katmai, Sep 19, 2007
  18. big

    big Well-Known Member

    Joined:
    Aug 12, 2001
    Messages:
    224
    Likes Received:
    0
    Trophy Points:
    316
    Location:
    Earth
    how can mysql -h localhost work ?

    because all users have 'localhost' in their config.php files for their applications and now they are all down

    mysql -h 192.168.2.10 is working just fine but not mysql -h localhost or mysql -h 127.0.0.1
     
    #18 big, Nov 10, 2007
  19. big

    big Well-Known Member

    Joined:
    Aug 12, 2001
    Messages:
    224
    Likes Received:
    0
    Trophy Points:
    316
    Location:
    Earth
    also all users in the mysql "user" table are granted access with 'localhost' not the other server IP

    how to automatically fix it?
     
    #19 big, Nov 10, 2007
  20. debiannerd

    debiannerd Registered

    Joined:
    Mar 22, 2008
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    51
    #20 debiannerd, Mar 22, 2008
(You must log in or sign up to post here.)
Page 1 of 2
Loading...
Similar Threads - CPanel mysql clustering
  1. MHD_MUS

    cPanel mysql backup Error 1045

    MHD_MUS, Dec 7, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    132
    cPanelLauren
    Dec 10, 2018
  2. kernow

    SOLVED [CPANEL-22320] Table mysql/innodb_index_stats has length mismatch

    kernow, Nov 11, 2018, in forum: Database Discussion
    Replies:
    5
    Views:
    446
    kernow
    Nov 13, 2018
  3. dswimr615

    SOLVED Associate MySQL Database with cPanel User

    dswimr615, Nov 10, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    525
    cPanelMichael
    Nov 12, 2018
  4. Jeff P.

    [CPANEL-23547] MySQL down after failed MariaDB upgrade

    Jeff P., Nov 7, 2018, in forum: Database Discussion
    Replies:
    12
    Views:
    206
    cPanelMichael
    Nov 8, 2018
  5. zTurko

    Does cPanel Support MySQL 8?

    zTurko, Oct 25, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    244
    cPanelMichael
    Oct 25, 2018

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.
    Accept Learn More...
    Dismiss Notice