[MXS-1401] Allow multiple store/use pairs in cache filter rules Created: 2017-09-11  Updated: 2018-04-27  Resolved: 2018-04-27

Status: Closed
Project: MariaDB MaxScale
Component/s: cache
Affects Version/s: 2.1.6
Fix Version/s: 2.3.0

Type: New Feature Priority: Major
Reporter: markus makela Assignee: Johan Wikman
Resolution: Fixed Votes: 1
Labels: None

Sprint: MXS-SPRINT-56

 Description   

The cache filter currently supports only one object with store/use values. An array of store/use values would allow more precise caching rules.

Here is the example JSON that would allow the definition of multiple rules in a single file.

[
    {
        "store": [
            {
                "attribute": "table",
                "op": "=",
                "value": "test.t1"
            }
        ],
        "use": [
            {
                "attribute": "user",
                "op": "=",
                "value": "'bob'@'%'"
            }
        ]
    },{
        "store": [
            {
                "attribute": "table",
                "op": "=",
                "value": "test.t2"
            }
        ],
        "use": [
            {
                "attribute": "user",
                "op": "=",
                "value": "'alice'@'%'"
            }
        ]
    }
]


Generated at Thu Feb 08 04:06:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.