You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@shardingsphere.apache.org by Haoran Meng <me...@gmail.com> on 2021/02/09 10:53:57 UTC
[DISCUSS] Keep local YAML configuration of data source consist with
registry center
Hi, community
In order to keep the local and registry center configuration uniform, we
plan to keep the local YAML configuration of data source consistent with
that in the registry center.
The local YAML configuration of data source is as follows:
dataSources:
ds_0: !!com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.jdbc.Driver
jdbcUrl: jdbc:mysql://localhost:3306/demo_ds_0
username: root
password:
ds_1: !!com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.jdbc.Driver
jdbcUrl: jdbc:mysql://localhost:3306/demo_ds_1
username: root
password:
and the configuration in the registry center is:
dataSources:
ds_0:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
props:
jdbcUrl: jdbc:mysql://
127.0.0.1:3306/demo_ds_0?serverTimezone=UTC&useSSL=false
username: root
password: null
connectionTimeout: 30000
idleTimeout: 60000
maxLifetime: 1800000
maxPoolSize: 50
minPoolSize: 1
maintenanceIntervalMilliseconds: 30000
readOnly: false
ds_1:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
props:
jdbcUrl: jdbc:mysql://
127.0.0.1:3306/demo_ds_1?serverTimezone=UTC&useSSL=false
username: root
password: null
connectionTimeout: 30000
idleTimeout: 60000
maxLifetime: 1800000
maxPoolSize: 50
minPoolSize: 1
maintenanceIntervalMilliseconds: 30000
readOnly: false
Related issue : https://github.com/apache/shardingsphere/issues/9406
**welcome your discussion!**
--
Haoran Meng
menghaoranss@gmail.com
Re:[DISCUSS] Keep local YAML configuration of data source consist
with registry center
Posted by KimmKing <ki...@apache.org>.
+1, keep a absolute same format to make the fewest cost to understand configurations.
And now two different styles are confused.
At 2021-02-09 18:53:57, "Haoran Meng" <me...@gmail.com> wrote:
>Hi, community
>
>In order to keep the local and registry center configuration uniform, we
>plan to keep the local YAML configuration of data source consistent with
>that in the registry center.
>
>The local YAML configuration of data source is as follows:
>
>dataSources:
> ds_0: !!com.zaxxer.hikari.HikariDataSource
> driverClassName: com.mysql.jdbc.Driver
> jdbcUrl: jdbc:mysql://localhost:3306/demo_ds_0
> username: root
> password:
> ds_1: !!com.zaxxer.hikari.HikariDataSource
> driverClassName: com.mysql.jdbc.Driver
> jdbcUrl: jdbc:mysql://localhost:3306/demo_ds_1
> username: root
> password:
>
>and the configuration in the registry center is:
>
>dataSources:
> ds_0:
> dataSourceClassName: com.zaxxer.hikari.HikariDataSource
> props:
> jdbcUrl: jdbc:mysql://
>127.0.0.1:3306/demo_ds_0?serverTimezone=UTC&useSSL=false
> username: root
> password: null
> connectionTimeout: 30000
> idleTimeout: 60000
> maxLifetime: 1800000
> maxPoolSize: 50
> minPoolSize: 1
> maintenanceIntervalMilliseconds: 30000
> readOnly: false
> ds_1:
> dataSourceClassName: com.zaxxer.hikari.HikariDataSource
> props:
> jdbcUrl: jdbc:mysql://
>127.0.0.1:3306/demo_ds_1?serverTimezone=UTC&useSSL=false
> username: root
> password: null
> connectionTimeout: 30000
> idleTimeout: 60000
> maxLifetime: 1800000
> maxPoolSize: 50
> minPoolSize: 1
> maintenanceIntervalMilliseconds: 30000
> readOnly: false
>
>
>Related issue : https://github.com/apache/shardingsphere/issues/9406
>
>**welcome your discussion!**
>
>
>--
>Haoran Meng
>menghaoranss@gmail.com