You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "Pace2Car (via GitHub)" <gi...@apache.org> on 2023/05/25 07:14:23 UTC
[GitHub] [shardingsphere] Pace2Car opened a new issue, #25883: The style of JDBC's global rule should be consistent with Proxy
Pace2Car opened a new issue, #25883:
URL: https://github.com/apache/shardingsphere/issues/25883
Hi community,
Now the global rule configuration styles of Proxy and JDBC are not unified.
The configuration of Proxy is like this
```yaml
transaction:
defaultType: LOCAL
sqlParser:
sqlCommentParseEnabled: false
sqlStatementCache:
initialCapacity: 2000
maximumSize: 65535
parseTreeCache:
initialCapacity: 128
maximumSize: 1024
authority:
users:
- user: root@%
password: roott
- user: sharding
password: sharding
privilege:
type: ALL_PERMITTED
logging:
loggers:
- loggerName: ShardingSphere-SQL
additivity: true
level: INFO
props:
enable: false
globalClock:
enabled: false
type: TSO
provider: local
sqlTranslator:
type: NATIVE
useOriginalSQLWhenTranslatingFailed: false
```
The configuration of JDBC is like this
```yaml
rules:
- !AUTHORITY
privilege:
type: ALL_PERMITTED
users:
- password: root
user: root@%
- password: sharding
user: sharding@%
- !TRANSACTION
defaultType: LOCAL
- !SQL_PARSER
parseTreeCache:
initialCapacity: 128
maximumSize: 1024
sqlCommentParseEnabled: false
sqlStatementCache:
initialCapacity: 2000
maximumSize: 65535
- !SQL_TRANSLATOR
type: NATIVE
useOriginalSQLWhenTranslatingFailed: false
- !GLOBAL_CLOCK
enabled: false
provider: local
type: TSO
- !LOGGING
loggers:
- additivity: true
level: INFO
loggerName: ShardingSphere-SQL
props:
enable: false
```
I recommend using the Proxy style uniformly.
--
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.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #25883: The style of JDBC's global rule should be consistent with Proxy
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #25883:
URL: https://github.com/apache/shardingsphere/issues/25883#issuecomment-1562476326
@Pace2Car
Please update example and documents, thank you!
--
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
[GitHub] [shardingsphere] RaigorJiang closed issue #25883: The style of JDBC's global rule should be consistent with Proxy
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #25883: The style of JDBC's global rule should be consistent with Proxy
URL: https://github.com/apache/shardingsphere/issues/25883
--
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