Remote MySQL?

[jhyland87]

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]

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]

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]

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]

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.