Adding MySQL Servers to Offload MySQL Processes

craigedmonds

Well-Known Member
Oct 29, 2007
114
0
66
Europe
cPanel Access Level
Root Administrator
Twitter
I have two cpanel servers.

Server1 has web sites on it and mysql.
Server2 has no web sites on it.

Server1 is starting to get a bit "podgy" with some of the mysql requests and my idea of Server2 was to move the mysql databases to so that Server1 does not have to handle mysql processes.

Is this the best way or can I somehow "link" Server2 to Server1 so that Server2 takes some of the Mysql work away from Server1?
 

craigedmonds

Well-Known Member
Oct 29, 2007
114
0
66
Europe
cPanel Access Level
Root Administrator
Twitter
Hi there,
You should be able to do what you're after with MySQL clustering For some reason, cPanel calls this 'MySQL profiles' but essentially it's the same thing.
Ah ok, maybe this is what I am looking for. As @tank suggested I could just simply move the database from server1 and use server2 purely as mysql server but if I can leave the mysql where it is but add some extra "oooomph" to the server by adding a second server to take up some of the mysql process then this will be ideal.

I am off to investigate now!!
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,229
463
Hello,

You can find additional information on the following document if you decide to make the second server a MySQL database server:

Manage MySQL Profiles

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,229
463
Hello,

The following URL continues to load well from multiple locations:

Manage MySQL Profiles

Could you let us know if it's still failing to load from your location?

Thank you.
 

craigedmonds

Well-Known Member
Oct 29, 2007
114
0
66
Europe
cPanel Access Level
Root Administrator
Twitter
Hello,

The following URL continues to load well from multiple locations:

Manage MySQL Profiles

Could you let us know if it's still failing to load from your location?

Thank you.
Yes its still showing 404 error. I have tried from my own IP and fixed VPN IP.

- Removed Please Attach Images to Your Posts -
 
Last edited by a moderator: