mycat schema.xml配置:
<schema name="zxing" checkSQLschema="false" sqlMaxLimit="100">
<table name="salesman" primaryKey="id" autoIncrement="true" dataNode="dn2,dn3" rule="mod2" /></schema>
rule.xml配置:
<tableRule name="mod2">
<rule>
<columns>id</columns>
<algorithm>mod-long</algorithm>
</rule>
</tableRule>
<function name="mod-long" class="io.mycat.route.function.PartitionByMod">
<!-- how many data nodes -->
<property name="count">2</property>
</function>
dataNode为实际存储库的别名,rule为分表规则。。