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.

Confusion - Additional MySQL Access Hosts

Discussion in 'General Discussion' started by jimpoo, Jul 17, 2009.

  1. jimpoo

    jimpoo Registered

    Joined:
    Jul 17, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Hi There,
    In my case, I have three servers:

    W1 - cPanel/WHM is installed,
    D1 - a dedicated mysql server
    D2 - a dedicated mysql server

    Let's say I will host 400 websites on W1, I wanted website#1 to #200 to use D1, and website#201 to #400 to use D2 as their mysql server.

    Something confuse me:
    1. It seems like there are 3 places where I can configure the remote mysql servers. They are:

    In WHM: Main >> SQL Services >> Additional MySQL Access Hosts
    In WHM: Main >> SQL Services >> Setup Remote MySQL server
    In cPanel: Databases >> Remote MySQL

    Then, what are the differences among these functions?

    2. For my case, how do I configure cPanel and/or WHM?

    Thank you for advance.
     
  2. thewebhosting

    thewebhosting Well-Known Member

    Joined:
    May 9, 2008
    Messages:
    1,201
    Likes Received:
    1
    Trophy Points:
    38
    Let me try to explain!

    Additional MySQL Access hosts: Sometime you may be in a need to use the same MySQL database for two different websites hosted on different servers. In that time you need to use the IP address of other web server (for which you wish to use the same database) in this option to allow connection.

    Note: Users must login to their cPanel and enter the mysql manager before these additional hosts will become active.

    Remote MySQL: It allows you to use a MySQL server on a different machine to hold your databases.

    I think you will have to choose second option to set up additional MySQL server.

    Thanks!
     
  3. 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
    This is what WHM: Main >> SQL Services >> Setup Remote MySQL server does. This will mean you're hosting ALL databases on a single remote server.

    Multiple remote MySQL servers (in the sense of Account A uses Database Server 2, Account B uses Database Server 1 etc.) are not natively supported at this time.


    cPanel: Databases >> Remote MySQL is for your individual hosting customers who want to access their databases remotely (e.g. read the databases from their PC or another server).
     
  4. Spiral

    Spiral BANNED

    Joined:
    Jun 24, 2005
    Messages:
    2,023
    Likes Received:
    7
    Trophy Points:
    0
    Before getting into the configuring of these, let me ask you a couple of questions ...

    Why do you have separate database servers instead of using the database server built into your Cpanel / WHM server?

    Why are two machines dedicated to MySQL only?

    Are the machines in the same physical location (same data center)?

    More specifically, what is your reasoning for setting up things this way and is there some particular special purpose behind it?

    Under normal circumstances, putting web hosting accounts and database servers on separate machines would cause substantial performance loss on the machine hosting the web hosting accounts which is even more severe if you have to make a connection through the open internet to another physical location to reach the database server. If you are trying to separate the MySQL databases from the hosting accounts for performance reasons then you are actually doing the exact opposite of what you intended and would be much better off splitting the hosting accounts between the machines each with their own local MySQL database server or getting rid of the extra machines and putting the money into upgrades and more memory for your main hosting machine, either of which will give you better performance than the configuration you are asking about now.

    If there is some unusual purpose outside of performance concerns, tell us here and I might be able to tell you the best way to implement exactly what it is that you are really trying to do.
     
  5. jimpoo

    jimpoo Registered

    Joined:
    Jul 17, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    The purpose to separate the mysql server from the cpanel (web) server is that we wanted to be able to do mysql cluster and web server load balancing in the future. cPanel is only for website account creation .

    We are hosting ecommerce shopping cart for customers, each website requires a mysql database. Our servers are networked in a virtual rack.

    Then, what would be a good server solution for the ability to host a few thousands of ecommerce websites that each comes with a standalone mysql db?
    Let's say 10% of these websites will take about 80% of the total server traffics.

    Thank you,
     
    #5 jimpoo, Jul 21, 2009
    Last edited: Jul 21, 2009
Loading...

Share This Page