opengauss数据库怎么通过JDBC设置主从库啊,网上的资源都好少,我这样写对吗?求各位帮助一下。
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClassName" value="org.postgresql.Driver" />
<property name="urL" value="jdbc:postgresql://195.220.11.10:2600,195.220.11.11:2600/cuser" /›
<property name="username" value="${cspdbUsername}" /›
<property name="password" value="${encry_cspdbpassword}" />
</bean>
你这个配置方式只是全连吧,开启主从模式要使用targetServerType参数,可以看一下官网解释:
targetServerType = {any, master, slave, preferSlave}
any表示连接到任意节点
preferSlave表示优先连接到slave节点
master或slave表示连接到master或slave节点。
案例:
For example an application can create two connection pools.
One data source is for writes, another for reads.
The write pool limits connections only to master node:
jdbc:postgresql://node1,node2,node3/accounting?targetServerType=master .
And read pool balances connections between slaves nodes, but allows connections also to master if no slaves are available:
jdbc:postgresql://node1,node2,node3/accounting?targetServerType=preferSlave&loadBalanceHosts=true