[GitHub] [shardingsphere] zjcnb opened a new issue #14538: ShardingSphere feature Sharding and HA used together, Two groups of mgr have some problems.

[GitBox <gi...@apache.org>]

zjcnb opened a new issue #14538:
URL: https://github.com/apache/shardingsphere/issues/14538


   ## Bug Report
   
   **For English only**, other languages will not accept.
   
   Before report a bug, make sure you have:
   
   - Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
   - Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
   
   Please pay attention on issues you submitted, because we maybe need more details. 
   If no response anymore and we cannot reproduce it on current information, we will **close it**.
   
   Please answer these questions before submitting your issue. Thanks!
   
   ### Which version of ShardingSphere did you use?
   
   master
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   
   ShardingSphere-JDBC
   
   ### Expected behavior
   
   Correct primary node and disable node.
   
   ### Configuration
   
   ```
   mybatis.mapper-locations=classpath*:mapper/**/*Mapper.xml
   mybatis.type-aliases-package=com.shardingsphere
   
   server.port=8899
   spring.shardingsphere.props.sql-show=true
   spring.shardingsphere.datasource.ds-0.jdbc-url = jdbc:mysql://127.0.0.1:13306/demo_primary_ds?serverTimezone=UTC&useSSL=false
   spring.shardingsphere.datasource.ds-0.username=root
   spring.shardingsphere.datasource.ds-0.password=123456
   spring.shardingsphere.datasource.ds-0.type=com.zaxxer.hikari.HikariDataSource
   spring.shardingsphere.datasource.ds-0.driver-class-name=com.mysql.cj.jdbc.Driver
   
   spring.shardingsphere.datasource.ds-1.jdbc-url = jdbc:mysql://127.0.0.1:13307/demo_primary_ds?serverTimezone=UTC&useSSL=false
   spring.shardingsphere.datasource.ds-1.username=root
   spring.shardingsphere.datasource.ds-1.password=123456
   spring.shardingsphere.datasource.ds-1.type=com.zaxxer.hikari.HikariDataSource
   spring.shardingsphere.datasource.ds-1.driver-class-name=com.mysql.cj.jdbc.Driver
   
   spring.shardingsphere.datasource.ds-2.jdbc-url = jdbc:mysql://127.0.0.1:13308/demo_primary_ds?serverTimezone=UTC&useSSL=false
   spring.shardingsphere.datasource.ds-2.username=root
   spring.shardingsphere.datasource.ds-2.password=123456
   spring.shardingsphere.datasource.ds-2.type=com.zaxxer.hikari.HikariDataSource
   spring.shardingsphere.datasource.ds-2.driver-class-name=com.mysql.cj.jdbc.Driver
   
   spring.shardingsphere.datasource.ds-3.jdbc-url = jdbc:mysql://community:1231/demo_primary_ds?serverTimezone=UTC&useSSL=false
   spring.shardingsphere.datasource.ds-3.username=root
   spring.shardingsphere.datasource.ds-3.password=123456
   spring.shardingsphere.datasource.ds-3.type=com.zaxxer.hikari.HikariDataSource
   spring.shardingsphere.datasource.ds-3.driver-class-name=com.mysql.cj.jdbc.Driver
   
   spring.shardingsphere.datasource.ds-4.jdbc-url = jdbc:mysql://community:1232/demo_primary_ds?serverTimezone=UTC&useSSL=false
   spring.shardingsphere.datasource.ds-4.username=root
   spring.shardingsphere.datasource.ds-4.password=123456
   spring.shardingsphere.datasource.ds-4.type=com.zaxxer.hikari.HikariDataSource
   spring.shardingsphere.datasource.ds-4.driver-class-name=com.mysql.cj.jdbc.Driver
   
   spring.shardingsphere.datasource.ds-5.jdbc-url = jdbc:mysql://community:1233/demo_primary_ds?serverTimezone=UTC&useSSL=false
   spring.shardingsphere.datasource.ds-5.username=root
   spring.shardingsphere.datasource.ds-5.password=123456
   spring.shardingsphere.datasource.ds-5.type=com.zaxxer.hikari.HikariDataSource
   spring.shardingsphere.datasource.ds-5.driver-class-name=com.mysql.cj.jdbc.Driver
   
   spring.shardingsphere.datasource.names=ds-0,ds-1,ds-2,ds-3,ds-4,ds-5
   
   spring.shardingsphere.rules.readwrite-splitting.data-sources.rd_rs0.auto-aware-data-source-name=pr_ds0
   spring.shardingsphere.rules.readwrite-splitting.data-sources.rd_rs1.auto-aware-data-source-name=pr_ds1
   
   spring.shardingsphere.rules.database-discovery.data-sources.pr_ds0.data-source-names=ds-0, ds-1, ds-2
   spring.shardingsphere.rules.database-discovery.data-sources.pr_ds0.discovery-heartbeat-name=mgr-heartbeat
   spring.shardingsphere.rules.database-discovery.data-sources.pr_ds0.discovery-type-name=mgr
   
   spring.shardingsphere.rules.database-discovery.data-sources.pr_ds1.data-source-names=ds-3, ds-4, ds-5
   spring.shardingsphere.rules.database-discovery.data-sources.pr_ds1.discovery-heartbeat-name=mgr-heartbeat
   spring.shardingsphere.rules.database-discovery.data-sources.pr_ds1.discovery-type-name=mgr1
   
   spring.shardingsphere.rules.database-discovery.discovery-heartbeats.mgr-heartbeat.props.keep-alive-cron=0/5 * * * * ?
   spring.shardingsphere.rules.database-discovery.discovery-types.mgr.type=MGR
   spring.shardingsphere.rules.database-discovery.discovery-types.mgr.props.group-name=b13df29e-90b6-11e8-8d1b-525400fc3996
   
   spring.shardingsphere.rules.database-discovery.discovery-types.mgr1.type=MGR
   spring.shardingsphere.rules.database-discovery.discovery-types.mgr1.props.group-name=b13df29e-90b6-11e8-8d1b-525400fc3996
   
   spring.shardingsphere.rules.sharding.sharding-algorithms.database-inline.type=INLINE
   spring.shardingsphere.rules.sharding.sharding-algorithms.database-inline.props.algorithm-expression=rd_rs$->{sharding_key % 2}
   
   spring.shardingsphere.rules.sharding.sharding-algorithms.table-inline.type=INLINE
   spring.shardingsphere.rules.sharding.sharding-algorithms.table-inline.props.algorithm-expression=t_user$->{sharding_key % 2}
   
   spring.shardingsphere.rules.sharding.tables.t_user.actual-data-nodes=rd_rs$->{0..1}.t_user$->{0..1}
   
   spring.shardingsphere.rules.sharding.tables.t_user.database-strategy.standard.sharding-column=sharding_key
   spring.shardingsphere.rules.sharding.tables.t_user.database-strategy.standard.sharding-algorithm-name=database-inline
   
   spring.shardingsphere.rules.sharding.tables.t_user.table-strategy.standard.sharding-column=sharding_key
   spring.shardingsphere.rules.sharding.tables.t_user.table-strategy.standard.sharding-algorithm-name=table-inline
   
   spring.shardingsphere.mode.type=Cluster
   spring.shardingsphere.mode.repository.type=Zookeeper
   spring.shardingsphere.mode.repository.props.namespace=governance_ds
   spring.shardingsphere.mode.repository.props.server-lists=localhost:2181
   spring.shardingsphere.mode.overwrite=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.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

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