WHM and remote mysql

[upsforum]

In WHM if set a remote mysql server (with Remote mySQL Host Setup option) I can also continue to use the mysql localhost?

 

[upsforum]

another question: but with SSH port the remote mysql comunication is fast??

 

[jayh38]

Yes you can use remote and localhost separately without issues. Just point your connection scripts to the proper location.

As for your second question, I do not understand what you are asking. I will comment that in order to ssh to the remote database, you would need to ssh directly to that server or setup a tunnel.

You can however, manage the remote location via phpmyadmin on the web server or you can set phpmyadmin to manage your local mysql, however you like to set it up.

 

[upsforum]

Hi,

Thank you for your responce, for communication fast I thing if run the queries (SELECT, UPDATE etc..) from remote mysql this is fast?

 

[jayh38]

Fast? Mysql is Mysql. How fast depends on the server, how heavy the querys and the connection. Best performance will be over a private switch between the web server and mysql server. Best performance would be database replication with master / slave servers for a total of 3 servers.

Setting up your web server to send insert querys to the master and read querys to the slave would be the ultimate in speed and versatility provided most of your querys are balanced between read and write. Otherwise, a single remote database server would do well over a switch.