Isn't this doable already with the cache filter in MaxScale?

Hi Markus,

Not sure, how to add a filter for every server? I know we can add filter for a service.

You could create a service with the filter and then connect to that if you want the results to be cached.

Can we have a global cache for query editor? as we are using source as Server?

As a workaround for the current version, creating a service with the desired filter should allow customization of the routing pipeline. As for doing this for the servers, I don't know how complex it would be to implement.

Yeah got it. if we can have query editor cache filter globally when we use query editor or any query goes through query editor that should be cached globally may help us to improvise the query. Few developers thinking that query is very slow if use from query editor.

Is the query faster when executed from the command line? If the query itself is slow and it is important that the result is up-to-date, then caching in the GUI would be a sub-optimal solution as the invalidation of the cache gets complex very fast.

Yes, command line its faster and its not a slow query as per the developers, even i have checked it.

If you can reproduce the slowness of the query in the GUI while it is fast in the command line, please open a separate bug report for that. Hopefully we can improve the performance even if no caching is yet implemented.

Yeah Sure, I will create another bug. Can you consider this ticket to cache for server as well.

Hi Markus,

Can we implement like below?

[split-router-cache]
type = filter
module = cache
hard_ttl = 300s
#soft_ttl = 25s
storage = storage_redis
storage_options = server=192.168.1.11:6379
enabled = true
cached_data = shared
invalidate = current
debug = 1
clear_cache_on_parse_errors = true

*[server1]
type = server
address = 192.168.1.10
port = 3306
protocol = mariadbclient
filters = split-router-cache*

If we can filters option like above then we can cache the data if select source as a Server.

Actually we tried like below, but we are getting the below error.

[Server1_Service]
type = service
router = readconnroute
servers = server1
user = max_user
password = XXXXXXXX
connection_timeout = 3000s
router_options = slave
filters = split-router-cache

[Server1_Service_Listener]
type = listener
service = Server1_Service
protocol = MariaDBClient
port = 3306
address = 0.0.0.0
authenticator = PAMAuth

*Error 1815: Internal error: Session creation failed *

The reason why the session creation failed is explained in the MaxScale log.

Checked the error logs but not sure where its giving the error.
We are able to query from the Server if source is server but other than this we are facing the connection issues[address =]. that's why can we implement cache for like below?

*[server1]
type = server
address = 192.168.1.10
port = 3306
protocol = mariadbclient
filters = split-router-cache*

Hi Markus,

In our case, we can't use the service, that's why we are using server as a source. Can you please add the cache filter for server as well.? like below.

*[server1]
type = server
address = 192.168.1.10
port = 3306
protocol = mariadbclient
filters = split-router-cache*

Adding filters for servers is technically a bit challenging as all filters currently assume they work with a service. Not impossible but it's definitely a lot of work to implement caching for the GUI this way.

Actually, we are unable to open the service ports that's why we are using the server as a source.

Do you mean when you select the listener as the source from the GUI, the query does not work?

No, even we are unable to connect the db, we are getting the below error.

Connection to [::]:9999 failed. Error 2002: Can't connect to server on '::' (113)

Ah, that might actually be a bug that we can fix. Can you open a bug report for that?

Sure, will raise a bug then.
Thanks Markus.

Hi Markus,

Can you please enable the global cache for only the Query editor. It doesn't matter whatever the source its is, either Server or Listener. But can you please implement the Global cache for only to the Query editor?

Or Can you please implement the local cache(System/Browser cache) for the query editor?