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

来源:4-13 MyCAT验证配置

风影468089

2020-03-15

mycat启动日志:
图片描述
mycat.log
图片描述
访问mycat不成功
图片描述
schema 配置:

<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">

	<schema name="imooc_db" checkSQLschema="false" sqlMaxLimit="100">
		<table name="order_master" primaryKey="order_id" dataNode="ordb" />
		<table name="order_detail" primaryKey="order_detail_id" dataNode="ordb" />
		<table name="order_cart" primaryKey="cart_id" dataNode="ordb" />
		<table name="order_customer_addr" primaryKey="customer_addr_id" dataNode="ordb" />
		<table name="region_info" primaryKey="region_id" dataNode="ordb" />
		<table name="shipping_info" primaryKey="ship_id" dataNode="ordb" />
		<table name="warehouse_info" primaryKey="w_id" dataNode="ordb" />
		<table name="warehouse_proudct" primaryKey="wp_id" dataNode="ordb" />
		<table name="product_brand_infos" 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_supplier_info" primaryKey="supplier_id" dataNode="prodb" />
		<table name="product_pic_info" primaryKey="product_pic_id" dataNode="prodb" />
	</schema>

	<dataNode name="ordb" dataHost="mysql129" database="order_db" />
	<dataNode name="prodb" dataHost="mysql130" database="product_db" />
	<dataNode name="custdb" dataHost="mysql131" database="customer_db" />

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

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

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

</mycat:schema>

server配置:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mycat:server SYSTEM "server.dtd">
<mycat:server xmlns:mycat="http://io.mycat/">

	<system>
		<property name="serverPort">8806</property>
		<property name="managerPort">9066</property>
		<property name="nonePasswordLogin">0</property>
		<property name="bindIp">0.0.0.0</property>
		<property name="frontWriteQueueSize">2048</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="useSqlStat">0</property>
		<property name="useGlobleTableCheck">0</property>
		<property name="sequnceHandlerType">1</property>
		<property name="defaultMaxLimit">100</property>
		<property name="maxPacketSize">104857600</property>
	</system>

	<user name="app_imooc" defaultAccount="true">
		<property name="password">123456</property>
		<property name="schemas">imooc_db</property>
	</user>

</mycat:server>


qq:547207484

写回答

1回答

风影468089

提问者

2020-03-15

mysql -uapp_imooc -p -h192.168.108.128 -P9066 这样可以访问://img1.sycdn.imooc.com/szimg/5e6dc72e0964f20712540662.jpg

mysql -uapp_imooc -p -h192.168.108.128 -P8066 就访问不了:

//img1.sycdn.imooc.com/szimg/5e6dc75e095bf5fa13160274.jpg

0
2
慕标4577186
回复
风影468089
你好,同学,你这个报错:schema product_db refered by user app_imooc is not exist! 是如何解决的,我也遇到了这个问题,请赐教。
2020-09-25
共2条回复

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

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

816 学习 · 223 问题

查看课程