MySQL, account load, load averages and resource usage

[charliekapper]

Hi there,

Note - using cloud linux

MySQL question
Is it possible to have seperate mySQL servers from cPanel but have it so cPanel uses them for client accounts?
E.g. mySQL dedicated server > cPanel web server

Account load question
I'm using WHMCS to provision cPanel accounts as they are paid for. Is it possible so that WHMCS puts the account on another server if one is full with accounts? kind of like checks the resources available.

Load averages question
I have a E3-1240v2 dedicated server, what would be safe load averages to have, to stop putting more accounts on and what are load averages?

Resource usage question
If an account is using lots of resources and is making the server slow how can I find the account responsible?

Also if I need to move one account from one server to another because it needs more resources than available how can I do this? E.g. account needs 512mb ram and there is none available, how do I move all it's stuff to server2?

Thanks

 

[Rhuan]

Hi
I will try to answer your questions...

1- Yes, you can do this search on this forum for Remote MySQL Server
2- Yes, you need to add another server in Setup > Products/Services > Servers
3- How much accounts you has in this server ? Intel Xeon E3 - 1240v2 has a nice performance, maybe your server needs only some optimizations
4- Yes, it possible you can run command 'top' to see whats account has so much proccess and suspend, look if load decreased, or you can go to WHM > Daily Process Log and check the accounts

 

[cPanelMichael]

Also if I need to move one account from one server to another because it needs more resources than available how can I do this? E.g. account needs 512mb ram and there is none available, how do I move all it's stuff to server2?

The transfer feature in Web Host Manager is useful for this. It's documented at:

WHM - Transfers

You may also find the following thread useful:

Troubleshooting High Load On Linux Servers

Thank you.