[DISCUSS]JDBC engine cache question

[Andy <an...@163.com>]

————— 2022-5-19 —————

Those years, those things... 10:35
Guys, please tell me, there is a cache when the JDBC engine sends a request to publicservice to get the configuration, so the console configuration cannot take effect immediately after modifying it. Is there any good solution?

peacewong@WDS 10:38
You can consider removing the cache and changing it to configurable. The default configuration is to use the cache. You can come to an issue and pr

Heisenberg 10:42
Are you interested in mentioning PR, if you don't have time, I can improve it today

Heisenberg 10:43
If multiple data sources are supported later, the data source configuration information will also be obtained from the DataSource service.

Those years, those things... 10:52
We haven't upgraded to 1.1.0 yet, we are using 1.0.3, I feel like we can only raise an issue

peacewong@WDS 10:53
Haha You can submit pr in 1.1.3. code is similar

Sargent Ti 10:58
This RC branch can be deleted, just keep the tag

peacewong@WDS 11:01
Yes, @Adamyuanyuan  Brother Gang, take a look and deal with it

Those years, those things... 11:17
After the cache is removed, it means that there is no cache, so there is a disadvantage that the user has to request a configuration to obtain the configuration every time it executes.

peacewong@WDS 11:23
Now the configuration is read from the ec side, not from the entry side.

Those years, those things... 11:34
I know that now the JDBC configuration information is cached in the JDBC engine, then I can configure the guavacache expiration time in the JDBC configuration file to control the cache aging time

peacewong@WDS 11:39
no problem


—————  2022-5-19  —————

那些年，那些事..... 10:35
大佬们，请教一下，JDBC引擎向publicservice发送请求获取配置时有缓存，导致修改控制台配置后不能立即生效，请问有什么好的解决方案没有

peacewong@WDS 10:38
可以考虑把cache移除下，改成可以配置的，默认配置走缓存。可以来个issue和pr下

海森堡 10:42
大佬有兴趣提PR嘛，要没时间的话，我今天可以完善下

海森堡 10:43
后面多数据源支持的话，还会走从DataSource服务那里拿数据源配置信息

那些年，那些事..... 10:52
我们现在还没有升级到1.1.0，用的是1.0.3，感觉只能提个issue

peacewong@WDS 10:53
哈哈 可以到1.1.3里面提交下pr的。代码差不多的

Sargent Ti 10:58
这种RC 分支可以删掉了吧，保留tag就好了

peacewong@WDS 11:01
是的，@Adamyuanyuan 刚哥看处理下

那些年，那些事..... 11:17
cache移出后相当于没有缓存了，这样有个不好的地方就是用户每执行一次就要去请求一次获取配置，我们目前考虑的方案cacheableRPCInterceptor的guavaCache配置缓存时效

peacewong@WDS 11:23
现在配置是在ec那边读取的，不是在entrance那边来着了。

那些年，那些事..... 11:34
我知道，现在JDBC配置信息缓存在JDBC引擎中，那我对在JDBC的配置文件中可以配置guavacache过期时间来控制缓存时效

peacewong@WDS 11:39
这个没问题

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@linkis.apache.org
For additional commands, e-mail: dev-help@linkis.apache.org