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.

Remote Database Server what is the acceptable Distance and latency

Discussion in 'Database Discussions' started by rasa, Jul 19, 2013.

  1. rasa

    rasa Active Member

    Joined:
    Feb 17, 2013
    Messages:
    44
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    hello
    i want to setup remote database server for a singlw WHM intaaltin that host heavy traffic websites

    ihave 2 question

    1- am i need a seperate license and installation on Cpanel/WHM for Remote Database Server
    if not is this ok to just install mysql server with something like webmin and then conncet it to the WHM server ?


    2- what is the best and max acceptable Network latency and hop for a remote database server ?
    <1ms ?
    ~10ms ?
    ~50ms ?
    ~100ms ?
    -------
    2 Hop
    5 hop
    or no matter ?

    thanks
     
  2. STS Admin

    STS Admin Well-Known Member

    Joined:
    Jul 8, 2012
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    India
    cPanel Access Level:
    Root Administrator
    1. No there is no need of separate cPanel license just for MySQL. Just install MySQL on new server , allow remote access to root user with your cPanel server IP and add it to your WHM server.

    2. For good speed and connectivity it should be <1ms and single hop. But it doesn't matter if the connectivity is good between the two servers.
     
  3. STS Admin

    STS Admin Well-Known Member

    Joined:
    Jul 8, 2012
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    India
    cPanel Access Level:
    Root Administrator
    It will be better if the servers are connected together on a private network in the same data center.
     
  4. rasa

    rasa Active Member

    Joined:
    Feb 17, 2013
    Messages:
    44
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Hello and thanks for your response
    actualy i was thinking about put servers in diffrent datacenters
    and may be the latency is about 20 to 90ms

    do you think this work ?

    in some datacenter i could have hoursePower for Database server for lower price
     
  5. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,146
    Likes Received:
    34
    Trophy Points:
    48
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hello,

    Yes, Remote MySQL will work with the 20 to 90ms latency. You should not get any issues but I will also suggest you setup the remote MySQL server in same datacenter with the private network so that you can connect your MySQL server using the private network
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page