FOR shardingsphere5.3 dynamic config suggestion

[hyz1994121]

In my project i try upgrade shardingsphere from 5.1.1 to 5.3
i use shardingshpere jdbc by spring-namespace
after read this, https://community.sphere-ex.com/t/topic/1284 finished my upgrade
then i found some problem, in sharding.yaml i must use the real jdbcurl for datasource config
before, in my project ,we use ${jdbc.url} by apollo config to distinguish different environment，ex qa, ol

i found to build spring bean org.springframework.jdbc.datasource.SimpleDriverDataSource , i could set username, password by apollo config, but the url must use jdbc:shardingsphere:classpath:sharding.yaml like this,
to use prefix jdbc:shardingsphere:

though i could not use the dynamic config to distinguish the different enviroment.
in different env i must make 2 yaml file, it's very uncomfortable.

[hyz1994121]

is anyone can help me?

[zhaojinchao95]

@hyz1994121 You can look this : #23388

[hyz1994121]

by the way, i found in 5.3.0 , i must use HikariDataSource for sharding.yaml, i wonder know if i can use the alibaba.druid for my DataSource. Becuase the druid provid some monitor for the db connection

[liming0]

I also encountered this issue when using nacos. sharding.yaml cannot reference the values of the configuration files in nacos

[794086163]

置

+1

[liming0]

I also encountered this issue when using nacos. sharding.yaml cannot reference the values of the configuration files in nacos

sharding现在感觉越做越脱离用户了感觉，搞的新东西完全摒弃原有的，并不兼容，低版本的bug也不修复fix，到高版本直接跨越式的升级，搞的我们在低版本和高版本之间还得手动在应用中重写来修复bug，有点蛋疼

Yes, the main issue is that there is still no smooth transition plan, but fortunately, SPI was provided. I implemented the configuration loading of NACOS myself and also replaced the values referenced by Spring's ${}

[strongduanmu]

@liming0 Can you contribute your implement to upstream to help more users?

[strongduanmu]

The Nacos implementation comes from some community contributors, so it is not perfect now, and we hope that more developers will improve it so that it has a chance to become more stable.

[liming0]

@liming0 Can you contribute your implement to upstream to help more users?

Yes, I have removed the part about spring from my code. How can I contribute the code next

[strongduanmu]

Hi @liming0, you can submit a new issue to describe your modify, and then we could discuss in this issue.

[liming0]

Hi @liming0, you can submit a new issue to describe your modify, and then we could discuss in this issue.

Sharding-jdbc supports nacos configuration
@strongduanmu

[linghengqian]

• Now at https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/yaml-config/jdbc-driver/known-implementation/ , there are at least 4 SPI implementation to dynamically define YAML attribute values.
• Refer to
  • Add AbsolutePathURLProvider implementation that reads environment variables #29909
  • Add ClasspathURLProvider implementation that reads environment variables #29907
  • Add ClasspathURLProvider implementation that reads system properties #29995
  • https://github.com/apache/shardingsphere-plugin?tab=readme-ov-file#jdbc-driver-config-plugin