Adding MySQL Servers to Offload MySQL Processes

[craigedmonds]

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?

 

[tank]

Why not just make server 2 MYSQL ?

Your kind of getting into load balancing with what you described, I really not the familiar with that.

 

[twhiting9275]

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.

 

[craigedmonds]

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]

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.

 

[craigedmonds]

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.

Sorry, it gives a 404 error.

 

[cPanelMichael]

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]

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 -

 

[cPanelMichael]

It looks like a cached version of the page is still active. You can try using the following alternate URL if the initial URL fails to load:

Manage MySQL® Profiles - Documentation - cPanel Documentation

Thank you.