zjcnb opened a new issue #14216: URL: https://github.com/apache/shardingsphere/issues/14216
### Which version of ShardingSphere did you use? master. ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy? ShardingSphere-Proxy. ### Expected behavior first time set proxy props take effect. ### Actual behavior not take effect. ### Reason analyze (If you can) Maybe less one event. ### Intuitive performance  ### Proxy configuration `server.yaml:` ``` mode: type: Cluster repository: type: ZooKeeper props: namespace: database_discovery server-lists: localhost:2181 retryIntervalMilliseconds: 500 timeToLiveSeconds: 60 maxRetries: 3 operationTimeoutMilliseconds: 500 overwrite: true rules: - !AUTHORITY users: - root@%:root - sharding@:sharding provider: type: ALL_PRIVILEGES_PERMITTED # - !TRANSACTION # defaultType: XA # providerType: Atomikos # - !SQL_PARSER # sqlCommentParseEnabled: true # sqlStatementCache: # initialCapacity: 2000 # maximumSize: 65535 # concurrencyLevel: 4 # parserTreeCache: # initialCapacity: 128 # maximumSize: 1024 # concurrencyLevel: 4 #props: # max-connections-size-per-query: 1 # kernel-executor-size: 16 # Infinite by default. # proxy-frontend-flush-threshold: 128 # The default value is 128. # proxy-opentracing-enabled: false # proxy-hint-enabled: false # sql-show: true # check-table-metadata-enabled: false # show-process-list-enabled: false # # Proxy backend query fetch size. A larger value may increase the memory usage of ShardingSphere Proxy. # # The default value is -1, which means set the minimum value for different JDBC drivers. # proxy-backend-query-fetch-size: -1 # check-duplicate-table-enabled: false # sql-comment-parse-enabled: false # proxy-frontend-executor-size: 0 # Proxy frontend executor size. The default value is 0, which means let Netty decide. # # Available options of proxy backend executor suitable: OLAP(default), OLTP. The OLTP option may reduce time cost of writing packets to client, but it may increase the latency of SQL execution # # if client connections are more than proxy-frontend-netty-executor-size, especially executing slow SQL. # proxy-backend-executor-suitable: OLAP # proxy-frontend-max-connections: 0 # Less than or equal to 0 means no limitation. # sql-federation-enabled: false ``` `config-database-discovery.yaml:` ``` schemaName: database_discovery_db dataSources: ds_0: url: jdbc:mysql://127.0.0.1:13306/demo_primary_ds?serverTimezone=UTC&useSSL=false username: root password: 123456 connectionTimeoutMilliseconds: 3000 idleTimeoutMilliseconds: 60000 maxLifetimeMilliseconds: 1800000 maxPoolSize: 50 minPoolSize: 1 ds_1: url: jdbc:mysql://127.0.0.1:13307/demo_primary_ds?serverTimezone=UTC&useSSL=false username: root password: 123456 connectionTimeoutMilliseconds: 3000 idleTimeoutMilliseconds: 60000 maxLifetimeMilliseconds: 1800000 maxPoolSize: 50 minPoolSize: 1 ds_2: url: jdbc:mysql://127.0.0.1:13308/demo_primary_ds?serverTimezone=UTC&useSSL=false username: root password: 123456 connectionTimeoutMilliseconds: 3000 idleTimeoutMilliseconds: 60000 maxLifetimeMilliseconds: 1800000 maxPoolSize: 50 minPoolSize: 1 rules: - !READWRITE_SPLITTING dataSources: rd_rs: autoAwareDataSourceName: pr_ds - !DB_DISCOVERY dataSources: pr_ds: dataSourceNames: - ds_0 - ds_1 - ds_2 discoveryHeartbeatName: mgr-heartbeat discoveryTypeName: mgr discoveryHeartbeats: mgr-heartbeat: props: keep-alive-cron: '0/5 * * * * ?' discoveryTypes: mgr: type: MGR props: group-name: b13df29e-90b6-11e8-8d1b-525400fc3996 ``` -- 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]
