Remote MYSQL question

[cwalke32477]

This is probably quite the "n00b" question; if I activate remote mysql on a production server, will it automatically move the sql databases off the main server, and onto the new remote sql server?
I'm looking for ways to reduce disk i/o one of my older servers, and it seems that MySQL is responsible for most of the i/o wait.

 

[milind]

Hello,

I don't think that enabling Remote MySQL will automatically move your databases from current server to another. You have to manually do that (someone from cPanel please confirm this.)

 

[cwalke32477]

Please cPanle, can you confirm this? I can;t find any documentation on the process.

 

[nobodyk]

I'm not cPanel, but remote mysql means that your MySQL can be access remotely. By default mysql does not allow remote connections. Your MySQL server will not move its data, enabling remote access is just that - enabling remote access. If you're having IO issues your best bet is to configure my.cnf

Have a look at mysqltuner to help you determine the optimal values for your setup. It's mostly that you don't have a good configuration on mysql.

 

[cwalke32477]

I've already run mysqltuner and optimised my.cnf
This is a reseller server, and it's just getting loaded a bit.
Rather than create a new server, and purchase double licenses on everything, I can setup a remote server for handling the MySQL, and drop the loads in half, all transit between the two servers would be through gigabit channels on an internal network.

See WHM >> Main >> SQL Services >> Setup Remote MySQL server
That is the remote MySQL I am referring too, not the ability to connect to the local MySql remotely.

As cPanel states it...

This feature allows you to place MySQL databases on a remote server that is running MySQL. Using a separate server for MySQL can be useful for busy servers or servers with large databases, allowing you to offload MySQL-related work to the remote MySQL server.

Important: This should not be confused with allowing access to a MySQL database from a remote server. To configure that option, use the Additional MySQL Access Hosts function.

So the question still remains...
Will setting this up allow me to automatically migrate the existing clients MySQL DB's, within the WHM interface, to the remote server, or would this have to be done manually?

 

[minosjl]

Hi bro,

I don't this there is an option to automatically move the MYSQL databases in to your remote server having MYSQL service.I think you need to configure this manually on your server.I think you can achieve this by MYSQL replication option .There are lots of docs are available in order to do that. You can configure your cpanel server as master and your remote server as slave .

Yo can also configure your master server as writing the MYSQL data's and execute the MYSQL queries in the slave server a type of load balancing.