rickchengx commented on code in PR #11113: URL: https://github.com/apache/dolphinscheduler/pull/11113#discussion_r931963062
########## docs/docs/en/architecture/configuration.md: ########## @@ -139,321 +123,203 @@ export DOLPHINSCHEDULER_OPTS=" > "-XX:DisableExplicitGC" is not recommended due to may lead to memory link > (DS dependent on Netty to communicate). -### datasource.properties [datasource config properties] +### 2. Database connection related configuration + +DS uses Spring Hikari to manage database connections, configuration file location: + +|Service| Configuration file | +|--|--| +Master Server | `master-server/conf/application.yaml` +Api Server| `api-server/conf/application.yaml` +Worker Server| `worker-server/conf/application.yaml` +Alert Server| `alert-server/conf/application.yaml` + +The default configuration is as follows: -DS uses Druid to manage database connections and default simplified configs are: |Parameters | Default value| Description| |--|--|--| -spring.datasource.driver-class-name||datasource driver -spring.datasource.url||datasource connection url -spring.datasource.username||datasource username -spring.datasource.password||datasource password -spring.datasource.initialSize|5| initial connection pool size number -spring.datasource.minIdle|5| minimum connection pool size number -spring.datasource.maxActive|5| maximum connection pool size number -spring.datasource.maxWait|60000| max wait milliseconds -spring.datasource.timeBetweenEvictionRunsMillis|60000| idle connection check interval -spring.datasource.timeBetweenConnectErrorMillis|60000| retry interval -spring.datasource.minEvictableIdleTimeMillis|300000| connections over minEvictableIdleTimeMillis will be collect when idle check -spring.datasource.validationQuery|SELECT 1| validate connection by running the SQL -spring.datasource.validationQueryTimeout|3| validate connection timeout[seconds] -spring.datasource.testWhileIdle|true| set whether the pool validates the allocated connection when a new connection request comes -spring.datasource.testOnBorrow|true| validity check when the program requests a new connection -spring.datasource.testOnReturn|false| validity check when the program recalls a connection -spring.datasource.defaultAutoCommit|true| whether auto commit -spring.datasource.keepAlive|true| runs validationQuery SQL to avoid the connection closed by pool when the connection idles over minEvictableIdleTimeMillis -spring.datasource.poolPreparedStatements|true| open PSCache -spring.datasource.maxPoolPreparedStatementPerConnectionSize|20| specify the size of PSCache on each connection - - -### zookeeper.properties [zookeeper config properties] +spring.datasource.driver-class-name| org.postgresql.Driver |datasource driver +spring.datasource.url| jdbc:postgresql://127.0.0.1:5432/dolphinscheduler |datasource connection url +spring.datasource.username|root|datasource username +spring.datasource.password|root|datasource password +spring.datasource.hikari.connection-test-query|select 1|validate connection by running the SQL +spring.datasource.hikari.minimum-idle| 5| minimum connection pool size number +spring.datasource.hikari.auto-commit|true|whether auto commit +spring.datasource.hikari.pool-name|DolphinScheduler|name of the connection pool +spring.datasource.hikari.maximum-pool-size|50| maximum connection pool size number +spring.datasource.hikari.connection-timeout|30000|connection timeout +spring.datasource.hikari.idle-timeout|600000|Maximum idle connection survival time +spring.datasource.hikari.leak-detection-threshold|0|Connection leak detection threshold +spring.datasource.hikari.initialization-fail-timeout|1|Connection pool initialization failed timeout + + +### 3. Zookeeper related configuration Review Comment: Sure. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
