报错： schema product_db refered by user app

报错： schema product_db refered by user app_imooc is not exist!

来源：4-10 垂直切分server文件配置

慕标4577186

2020-09-25

[root@node1 conf]# cat server.xml

<?xml version="1.0" encoding="UTF-8"?>

<mycat:server xmlns:mycat=“http://io.mycat/”>

8066
9066
0
1
0
0
2
false
0
0
1
64k
1k
0
384m
false
utf8
2
8
1800000
300
104857600
100

1
bDbWr7bVMgszTe82oMo8NaUsmFFdPCNl/lYXzOYoG8anTpQLvdx5e+LYJEmT0IAeSVp1loyxSZPyv1GoHbHFHg==
order_db,product_db,customer_db

</mycat:server>
######################

[root@node1 conf]# cat schema.xml

<?xml version="1.0"?>

<mycat:schema xmlns:mycat=“http://io.mycat/”>

<schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100">
	<table name="order_master"            primaryKey="order_id"          dataNode="order"/>
	<table name="order_detail"            primaryKey="order_detail_id"   dataNode="order"/>
	<table name="order_cart"              primaryKey="cart_id"           dataNode="order"/>
	<table name="order_customer_addr"     primaryKey="customer_addr_id"  dataNode="order"/>
	<table name="region_info"             primaryKey="region_id"         dataNode="order"/>
	<table name="shipping_info"           primaryKey="ship_id"           dataNode="order"/>

	<table name="product_brand_info"      primaryKey="brand_id"           dataNode="prodb"/>
	<table name="product_category"        primaryKey="category_id"        dataNode="prodb"/>
	<table name="product_comment"         primaryKey="comment_id"         dataNode="prodb"/>
	<table name="product_info"            primaryKey="product_id"         dataNode="prodb"/>
	<table name="product_pic_info"        primaryKey="product_pic_id"     dataNode="prodb"/>
	<table name="product_supplier_info"   primaryKey="supplier_id"        dataNode="prodb"/>

	<table name="customer_balance_log"   primaryKey="balance_id"          dataNode="custdb"/>
	<table name="customer_inf"           primaryKey="customer_inf_id"     dataNode="custdb"/>
	<table name="customer_level_inf"     primaryKey="customer_level"      dataNode="custdb"/>
	<table name="customer_login"         primaryKey="customer_id"         dataNode="custdb"/>
	<table name="customer_login_log"     primaryKey="login_id"            dataNode="custdb"/>
	<table name="customer_point_log"     primaryKey="point_id"            dataNode="custdb"/>
</schema>


<dataNode name="order"  dataHost="mysql42" database="order_db" />
<dataNode name="prodb"  dataHost="mysql43" database="product_db" />
<dataNode name="custdb" dataHost="mysql44" database="customer_db" />


<dataHost name="mysql42" maxCon="1000" minCon="10" balance="3"   writeType="0" 
         dbType="mysql" dbDriver="native" switchType="1">
	<heartbeat>select user()</heartbeat>
	<writeHost host="192.168.3.142" url="192.168.3.142:3306" user="im_mycat"  password="123456"/>
</dataHost>

<dataHost name="mysql43" maxCon="1000" minCon="10" balance="3"   writeType="0" 
         dbType="mysql" dbDriver="native" switchType="1">
	<heartbeat>select user()</heartbeat>
	<writeHost host="192.168.3.143" url="192.168.3.143:3306" user="im_mycat"  password="123456"/>
</dataHost>

<dataHost name="mysql44" maxCon="1000" minCon="10" balance="3"   writeType="0" 
         dbType="mysql" dbDriver="native" switchType="1">
	<heartbeat>select user()</heartbeat>
	<writeHost host="192.168.3.144" url="192.168.3.144:3306" user="im_mycat"  password="123456"/>
</dataHost>

</mycat:schema>
请老师帮忙看下这个问题。

写回答

2回答

慕标4577186

提问者

2020-09-26

已经解决

慕标4577186

提问者

2020-09-25

[root@node1 mycat]# cat  conf/server.xml 
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mycat:server SYSTEM "server.dtd">
<mycat:server xmlns:mycat="http://io.mycat/">
         <system>
             <property name="serverPort">8066</property>
             <property name="managerPort">9066</property>
             <property name="nonePasswordLogin">0</property>
             <property name="useHandshakeV10">1</property>
             <property name="useSqlStat">0</property>
             <property name="useGlobleTableCheck">0</property>
             <property name="sequnceHandlerType">2</property>
             <property name="subqueryRelationshipCheck">false</property>
             <property name="processorBufferPoolType">0</property>
             <property name="handleDistributedTransactions">0</property>
             <property name="useOffHeapForMerge">1</property>
             <property name="memoryPageSize">64k</property>
             <property name="spillsFileBufferSize">1k</property>
             <property name="useStreamOutput">0</property>
             <property name="systemReserveMemorySize">384m</property>
             <property name="useZKSwitch">false</property>
             <property name="charset">utf8</property>
             <property name="txIsolation">2</property>
             <property name="processors">8</property>
             <property name="idleTimeout">1800000</property>
             <property name="sqlExecuteTimeout">300</property>
             <property name="maxPacketSize">104857600</property>
             <property name="defaultMaxLimit">100</property>
         </system>
         <user name="app_imooc" defaultAccount="true">
             <property name="usingDecrypt">1</property>
             <property name="password">bDbWr7bVMgszTe82oMo8NaUsmFFdPCNl/lYXzOYoG8anTpQLvdx5e+LYJEmT0IAeSVp1loyxSZPyv1GoHbHFHg==</property>
             <property name="schemas">order_db,product_db,customer_db</property>
         </user>
</mycat:server>

MyCAT+MySQL搭建高可用企业级数据库集群

国内顶级DBA亲授，精讲企业级MyCAT应用

816 学习 · 223 问题

查看课程

相似问题

垂直分库配置后，mycat start 无法启动

回答 1

mycat可以正常启动日志没有报错但是不能访问mycat

回答 1

schemas

回答 1

ERROR 1045 (28000): Access denied for user 'app_imooc'@'192.168.194.158'

回答 1

提示这样的错误是什么情况

回答 2

打开慕课网App查看更多内容