jhyland87

Well-Known Member
Dec 8, 2008
153
0
66
I saw that WHM has a remote mysql server option. I am thinking about using it, only question I have is... if I use it, and everyone has the mysql server set to localhost, will that kill the mysql websites?

If so, what can I do to fix this? Other than have all my customers go into the script manually to change the mysql server...

Also, what will change? Will restores still work well? Will it create mysql users/dbs when a user requests it?.. etc

And.... will it ever be possible to use more than 1 mysql server?

Thanks!
 

eth00

Well-Known Member
PartnerNOC
Mar 30, 2003
721
1
168
NC
cPanel Access Level
Root Administrator
The configs won't have to be changed, yes backups should work. Everything can keep using localhost

Well you could use more then 1 MySQL server via something like mysql-proxy but it is not something that is supported at all.
 

szaboszilard

Registered
Jun 29, 2009
2
0
51
db

Hi!

A have set up a cpanel with remote mysql server.
My demo config:
cpanel:
centos VPS with cpanel WHM (demo)
mysql:
debian VPS

the configuration is OK, it works.

We have got 200 customers, and we will to change to cpanel.
The MYSQL server is on a solaris zone. It is possible to make the remote connecting with it. I will import the 200 users MYSQL databases to cpanel, with privileges (user settings). The mail/web dir a will import manuali to cpanel server(copy-paste-setuser:group).

It is possible? Works it?

Thanx xilu
 

hostmedic

Well-Known Member
Apr 30, 2003
543
0
166
Washington Court House, Ohio, United States
cPanel Access Level
DataCenter Provider
how is this done ?

The configs won't have to be changed, yes backups should work. Everything can keep using localhost

Well you could use more then 1 MySQL server via something like mysql-proxy but it is not something that is supported at all.
I tried using the mysql change to remote mysql server - but it seems it just did not work well.

The databases did not get copied over - is this something we manually have to dump?
 

cPanelKenneth

cPanel Development
Staff member
Apr 7, 2006
4,607
79
458
cPanel Access Level
Root Administrator
I tried using the mysql change to remote mysql server - but it seems it just did not work well.

The databases did not get copied over - is this something we manually have to dump?
Correct. It is up to the server admin to migrate the databases to the remote server. If that is not already noted in the Remote MySQL setup interface it should definitely be added.