Details
-
New Feature
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
-
None
Description
The resource limits that can be set with the GRANT statement are not currently enforced by MaxScale and are only enforced by MariaDB. Enforcing them at the MaxScale level would mean that e.g. MAX_USER_CONNECTIONS cannot be violated by going through MaxScale which then offloads traffic to multiple nodes.
However, one could argue that e.g. the user-based connection limits do not make as much sense when talking about a proxy as it's the database itself where the actual resources end up being used. Thus, making this behavior optional would seem smart.