You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/05/10 12:36:03 UTC

[GitHub] [shardingsphere] fengying-wzm removed a comment on issue #10290: application run failed for 5.0.0-alpha

fengying-wzm removed a comment on issue #10290:
URL: https://github.com/apache/shardingsphere/issues/10290#issuecomment-836642149


   我的放在Apollo,是properties格式,你转一下。
   
   ```properties
   
   # 是否启动读写分离
   spring.shardingsphere.enabled = true
   
   # 主库配置
   spring.shardingsphere.datasource.common.driver-class-name = com.mysql.cj.jdbc.Driver
   spring.shardingsphere.datasource.common.type = com.zaxxer.hikari.HikariDataSource
   
   spring.shardingsphere.datasource.names = master,slave0,slave1
   spring.shardingsphere.datasource.master.jdbcUrl = jdbc:mysql://xxx:3306/xxx?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8
   spring.shardingsphere.datasource.master.username = xxx
   spring.shardingsphere.datasource.master.password = xxx
   spring.shardingsphere.datasource.master.minimum-idle = 20
   spring.shardingsphere.datasource.master.maximum-pool-size = 50
   spring.shardingsphere.datasource.master.auto-commit = true
   spring.shardingsphere.datasource.master.idle-timeout = 30000
   spring.shardingsphere.datasource.master.max-lifetime = 1800000
   spring.shardingsphere.datasource.master.connection-timeout = 30000
   spring.shardingsphere.datasource.master.connection-test-query = SELECT 1
   
   # 从库slave0
   spring.shardingsphere.datasource.slave0.jdbcUrl = jdbc:mysql://xxx:3306/xxx?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8
   spring.shardingsphere.datasource.slave0.username = xxx
   spring.shardingsphere.datasource.slave0.password = xxx
   spring.shardingsphere.datasource.slave0.minimum-idle = 20
   spring.shardingsphere.datasource.slave0.maximum-pool-size = 50
   spring.shardingsphere.datasource.slave0.auto-commit = true
   spring.shardingsphere.datasource.slave0.idle-timeout = 30000
   spring.shardingsphere.datasource.slave0.max-lifetime = 1800000
   spring.shardingsphere.datasource.slave0.connection-timeout = 30000
   spring.shardingsphere.datasource.slave0.connection-test-query = SELECT 1
   
   # 从库slave1
   spring.shardingsphere.datasource.slave1.jdbcUrl = jdbc:mysql://xxx:3306/xxx?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8
   spring.shardingsphere.datasource.slave1.username = xxx
   spring.shardingsphere.datasource.slave1.password = xxx
   spring.shardingsphere.datasource.slave1.minimum-idle = 20
   spring.shardingsphere.datasource.slave1.maximum-pool-size = 50
   spring.shardingsphere.datasource.slave1.auto-commit = true
   spring.shardingsphere.datasource.slave1.idle-timeout = 30000
   spring.shardingsphere.datasource.slave1.max-lifetime = 1800000
   spring.shardingsphere.datasource.slave1.connection-timeout = 30000
   spring.shardingsphere.datasource.slave1.connection-test-query = SELECT 1
   
   # 负载均衡算法,默认轮询
   spring.shardingsphere.masterslave.load-balance-algorithm-type = round_robin
   spring.shardingsphere.masterslave.name = master-slave
   spring.shardingsphere.masterslave.master-data-source-name = master
   spring.shardingsphere.masterslave.slave-data-source-names = slave0,slave1
   
   # 打印mysql语句
   spring.shardingsphere.props.sql.show = true
   ```


-- 
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org