Maycat中间件三个重要的配置

最新推荐文章于 2024-05-05 13:10:07 发布

S-_-Lei

最新推荐文章于 2024-05-05 13:10:07 发布

阅读量216

点赞数

分类专栏：数据库文章标签： mycat sql

本文链接：https://blog.csdn.net/S___Lei/article/details/115138610

版权

数据库专栏收录该内容

4 篇文章 0 订阅

订阅专栏

1、server.xml：指定Mycat服务的端口、用户和密码；

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mycat:server SYSTEM "server.dtd">
<mycat:server xmlns:mycat="http://io.mycat/">
    <system>
        <property name="sequnceHandlerType">0</property>
        <property name="useOffHeapForMerge">0</property>
        <property name="serverPort">8080</property>
        <property name="managerPort">9966</property>
    </system>

    <user name="user1">
        <property name="password">123456</property>
        <property name="schemas">ceshidb</property>
    </user>
</mycat:server>

2、rule.xml：分片规则；指明表的分库字段和分库算法

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mycat:rule SYSTEM "rule.dtd">
<mycat:rule xmlns:mycat="http://io.mycat/">
	<tableRule name="rule_txn_no">
		<rule>
			<columns>txn_no</columns>
			<algorithm>sharding-by-stringhash</algorithm>
		</rule>
	</tableRule>
	<tableRule name="rule_tran_no">
		<rule>
			<columns>tran_no</columns>
			<algorithm>sharding-by-stringhash</algorithm>
		</rule>
	</tableRule>
	
	<function name="sharding-by-stringhash"                 class="io.mycat.route.function.PartitionByString">
		<property name="partitionLength">512,512</property>
		<property name="partitionCount">1,1</property>
		<property name="hashSlice">-6:0</property>
	</function>
</mycat:rule>

3、schema.xml：逻辑库，逻辑表，数据节点；指明表名及其是否分库，分库字段规则。

<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">
	<schema name="ceshidb" checkSQLschema="false" sqlMaxLimit="1000000">
		<table name="t_user" dataNode="db0"/>
		<table name="t_user_role" dataNode="db0,db2" rule="rule_tran_no"/>
		<table name="t_user_right" dataNode="db0,db2,db3" rule="rule_txn_no"/>
	</schema>
	<dataNode name="db0" dataHost="host0" database="ceshidb_0"/>
	<dataNode name="db1" dataHost="host1" database="ceshidb_1"/>
	<dataNode name="db2" dataHost="host2" database="ceshidb_2"/>

	<dataHost name="host0" maxCon="50" minCon="1" balance="0" writeType="0"  dbType="mysql" dbDriver="native">
		<heartbeat>select user()</heartbeat>
		<writeHost host="master" url="10.192.168.1:8081" user="ceshi_user" password="ceshi123"></writeHost>
	</dataHost>
	<dataHost name="host1" maxCon="50" minCon="1" balance="0" writeType="0"  dbType="mysql" dbDriver="native">
		<heartbeat>select user()</heartbeat>
		<writeHost host="master" url="10.192.168.2:8081" user="ceshi_user" password="ceshi123"></writeHost>
	</dataHost>
	<dataHost name="host2" maxCon="50" minCon="1" balance="0" writeType="0"  dbType="mysql" dbDriver="native">
		<heartbeat>select user()</heartbeat>
		<writeHost host="master" url="10.192.168.3:8081" user="ceshi_user" password="ceshi123"></writeHost>
	</dataHost>
</mycat:schema>