期望：shardingsphere-proxy +opengauss 实现动态读写分离和高可用

配置文件：

server.yaml

mode:
type: Cluster
repository:
type: ZooKeeper
props:
namespace: governance_ds
#server-lists: 10.26.223.161:2181,10.26.223.160:2181,10.26.223.162:2181
server-lists: 10.26.223.160:2181
retryIntervalMilliseconds: 500
timeToLiveSeconds: 60
maxRetries: 3
operationTimeoutMilliseconds: 500

authority:
users:
- user: user1@%
password: kunpeng_1234
- user: qxk@%
password: kunpeng_1234
privilege:
type: ALL_PERMITTED

config-database-discovery.yaml

databaseName: database_discovery_db
dataSources:
ds_0:
url: jdbc:postgresql://10.26.223.160:15400/test?serverTimezone=UTC&useSSL=false
username: user1
password: kunpeng
connectionTimeoutMilliseconds: 3000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
ds_1:
url: jdbc:postgresql://10.26.223.161:15400/test?serverTimezone=UTC&useSSL=false
username: user1
password: kunpeng
connectionTimeoutMilliseconds: 3000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
ds_2:
url: jdbc:postgresql://10.26.223.162:15400/test?serverTimezone=UTC&useSSL=false
username: user1
password: kunpeng
connectionTimeoutMilliseconds: 3000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
rules:
- !DB_DISCOVERY
dataSources:
readwrite_ds:
dataSourceNames:
- ds_0
- ds_1
- ds_2
discoveryHeartbeatName: opengauss-heartbeat
discoveryTypeName: MogDB
discoveryHeartbeats:
opengauss_heartbeat:
props:
keep-alive-cron: '0/5 * * * * ?'
discoveryTypes:
MogDB:
type: opengauss
props:
group-name: 92504d5b-6dec-11e8-91ea-246e9612aaf1
- !READWRITE_SPLITTING
dataSources:
readwrite_ds:
type: Dynamic
props:
auto-aware-data-source-name: readwrite_ds
write-data-source-query-enabled: true
loadBalancerName: random
loadBalancers:
random:
type: RANDOM

日志文件：

Caused by: Cannot create property=dataSources for JavaBean=org.apache.shardingsphere.readwritesplitting.yaml.config.YamlReadwriteSplittingRuleConfiguration@1c72da34
in 'reader', line 51, column 3:
- !READWRITE_SPLITTING
^
Cannot create property=type for JavaBean=org.apache.shardingsphere.readwritesplitting.yaml.config.rule.YamlReadwriteSplittingDataSourceRuleConfiguration@49e202ad
in 'reader', line 54, column 7:
type: Dynamic
^
Unable to find property 'type' on class: org.apache.shardingsphere.readwritesplitting.yaml.config.rule.YamlReadwriteSplittingDataSourceRuleConfiguration
in 'reader', line 54, column 13:
type: Dynamic
^

in 'reader', line 53, column 5:
readwrite_ds: