匿名用户mycat配置oracle读写分离
按照步骤配置完成之后,
<dataNode name="dn1" dataHost="oracle1" database="user"/>
<dataHost name="oracle1" maxCon="1000" minCon="1" balance="0" writeType="0" dbType="oracle" dbDriver="jdbc"> <heartbeat>select 1 from dual</heartbeat>
<connectionInitSql>alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss'</connectionInitSql>
<writeHost host="hostM1" url="jdbc:oracle:thin:@10.0.x.x:1521:tzdb" user="user" password="123456"> </writeHost>
启动mycat后,登录
mysql> use TESTDB;
Database changed
mysql> show tables;
Empty set (0.00 sec) 为啥查不到表?
我来答
添加附件
收藏
问题补充
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏

