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 2020/03/24 12:18:54 UTC

[GitHub] [incubator-shardingsphere] pkwenda opened a new issue #4921: Is this UI module available ?

pkwenda opened a new issue #4921: Is this UI module available ?
URL: https://github.com/apache/incubator-shardingsphere/issues/4921
 
 
   ## Question
   
   **For English only**, other languages will not accept.
   
   Before asking a question, make sure you have:
   
   - Googled your question.
   - Searched open and closed [GitHub issues](https://github.com/apache/incubator-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 **more than 7 days** and we cannot reproduce it on current information, we will **close it**.
   
   
   ## I tried to start the project,How to use it ?
   
   ![image](https://user-images.githubusercontent.com/14212375/77424045-75e72680-6e0b-11ea-890f-3d0c14bff55c.png)
   
   ![image](https://user-images.githubusercontent.com/14212375/77424067-7b447100-6e0b-11ea-880f-c07ad149e21b.png)
   
   
   But I don't know what I'm supposed to fill in, The documentation is not clear , right
   
   Is need me copy the yml configuration above java project  into here ? 
   
   I want to know the principle of it, increase the relevant configuration about `consul` 
   
   but now , i can't know how to  add schem and orther setting

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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] pkwenda edited a comment on issue #4921: Is this UI module available ?

Posted by GitBox <gi...@apache.org>.
pkwenda edited a comment on issue #4921: Is this UI module available ?
URL: https://github.com/apache/incubator-shardingsphere/issues/4921#issuecomment-603206448
 
 
   this label is `UI`.  please  @wqzwh 

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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] kimmking commented on issue #4921: Is this UI module available ?

Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4921: Is this UI module available ?
URL: https://github.com/apache/incubator-shardingsphere/issues/4921#issuecomment-615080982
 
 
   As the question is answered, we will close this issue now.

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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] kimmking closed issue #4921: Is this UI module available ?

Posted by GitBox <gi...@apache.org>.
kimmking closed issue #4921: Is this UI module available ?
URL: https://github.com/apache/incubator-shardingsphere/issues/4921
 
 
   

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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] pkwenda commented on issue #4921: Is this UI module available ?

Posted by GitBox <gi...@apache.org>.
pkwenda commented on issue #4921: Is this UI module available ?
URL: https://github.com/apache/incubator-shardingsphere/issues/4921#issuecomment-603215412
 
 
   I have configured zookeeper in Java yml
   
   ![image](https://user-images.githubusercontent.com/14212375/77426524-9ca75c00-6e0f-11ea-83fd-834a4eb1f458.png)
   
   in ui project : 
   
   ![image](https://user-images.githubusercontent.com/14212375/77426585-be084800-6e0f-11ea-8ccf-823f623479cc.png)
   
   
   

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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] menghaoranss commented on issue #4921: Is this UI module available ?

Posted by GitBox <gi...@apache.org>.
menghaoranss commented on issue #4921: Is this UI module available ?
URL: https://github.com/apache/incubator-shardingsphere/issues/4921#issuecomment-603699654
 
 
   @pkwenda you can refer to reply from @SanmuWangZJU , and we will add  configuration examples on the UI in subsequent versions. 

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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] pkwenda commented on issue #4921: Is this UI module available ?

Posted by GitBox <gi...@apache.org>.
pkwenda commented on issue #4921: Is this UI module available ?
URL: https://github.com/apache/incubator-shardingsphere/issues/4921#issuecomment-603714874
 
 
   I have a question.
   
   Why YamlTableRuleConfiguration.java  not have `defaultKeyGenerator` and `defaultDatabaseStrategy` field ? 
   
   because I add this yml setting 
   
   ```
     tables:
       litemall_electronic_coupon_item:
         actualDataNodes: uat-litemall-$->{0}.litemall_electronic_coupon_item
         databaseStrategy:
           standard:
             shardingColumn: company_id   
             preciseAlgorithmClassName: org.apache.shardingsphere.ui.sharding.DataBaseShardingAlgorithm  
       litemall_coupon_user:
         actualDataNodes: uat-litemall-$->{0}.litemall_coupon_user
         databaseStrategy:
           standard:
             shardingColumn: user_id   
             preciseAlgorithmClassName: org.apache.shardingsphere.ui.sharding.DataBaseShardingAlgorithm  
     bindingTables:
       - litemall_electronic_coupon_item,litemall_coupon_user
     defaultDatabaseStrategy: # 默认分库 company_id
       standard:
         sharding-column: company_id
         preciseAlgorithmClassName: org.linlinjava.litemall.db.sharding.DataBaseShardingAlgorithm
     defaultKeyGenerator:
       type: SNOWFLAKE
       column: id
   ```
   it is wrong
   
    
   ![image](https://user-images.githubusercontent.com/14212375/77517427-0f1f4700-6eb7-11ea-9e83-87cc7b1b2aeb.png)
   
   
   
   but I write another way is ok (del defaultXXX yml key ):
   
   ```
     tables:
       litemall_electronic_coupon_item:
         actualDataNodes: uat-litemall-$->{0}.litemall_electronic_coupon_item
         databaseStrategy:
           standard:
             shardingColumn: company_id   
             preciseAlgorithmClassName: org.apache.shardingsphere.ui.sharding.DataBaseShardingAlgorithm  
         keyGenerator:
           type: SNOWFLAKE
           column: order_item_id    
       litemall_coupon_user:
         actualDataNodes: uat-litemall-$->{0}.litemall_coupon_user
         databaseStrategy:
           standard:
             shardingColumn: user_id   
             preciseAlgorithmClassName: org.apache.shardingsphere.ui.sharding.DataBaseShardingAlgorithm  
         keyGenerator:
           type: SNOWFLAKE
           column: order_item_id    
     bindingTables:
       - litemall_electronic_coupon_item,litemall_coupon_user
   
   ```
   
   Was it designed this way ? OR BUG ?
   
   IF it is bug , Can I fix it ?

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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] kimmking commented on issue #4921: Is this UI module available ?

Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4921: Is this UI module available ?
URL: https://github.com/apache/incubator-shardingsphere/issues/4921#issuecomment-603306140
 
 
   @menghaoranss will follow this issue.
   

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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] pkwenda commented on issue #4921: Is this UI module available ?

Posted by GitBox <gi...@apache.org>.
pkwenda commented on issue #4921: Is this UI module available ?
URL: https://github.com/apache/incubator-shardingsphere/issues/4921#issuecomment-603206448
 
 
   this label is `UI`.  please

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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] kimmking commented on issue #4921: Is this UI module available ?

Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4921: Is this UI module available ?
URL: https://github.com/apache/incubator-shardingsphere/issues/4921#issuecomment-603300692
 
 
   which version?

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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] pkwenda commented on issue #4921: Is this UI module available ?

Posted by GitBox <gi...@apache.org>.
pkwenda commented on issue #4921: Is this UI module available ?
URL: https://github.com/apache/incubator-shardingsphere/issues/4921#issuecomment-603716428
 
 
   I can run, and i can find info at zookeeper now ! thank you very much @SanmuWangZJU 
   
    
   ![image](https://user-images.githubusercontent.com/14212375/77518086-185ce380-6eb8-11ea-875b-66e848df4179.png)
   
   
   ![image](https://user-images.githubusercontent.com/14212375/77518060-109d3f00-6eb8-11ea-8bf5-feebbab73391.png)
   
   
   

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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] SanmuWangZJU commented on issue #4921: Is this UI module available ?

Posted by GitBox <gi...@apache.org>.
SanmuWangZJU commented on issue #4921: Is this UI module available ?
URL: https://github.com/apache/incubator-shardingsphere/issues/4921#issuecomment-603341679
 
 
   I think you can refer to source code in `sharding-ui-backend` module while filling config in ui.
   
   - for version 4.x, config check/update/load are implement in `org.apache.shardingsphere.ui.servcie.impl`
   
   - `Props` can refer to `org.apache.shardingsphere.ui.util.ConfigurationYamlConverter#loadProperties` , content should like [official guide](https://shardingsphere.apache.org/document/current/en/manual/sharding-proxy/configuration/#proxy-property), **but without the first line `prop:`**
   
   - `Authentication` can refer to `org.apache.shardingsphere.core.yaml.config.common.YamlAuthenticationConfiguration`, content should like [official guide](https://shardingsphere.apache.org/document/current/en/manual/sharding-proxy/configuration/#authentication-1), **but without the first line `authentication:`**
   authentications here control your access to proxy rather than backend-mysql
   
   - `Schema` can refer to `org.apache.shardingsphere.ui.servcie.impl.ShardingSchemaServiceImpl#checkRuleConfiguration` you can config encryptor/master-slave only/sharding(also can config master-slave), 
   
     + following example for datasource config
   
     ```yaml
     ds0: !!org.apache.shardingsphere.orchestration.yaml.config.YamlDataSourceConfiguration
       dataSourceClassName: com.zaxxer.hikari.HikariDataSource
       properties:
         url: jdbc:mysql://ip:port/schema
         username: 
         password: 
         maxPoolSize: 
     ```
   
     + following examples for rule config
   
     ```yaml
     # master-slave-only
     ms_ds0:
         masterDataSourceName: ds0
         slaveDataSourceNames:
           - ds0_slave
         loadBalanceAlgorithmType: ROUND_ROBIN
     ```
   
     ```yaml
     # sharding with master-slave
     tables:
       logic_table_name: 
           actualDataNodes: 
           databaseStrategy:
           inline:
             shardingColumn: 
             algorithmExpression: 
         tableStrategy: 
           inline:
             shardingColumn: 
             algorithmExpression: 
     defaultTableStrategy:
       none:
   
     masterSlaveRules:
       ms_ds0:
         masterDataSourceName: ds0
         slaveDataSourceNames:
           - ds0_slave
         loadBalanceAlgorithmType: ROUND_ROBIN
       ms_ds1:
         masterDataSourceName: ds1
         slaveDataSourceNames: 
           - ds1_slave
         loadBalanceAlgorithmType: ROUND_ROBIN
     ```

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


With regards,
Apache Git Services