Mysql server to another server.

[sreeninair]

Hello Guys,

I have a server which is having high load. So I am planning to purchase another serer and use it as my mysql server. Please let me know the procedure.

Thanks
Sreeni

 

[dalem]

cpanel docs
Setup Remote MySQL Server

 

[cPanelMichael]

Hello

Yes, as mentioned in the previous post, you can find full documentation on using a remote MySQL server at:

Setup Remote MySQL Server

Thank you.

 

[sreeninair]

Hello Guys,

I have configured it successfully. But no database were copied over to remote server. Do I have to manually copy databases to remote server?? . If so let me know the exact steps.

Thanks
Sreeni

 

[sreeninair]

Hello Guys,

I have now rsynced mysql data directory and restarted mysql. The main server is using remote mysql and it is showing in remote mysql server section in whm. Still Mysql is consuming load from main server. The remote server mysql process is very low. Please help me on this.

mysql process on main server
4204 mysql 15 0 208m 34m 4256 S 302.4 0.2 1:51.72 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=my

mysql process on old server:
10348 mysql 20 0 497m 26m 5788 S 0.0 0.1 0:00.24 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --

Thanks
Sreeni

 

[cPanelMichael]

Could you provide more details about the CPU usage? For instance, what is your server load?

Thank you.

 

[sreeninair]

Hello Michael,

The load details are pasted below. The mysql is taking the load. How can I confirm mysql is running remotely. Here if I stop mysql in main server the sites will go down.

top - 03:47:59 up 203 days, 15:07, 2 users, load average: 2.87, 2.99, 3.10

Thanks
Sreeni

 

[sreeninair]

Hello,

The main issue is when I stop mysql in main server the sites will show database connection error.

Thanks
SReeni

 

[dalem]

you have to change your connection strings for all of your scripts to use the remote mysql server

 

[sreeninair]

Hello Dalem,

How is this possible?. I have thousands of accounts in the serer. Is their any way other than this ?

Thanks
Sreeni

- - - Updated - - -

Hello Dalem,

How is this possible?. I have thousands of accounts in the serer. Is their any way other than this ?

Thanks
Sreeni

 

[cPanelMichael]

You can actually leave your script configuration values in-place. When you setup the remote MySQL server option in WHM, it ensures that MySQL connection attempts to localhost are automatically routed to the remote MySQL server. You should not uninstall MySQL completely from the local machine.

Thank you.

 

[sreeninair]

Hello Michael,

But when I stop mysql in main server sites will go down.

Thanks
Sreeni

 

[cPanelMichael]

It's normal to see an active MySQL process when using a remote MySQL server. It should show the hostname of the remote MySQL server. However, feel free to open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome.

Thank you.