novice-gamer opened a new issue, #16795:
URL: https://github.com/apache/shardingsphere/issues/16795
# Problem background
The shardingsphere proxy (version 5.1.0) is configured with zookeeper。
- This is version 5.1.0 of the connection
```sql
mysql> use customer_delivery_dev;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show schema resources;
+------+-------+-------------+------+-----------------------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| name | type | host | port | db |
connection_timeout_milliseconds | idle_timeout_milliseconds |
max_lifetime_milliseconds | max_pool_size | min_pool_size | read_only |
other_attributes
|
+------+-------+-------------+------+-----------------------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ds_0 | MySQL | 192.168.1.6 | 3306 | customer_delivery_dev | 30000
| 60000 | 2100000 | 50
| 1 | false |
{"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","useSSL":"false","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false","useLocalSessionState":"true","maintainTimeStats":"false","prepStmtCacheSize":"200000","tinyInt1isBit":"false","prepStmtCacheSqlLimit":"2048","serverTimezone":"UTC","netTimeoutForStreamingResults":"0"},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
+------+-------+-------------+------+-----------------------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql>
```
After that, I downloaded the latest version 5.1.1 and used the same
zookeeper.
Although you can log in with the same user name and password, there are no
data sources
- This is version 5.1.1 of the connection
```sql
mysql> use customer_delivery_dev;
Database changed
mysql> show schema resources;
Empty set (0.00 sec)
mysql>
```
-------
5.1.1 version configuration file：
```yaml
mode:
type: Cluster
repository:
type: ZooKeeper
props:
namespace: governance_ds
server-lists: zk_host:2181
retryIntervalMilliseconds: 500
timeToLiveSeconds: 60
maxRetries: 3
operationTimeoutMilliseconds: 500
overwrite: false
```
Excuse me, are the versions incompatible or do you need to configure other
parameters?
--
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]
