1.配置schema.xml cd /usr/local/mycat/conf
1.1由小到大先配置dataHost
writeType="0" dbType="mysql" dbDriver="native" switchType="1">
<heartbeat>select user()</heartbeat>
<!-- can have multi write hosts -->
<writeHost host="106.54.86.44" url="106.54.86.44:3306" user="im_mycat"
password="123456">
</writeHost>
<!-- 配置相應(yīng)的節(jié)點(diǎn)ip-->
</dataHost>
1.2接下來(lái)配置DataNode標(biāo)簽恩伺，將dataHost加入
<dataNode name="ordb" dataHost="mysql0102" database="order_db" />
database就是該節(jié)點(diǎn)上的物理庫(kù)
1.3配置schema標(biāo)簽
<schema name="imooc_db" checkSQLschema="false" sqlMaxLimit="100">
<!-- auto sharding by id (long) -->
<table name="order_master" dataNode="ordb" primaryKey="order_id" />
<!-- global table is auto cloned to all defined data nodes ,so can join
with any table whose sharding node is in the same data node -->
<table name="order_detail" primaryKey="order_detail_id" dataNode="ordb" />
<table name="order_cart" primaryKey="cart_id" dataNode="ordb" />
<!-- random sharding using mod sharind rule -->
<table name="order_customer_addr" primaryKey="customer_addr_id" dataNode="ordb" />
<!-- <table name="dual" primaryKey="ID" dataNode="dnx,dnoracle2" type="global"
rule="mod-long" /> -->
<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_product" 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"
/>
<table name="customer_balance_log" primaryKey="balance_id" dataNode="prodb"
/>
<table name="customer_inf" primaryKey="customer_inf_id" dataNode="prodb"
/>
<table name="customer_level_inf" primaryKey="customer_level" dataNode="prodb"
/>
<table name="customer_login" primaryKey="customer_id" dataNode="prodb"
/>
<table name="customer_login_log" primaryKey="login_id" dataNode="prodb"
/>
<table name="customer_point_log" primaryKey="point_id" dataNode="prodb"
/>
<!-- <table name="oc_call" primaryKey="ID" dataNode="dn1$0-743" rule="latest-month-calldate"
/> -->
</schema>
將各個(gè)表加入到邏輯庫(kù)中
2配置server.xml
2.1配置system標(biāo)簽
<property name="nonePasswordLogin">0</property> <!-- 0為需要密碼登陸探熔、1為不需要密碼登陸 ,默認(rèn)為0段直，設(shè)置為1則需>要指定默認(rèn)賬戶-->
<property name="useHandshakeV10">1</property>
<property name="managerPort">9066</property>
<property name="serverPort">8066</property>
<property name="idleTimeout">300000</property>
<property name="frontWriteQueueSize">2048</property>
<property name="bindIp">0.0.0.0</property>
<property name="charset">utf8</property>
<property name="txIsolation">2</property>
<property name="processors">8</property>
<property name="sqlExecuteTimeout">300</property>
<property name="useSqlStat">0</property> <!-- 1為開(kāi)啟實(shí)時(shí)統(tǒng)計(jì)痕貌、0為關(guān)閉 -->
<property name="useGlobleTableCheck">0</property> <!-- 1為開(kāi)啟全加班一致性檢測(cè)秘蛔、0為關(guān)閉 -->
<property name="defaultMaxLimit">100</property>
<property name="maxPacketSize">104857600</property>
<property name="sequnceHandlerType">2</property>
<property name="subqueryRelationshipCheck">false</property>
2.2配置user標(biāo)簽
<property name="password">19980504Jcy@</property>
<property name="schemas">imooc_db</property>
</user>
schemas一定是schema.xml里配置的邏輯庫(kù)市怎，不能是物理庫(kù)不然會(huì)報(bào)錯(cuò)
3.啟動(dòng)MyCat
3.1放開(kāi)8066端口
3.2啟動(dòng)MyCatcd /usr/local/mycat/bin ./mycat start
查看是否啟動(dòng)成功cd ../logs cat wrapper.log
成功
image.png
image.png
啟動(dòng)不成功可查看wrapper.log排查
3.3mysql -uapp_imooc -p -h49.234.222.222 -P8066通過(guò)MyCat連接到邏輯庫(kù)
成功
image.png
