Limit Resources per domain

[dprophit]

Thank you for the call. To my understanding you are interested in establishing mysql and apache resource limits on a per user/vhost basis.

On the mysql side, this can be accomplished with the GRANT statement within mysql itself. see http://dev.mysql.com/doc/refman/5.0/en/grant.html

There are 3 resource limiting variables available for mysql 4.1:
| MAX_QUERIES_PER_HOUR count
| MAX_UPDATES_PER_HOUR count
| MAX_CONNECTIONS_PER_HOUR count

5.0 adds MAX_CONNECTIONS_PER_HOUR.

You can set these for all users with a clever INSERT statement, or via phpmyadmin.

Apache provides RLimitCPU, RLimitNPROC and RLimitMEM. These directives can be set on a global and per vhost basis. For more information: http://httpd.apache.org/docs/1.3/mod/core.html#rlimitcpu

Rackspace gave me the following advice. Now how to implement it? I saw even triggers but not sure how to use it. The documentation doesn't talk about the "user" to use. We have normal hosting accounts and high traffic accounts. We want to offer more resources to the higher paying customers.

I think Swsoft should build in resource limits per client and then build it into the API. Should not be hard to insert those values into the /conf/httpd.include once they are figured out. But we don't want to fill them in for every single client. Clients can create their own domains and have their own templates so we need to control it at the server level.

Who else wants this?