Remote Database Server what is the acceptable Distance and latency

rasa

Well-Known Member
Feb 17, 2013
45
0
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
 

STS Admin

Well-Known Member
Jul 8, 2012
46
0
56
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.
 

rasa

Well-Known Member
Feb 17, 2013
45
0
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
 

24x7server

Well-Known Member
Apr 17, 2013
1,907
95
78
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Hello :)

You can utilize the remote MySQL feature even if cPanel is not installed on the remote server.

Thank you.