MySQL, account load, load averages and resource usage

charliekapper

Member
Aug 18, 2013
18
0
1
cPanel Access Level
Root Administrator
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

Active Member
Nov 10, 2010
39
0
56
Brazil
cPanel Access Level
Root Administrator
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

Technical Support Community Manager
Staff member
Apr 11, 2011
47,911
2,233
363
cPanel Access Level
DataCenter Provider
Twitter