- 3-1 章节综述
- 3-2 常用配置文件间的关系
- 3-3 server.xml配置详解
- 3-4 log4j2.xml配置文件
- 3-5 rule.xml
- 3-6 常用分片算法（上）
- 3-7 常用分片算法（下）
- 3-8 schema.xml文件用途
- 3-9 schema定义逻辑库
- 3-10 table标签
- 3-11 dataNode标签
- 3-12 dataHost标签
- 3-13 dataHost标签属性
- 3-14 heartbeat标签
- 3-15 writehost标签
- 3-16 schema总结
3-1 章节综述
1、详解Mycat主要配置文件的标签和属性
2、实战通过Mycat实现数据库的分库分表及分片配置
3-2 常用配置文件间的关系
1、Mycat配置文件概述；
- server.xml#配置系统相关参数；
- schema.xml
- rule.xml
- log4j2.xml
3-3 server.xml配置详解
1、server.xml详解；
- 配置系统相关参数；
- 配置用户访问权限
- 配置SQL防火墙及SQL拦截功能
<?xml version="1.0" encoding="UTF-8"?>
<!-- - - Licensed under the Apache License, Version 2.0 (the "License");
- you may not use this file except in compliance with the License. - You
may obtain a copy of the License at - - http://www.apache.org/licenses/LICENSE-2.0
- - Unless required by applicable law or agreed to in writing, software -
distributed under the License is distributed on an "AS IS" BASIS, - WITHOUT
WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. - See the
License for the specific language governing permissions and - limitations
under the License. -->
<!DOCTYPE mycat:server SYSTEM "server.dtd">
<mycat:server xmlns:mycat="http://io.mycat/">
<system>
<property name="nonePasswordLogin">0</property> <!-- 0为需要密码登陆、1为不需要密码登陆 ,默认为0，设置为1则需要指定默认账户-->
<property name="useHandshakeV10">1</property>
<property name="useSqlStat">0</property> <!-- 1为开启实时统计、0为关闭 -->
<property name="useGlobleTableCheck">0</property> <!-- 1为开启全加班一致性检测、0为关闭 --> <property name="sequnceHandlerType">2</property>
<property name="subqueryRelationshipCheck">false</property> <!-- 子查询中存在关联查询的情况下,检查关联字段中是否有分片字段 .默认 false -->
<!-- <property name="useCompression">1</property>--> <!--1为开启mysql压缩协议-->
<!-- <property name="fakeMySQLVersion">5.6.20</property>--> <!--设置模拟的MySQL版本号-->
<!-- <property name="processorBufferChunk">40960</property> -->
<!--
<property name="processors">1</property>
<property name="processorExecutor">32</property>
-->
<!--默认为type 0: DirectByteBufferPool | type 1 ByteBufferArena | type 2 NettyBufferPool -->
<property name="processorBufferPoolType">0</property>
<!--默认是65535 64K 用于sql解析时最大文本长度 -->
<!--<property name="maxStringLiteralLength">65535</property>-->
<!--<property name="sequnceHandlerType">0</property>-->
<!--<property name="backSocketNoDelay">1</property>-->
<!--<property name="frontSocketNoDelay">1</property>-->
<!--<property name="processorExecutor">16</property>-->
<!--
<property name="serverPort">8066</property> <property name="managerPort">9066</property>
<property name="idleTimeout">300000</property> <property name="bindIp">0.0.0.0</property>
<property name="frontWriteQueueSize">4096</property> <property name="processors">32</property> -->
<!--分布式事务开关，0为不过滤分布式事务，1为过滤分布式事务（如果分布式事务内只涉及全局表，则不过滤），2为不过滤分布式事务,但是记录分布式事务日志-->
<property name="handleDistributedTransactions">0</property> <!--
off heap for merge/order/group/limit 1开启 0关闭
-->
<property name="useOffHeapForMerge">1</property> <!--
单位为m
-->
<property name="memoryPageSize">64k</property> <!--
单位为k
-->
<property name="spillsFileBufferSize">1k</property> <property name="useStreamOutput">0</property> <!--
单位为m
-->
<property name="systemReserveMemorySize">384m</property> <!--是否采用zookeeper协调切换 -->
<property name="useZKSwitch">false</property> <!-- XA Recovery Log日志路径 -->
<!--<property name="XARecoveryLogBaseDir">./</property>--> <!-- XA Recovery Log日志名称 -->
<!--<property name="XARecoveryLogBaseName">tmlog</property>--> </system> <!-- 全局SQL防火墙设置 -->
<!--白名单可以使用通配符%或着*-->
<!--例如<host host="127.0.0.*" user="root"/>-->
<!--例如<host host="127.0.*" user="root"/>-->
<!--例如<host host="127.*" user="root"/>-->
<!--例如<host host="1*7.*" user="root"/>-->
<!--这些配置情况下对于127.0.0.1都能以root账户登录-->
<!--
<firewall>
<whitehost>
<host host="1*7.0.0.*" user="root"/>
</whitehost>
<blacklist check="false">
</blacklist>
</firewall>
--> <user name="root" defaultAccount="true">
<property name="password">123456</property>
<property name="schemas">TESTDB</property> <!-- 表级 DML 权限设置 -->
<!--
<privileges check="false">
<schema name="TESTDB" dml="0110" >
<table name="tb01" dml="0000"></table>
<table name="tb02" dml="1111"></table>
</schema>
</privileges>
-->
</user> <user name="user">
<property name="password">user</property>
<property name="schemas">TESTDB</property>
<property name="readOnly">true</property>
</user> </mycat:server>
server.xml
3-4 log4j2.xml配置文件
1、log4j2.xml文件用途；
- 配置输出日志的格式
- 配置输出日志的级别
<?xml version="1.0" encoding="UTF-8"?>
<Configuration status="WARN">
<Appenders>
<Console name="Console" target="SYSTEM_OUT">
<PatternLayout pattern="%d [%-5p][%t] %m %throwable{full} (%C:%F:%L) %n"/>
</Console> <RollingFile name="RollingFile" fileName="${sys:MYCAT_HOME}/logs/mycat.log"
filePattern="${sys:MYCAT_HOME}/logs/$${date:yyyy-MM}/mycat-%d{MM-dd}-%i.log.gz">
<PatternLayout>
<Pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} %5p [%t] (%l) - %m%n</Pattern>
</PatternLayout>
<Policies>
<OnStartupTriggeringPolicy/>
<SizeBasedTriggeringPolicy size="250 MB"/>
<TimeBasedTriggeringPolicy/>
</Policies>
</RollingFile>
</Appenders>
<Loggers>
<!--<AsyncLogger name="io.mycat" level="info" includeLocation="true" additivity="false">-->
<!--<AppenderRef ref="Console"/>-->
<!--<AppenderRef ref="RollingFile"/>-->
<!--</AsyncLogger>-->
<asyncRoot level="info" includeLocation="true"> <!--<AppenderRef ref="Console" />-->
<AppenderRef ref="RollingFile"/> </asyncRoot>
</Loggers>
</Configuration>
log4j2.xml
3-5 rule.xml
1、rule.xml详解；
3-6 常用分片算法（上）
1、分片算法初识；
- 简单取模-PartitionByMod(只能用于列为整数的表的情况)
- 哈希取模-PartitionByHashMod
3-7 常用分片算法（下）
1、分片算法初识2；
- 枚举分片-PartitonByFileMap
- 字符串范围取模分片算法-PartitionByPrefixPattern
配置文件位于：$Mycat/conf/prefix-partition-pattern.txt文件名；
小结：
使用场景中，最常见的还是简单取模-PartitionByMod(只能用于列为整数的表的情况)，好比LVS中负载均衡算法中，轮询算法；
3-8 schema.xml文件用途
1、最关键的配置文件schema.xml；
- 配置逻辑库及逻辑表
- 配置逻辑表所存储的数据节点
- 配置数据节点对应的物理数据库服务器信息
3-9 schema定义逻辑库
1、schema.xml中逻辑库配置；
<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/"> <schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100">
<!-- auto sharding by id (long) -->
<table name="travelrecord" dataNode="dn1,dn2,dn3" rule="auto-sharding-long" /> <!-- 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="company" primaryKey="ID" type="global" dataNode="dn1,dn2,dn3" />
<table name="goods" primaryKey="ID" type="global" dataNode="dn1,dn2" />
<!-- random sharding using mod sharind rule -->
<table name="hotnews" primaryKey="ID" autoIncrement="true" dataNode="dn1,dn2,dn3"
rule="mod-long" />
<!-- <table name="dual" primaryKey="ID" dataNode="dnx,dnoracle2" type="global"
needAddLimit="false"/> <table name="worker" primaryKey="ID" dataNode="jdbc_dn1,jdbc_dn2,jdbc_dn3"
rule="mod-long" /> -->
<table name="employee" primaryKey="ID" dataNode="dn1,dn2"
rule="sharding-by-intfile" />
<table name="customer" primaryKey="ID" dataNode="dn1,dn2"
rule="sharding-by-intfile">
<childTable name="orders" primaryKey="ID" joinKey="customer_id"
parentKey="id">
<childTable name="order_items" joinKey="order_id"
parentKey="id" />
</childTable>
<childTable name="customer_addr" primaryKey="ID" joinKey="customer_id"
parentKey="id" />
</table>
<!-- <table name="oc_call" primaryKey="ID" dataNode="dn1$0-743" rule="latest-month-calldate"
/> -->
</schema>
<!-- <dataNode name="dn1$0-743" dataHost="localhost1" database="db$0-743"
/> -->
<dataNode name="dn1" dataHost="localhost1" database="db1" />
<dataNode name="dn2" dataHost="localhost1" database="db2" />
<dataNode name="dn3" dataHost="localhost1" database="db3" />
<!--<dataNode name="dn4" dataHost="sequoiadb1" database="SAMPLE" />
<dataNode name="jdbc_dn1" dataHost="jdbchost" database="db1" />
<dataNode name="jdbc_dn2" dataHost="jdbchost" database="db2" />
<dataNode name="jdbc_dn3" dataHost="jdbchost" database="db3" /> -->
<dataHost name="localhost1" maxCon="1000" minCon="10" balance="0"
writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
<heartbeat>select user()</heartbeat>
<!-- can have multi write hosts -->
<writeHost host="hostM1" url="localhost:3306" user="root"
password="123456">
<!-- can have multi read hosts -->
<readHost host="hostS2" url="192.168.1.200:3306" user="root" password="xxx" />
</writeHost>
<writeHost host="hostS1" url="localhost:3316" user="root"
password="123456" />
<!-- <writeHost host="hostM2" url="localhost:3316" user="root" password="123456"/> -->
</dataHost>
<!--
<dataHost name="sequoiadb1" maxCon="1000" minCon="1" balance="0" dbType="sequoiadb" dbDriver="jdbc">
<heartbeat> </heartbeat>
<writeHost host="hostM1" url="sequoiadb://1426587161.dbaas.sequoialab.net:11920/SAMPLE" user="jifeng" password="jifeng"></writeHost>
</dataHost> <dataHost name="oracle1" maxCon="1000" minCon="1" balance="0" writeType="0" dbType="oracle" dbDriver="jdbc"> <heartbeat>select 1 from dual</heartbeat>
<connectionInitSql>alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss'</connectionInitSql>
<writeHost host="hostM1" url="jdbc:oracle:thin:@127.0.0.1:1521:nange" user="base" password="123456" > </writeHost> </dataHost> <dataHost name="jdbchost" maxCon="1000" minCon="1" balance="0" writeType="0" dbType="mongodb" dbDriver="jdbc">
<heartbeat>select user()</heartbeat>
<writeHost host="hostM" url="mongodb://192.168.0.99/test" user="admin" password="123456" ></writeHost> </dataHost> <dataHost name="sparksql" maxCon="1000" minCon="1" balance="0" dbType="spark" dbDriver="jdbc">
<heartbeat> </heartbeat>
<writeHost host="hostM1" url="jdbc:hive2://feng01:10000" user="jifeng" password="jifeng"></writeHost> </dataHost> --> <!-- <dataHost name="jdbchost" maxCon="1000" minCon="10" balance="0" dbType="mysql"
dbDriver="jdbc"> <heartbeat>select user()</heartbeat> <writeHost host="hostM1"
url="jdbc:mysql://localhost:3306" user="root" password="123456"> </writeHost>
</dataHost> -->
</mycat:schema>
schema.xml
<?xml version="1.0" encoding="UTF-8"?>
<!-- - - Licensed under the Apache License, Version 2.0 (the "License");
- you may not use this file except in compliance with the License. - You
may obtain a copy of the License at - - http://www.apache.org/licenses/LICENSE-2.0
- - Unless required by applicable law or agreed to in writing, software -
distributed under the License is distributed on an "AS IS" BASIS, - WITHOUT
WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. - See the
License for the specific language governing permissions and - limitations
under the License. -->
<!DOCTYPE mycat:server SYSTEM "server.dtd">
<mycat:server xmlns:mycat="http://io.mycat/">
<system>
<property name="nonePasswordLogin">0</property> <!-- 0为需要密码登陆、1为不需要密码登陆 ,默认为0，设置为1则需要指定默认账户-->
<property name="useHandshakeV10">1</property>
<property name="useSqlStat">0</property> <!-- 1为开启实时统计、0为关闭 -->
<property name="useGlobleTableCheck">0</property> <!-- 1为开启全加班一致性检测、0为关闭 --> <property name="sequnceHandlerType">2</property>
<property name="subqueryRelationshipCheck">false</property> <!-- 子查询中存在关联查询的情况下,检查关联字段中是否有分片字段 .默认 false -->
<!-- <property name="useCompression">1</property>--> <!--1为开启mysql压缩协议-->
<!-- <property name="fakeMySQLVersion">5.6.20</property>--> <!--设置模拟的MySQL版本号-->
<!-- <property name="processorBufferChunk">40960</property> -->
<!--
<property name="processors">1</property>
<property name="processorExecutor">32</property>
-->
<!--默认为type 0: DirectByteBufferPool | type 1 ByteBufferArena | type 2 NettyBufferPool -->
<property name="processorBufferPoolType">0</property>
<!--默认是65535 64K 用于sql解析时最大文本长度 -->
<!--<property name="maxStringLiteralLength">65535</property>-->
<!--<property name="sequnceHandlerType">0</property>-->
<!--<property name="backSocketNoDelay">1</property>-->
<!--<property name="frontSocketNoDelay">1</property>-->
<!--<property name="processorExecutor">16</property>-->
<!--
<property name="serverPort">8066</property> <property name="managerPort">9066</property>
<property name="idleTimeout">300000</property> <property name="bindIp">0.0.0.0</property>
<property name="frontWriteQueueSize">4096</property> <property name="processors">32</property> -->
<!--分布式事务开关，0为不过滤分布式事务，1为过滤分布式事务（如果分布式事务内只涉及全局表，则不过滤），2为不过滤分布式事务,但是记录分布式事务日志-->
<property name="handleDistributedTransactions">0</property> <!--
off heap for merge/order/group/limit 1开启 0关闭
-->
<property name="useOffHeapForMerge">1</property> <!--
单位为m
-->
<property name="memoryPageSize">64k</property> <!--
单位为k
-->
<property name="spillsFileBufferSize">1k</property> <property name="useStreamOutput">0</property> <!--
单位为m
-->
<property name="systemReserveMemorySize">384m</property> <!--是否采用zookeeper协调切换 -->
<property name="useZKSwitch">false</property> <!-- XA Recovery Log日志路径 -->
<!--<property name="XARecoveryLogBaseDir">./</property>--> <!-- XA Recovery Log日志名称 -->
<!--<property name="XARecoveryLogBaseName">tmlog</property>--> </system> <!-- 全局SQL防火墙设置 -->
<!--白名单可以使用通配符%或着*-->
<!--例如<host host="127.0.0.*" user="root"/>-->
<!--例如<host host="127.0.*" user="root"/>-->
<!--例如<host host="127.*" user="root"/>-->
<!--例如<host host="1*7.*" user="root"/>-->
<!--这些配置情况下对于127.0.0.1都能以root账户登录-->
<!--
<firewall>
<whitehost>
<host host="1*7.0.0.*" user="root"/>
</whitehost>
<blacklist check="false">
</blacklist>
</firewall>
--> <user name="root" defaultAccount="true">
<property name="password">123456</property>
<property name="schemas">TESTDB</property> <!-- 表级 DML 权限设置 -->
<!--
<privileges check="false">
<schema name="TESTDB" dml="0110" >
<table name="tb01" dml="0000"></table>
<table name="tb02" dml="1111"></table>
</schema>
</privileges>
-->
</user> <user name="user">
<property name="password">user</property>
<property name="schemas">TESTDB</property>
<property name="readOnly">true</property>
</user> </mycat:server>
server.xml
小结：
- 一个schema标签中，可以支持存在多个逻辑库；
3-10 table标签
1、schema中table标签；
- mycat中逻辑表的表名唯一且与后端数据库的表名相一致！
- 逻辑表的主键一般与后端真实的主键相一致；
- 逻辑库与逻辑表类似于数据库中的‘视图’概念，不存贮真实的数据；
3-11 dataNode标签
1、schema.xml下dataNode标签；
3-12 dataHost标签
1、schema.xml下dataHost标签；
3-13 dataHost标签属性
1、schema.xml中dataHost定义后端数据库主机信息；
- balance
3-14 heartbeat标签
1、schema.xml中hearbeat；
- 通过简单的查询语句，判断数据库服务是否可用；
- 数据库可连接，但不一定可用，select user()可用来判断是否可用；
3-15 writehost标签
1、schema.xml中writehost；
3-16 schema总结
1、小结；
<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/"> <!--001xxx项目_所需数据表配置_xxxx环境-->
<schema name="ec_pre_schemas" checkSQLschema="false" >
<table name="bd_auditing" primaryKey="PK_AUDITING_ID" type="global" dataNode="pre_node" />
<table name="bd_auditing_detail" primaryKey="PK_AUDITING_DETAIL_ID" type="global" dataNode="pre_node" />
<table name="bd_auditor" primaryKey="PK_AUDITOR_ID" type="global" dataNode="pre_node" />
<table name="bd_authority" primaryKey="PK_AUTH_ID" type="global" dataNode="pre_node" />
<table name="bd_balance_detail" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_balance_detail_budget" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_balance_rule" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_balance_rule_budget" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_balance_user" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_balance_user_budget" primaryKey="ID" type="global" dataNode="pre_node" />
<!--2017-09-26 新增bd_base_report表 -->
<table name="bd_base_report" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<!--2017-11-17 新增bd_butler_product-->
<table name="bd_butler_product" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_case" primaryKey="PK_ID" type="PK_CASE_ID" dataNode="pre_node" />
<table name="bd_case_allot" primaryKey="PK_ALLOT_ID" dataNode="pre_node" />
<table name="bd_case_balance" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_case_balance_budget" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_case_file" primaryKey="PK_ACASE_FILE_ID" type="global" dataNode="pre_node" />
<table name="bd_case_flow" primaryKey="id" type="global" dataNode="pre_node" />
<table name="bd_case_official_code_config" primaryKey="pk_id" type="global" dataNode="pre_node" />
<!--2017-12-21 新增bd_case_official表-->
<table name="bd_case_official" primaryKey="PK_CASE_OFFICIAL_ID" type="global" dataNode="pre_node" />
<table name="bd_case_operation" primaryKey="PK_CASE_ORERA_ID" type="global" dataNode="pre_node" />
<!--2017-10-31 新增bd_case_property_configuration表-->
<table name="bd_case_property_configuration" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_channel" primaryKey="V_ID" type="global" dataNode="pre_node" />
<table name="bd_contact" primaryKey="PK_CONTACT_ID" type="global" dataNode="pre_node" />
<table name="bd_contract" primaryKey="PK_CONTRACT_ID" type="global" dataNode="pre_node" />
<table name="bd_contract_file" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_contract_operation" primaryKey="PK_CONTRACT_ORERA_ID" type="global" dataNode="pre_node" />
<table name="bd_contract_product" primaryKey="PK_CONTRACT_PRODUCT_ID" type="global" dataNode="pre_node" />
<table name="bd_contract_product_payment" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_contract_ratio" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_cooperation_drools" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_cooperation_drools_config" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_corp_info" primaryKey="PK_CORP_ID" type="global" dataNode="pre_node" />
<table name="bd_corp_system_info" primaryKey="PK_SYSTEM_ID" type="global" dataNode="pre_node" />
<table name="bd_custom_workbench" primaryKey="PK_CUSTOM_WORKBENCH_ID" type="global" dataNode="pre_node" />
<table name="bd_customer" primaryKey="PK_CUSTOMER_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_address" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_customer_body" primaryKey="PK_CUSTOMER_BODY_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_body_file" primaryKey="PK_CUSTOMER_BODY_FILE_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_file" primaryKey="PK_FILE_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_operation" primaryKey="PK_ORERA_ID" type="global" dataNode="pre_node" />
<table name="bd_dealing_people" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_department_info" primaryKey="PK_DEPARTMENT_ID" type="global" dataNode="pre_node" />
<!--2017-11-24 新增bd_diarly_type表 -->
<table name="bd_diarly_type" primaryKey="PK_DIARLY_TYPE_ID" type="PK_FLOW_ID" dataNode="pre_node" />
<table name="bd_districtvalues" primaryKey="PK_DISTRICT_ID" type="global" dataNode="pre_node" />
<!--2017-10-18 新增bd_fee、bd_fee_business表 -->
<table name="bd_fee" primaryKey="PK_FEE_ID" type="PK_FLOW_ID" dataNode="pre_node" />
<table name="bd_fee_business" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_flow" primaryKey="ID" type="PK_FLOW_ID" dataNode="pre_node" />
<table name="bd_group_user" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_industry" primaryKey="PK_INDUSTRT_ID" type="global" dataNode="pre_node" />
<table name="bd_invoice" primaryKey="PK_INVOICE_ID" type="global" dataNode="pre_node" />
<table name="bd_invoice_body" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_invoice_title" primaryKey="PD_INVOICE_TITLE_ID" type="global" dataNode="pre_node" />
<table name="bd_invoice_title_body" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_invoicetitle" primaryKey="PK_INVOICETITLE_ID" type="global" dataNode="pre_node" />
<table name="bd_issued_audit" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_issued_file" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_joint_applicant" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_knowledge" primaryKey="PK_KNOWLEDGE_ID" type="global" dataNode="pre_node" />
<table name="bd_knowledge_category" primaryKey="Id" type="global" dataNode="pre_node" />
<table name="bd_knowledge_file" primaryKey="PK_FILE_ID" type="global" dataNode="pre_node" />
<table name="bd_knowledge_link" primaryKey="Id" type="global" dataNode="pre_node" />
<table name="bd_knowledge_manage" primaryKey="Id" type="global" dataNode="pre_node" />
<table name="bd_knowledge_type" primaryKey="PK_KNOWLEDGE_TYPE_ID" type="global" dataNode="pre_node" />
<table name="bd_label" primaryKey="PK_LABEL_ID" type="global" dataNode="pre_node" />
<table name="bd_label_customer" primaryKey="PK_LABEL_CUSTOMER_ID" type="global" dataNode="pre_node" />
<table name="bd_label_type" primaryKey="PK_LABEL_TYPE_ID" type="global" dataNode="pre_node" />
<table name="bd_log_info" primaryKey="ID" type="global" dataNode="pre_node" />
<!--2017-11-07 新增bd_match表 -->
<table name="bd_match" primaryKey="PK_MATCH_ID" type="PK_FLOW_ID" dataNode="pre_node" />
<table name="bd_message" primaryKey="PK_MESSAGE_ID" type="global" dataNode="pre_node" />
<table name="bd_message_text" primaryKey="PK_TEXT_ID" type="global" dataNode="pre_node" />
<table name="bd_message_text_file" primaryKey="PK_MESSAGE_TEXT_FILE_ID" type="global" dataNode="pre_node" />
<table name="bd_niceclassification" primaryKey="PK_NiceClassification_ID" type="global" dataNode="pre_node" />
<table name="bd_niceclassification_copy" primaryKey="PK_NiceClassification_ID" type="global" dataNode="pre_node" />
<table name="bd_offical_result_remind" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_order_auditor" primaryKey="PK_AUDITOR_ID" type="global" dataNode="pre_node" />
<table name="bd_order_balance" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_order_balance_budget" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_order_body" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_order_info" primaryKey="PK_ORDER_ID" type="global" dataNode="pre_node" />
<table name="bd_order_operation" primaryKey="PK_ORDER_ORERA_ID" type="global" dataNode="pre_node" />
<table name="bd_order_price_value" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_order_property_value" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_partner_drools" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_pay" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_pay_contract" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_payment" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_payment_contract" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_potential" primaryKey="V_CUSTOMER_ID" type="global" dataNode="pre_node" />
<table name="bd_price" primaryKey="PK_PRICE_ID" type="global" dataNode="pre_node" />
<table name="bd_price_value" primaryKey="ID" type="global" dataNode="pre_node" />
<!--2017-12-21 新增bd_process_remind_config表 -->
<table name="bd_process_remind_config" primaryKey="PK_PROCESS_REMIND_CONFIG_ID" type="global" dataNode="pre_node" />
<table name="bd_product" primaryKey="PK_PRODUCT_ID" type="global" dataNode="pre_node" />
<table name="bd_product_property" primaryKey="PK_PROPERTY_ID" type="global" dataNode="pre_node" />
<table name="bd_product_property_value" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_product_type" primaryKey="PK_PRODUCT_TYPE_ID" type="global" dataNode="pre_node" />
<table name="bd_progressive_sales" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_progressive_sales_config" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_project" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_receiptaddress" primaryKey="PK_RECEIPTADDRESS_ID" type="global" dataNode="pre_node" />
<!--2017-09-26 新增bd_reminder表-->
<table name="bd_reminder" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<!--2017-12-21 新增bd_remind_label_config表-->
<table name="bd_remind_label_config" primaryKey="PK_REMIND_LABEL_CONFIG_ID" type="global" dataNode="pre_node" />
<table name="bd_replenishment" primaryKey="PK_REPLENISHMENT_ID" type="global" dataNode="pre_node" />
<table name="bd_replenishment_detail" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_replenishment_operation" primaryKey="PK_REPLENISHMENT_ORERA_ID" type="global" dataNode="pre_node" />
<table name="bd_returnvisit" primaryKey="PK_RETURNVISIT_ID" type="global" dataNode="pre_node" />
<table name="bd_returnvisit_file" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_returnvisit_order" primaryKey="PK_OD" type="global" dataNode="pre_node" />
<table name="bd_role" primaryKey="role_id" type="global" dataNode="pre_node" />
<table name="bd_role_authority" primaryKey="pk_role_auth_id" type="global" dataNode="pre_node" />
<table name="bd_share" primaryKey="PK_SHARE_ID" type="global" dataNode="pre_node" />
<table name="bd_system_info" primaryKey="PK_SYSTEM_ID" type="global" dataNode="pre_node" />
<table name="bd_system_info_copy" primaryKey="PK_SYSTEM_ID" type="global" dataNode="pre_node" />
<table name="bd_user" primaryKey="userId" type="global" dataNode="pre_node" />
<table name="bd_user_authdata" primaryKey="PK_USER_AUTHDATA_ID" type="global" dataNode="pre_node" />
<table name="bd_user_info" primaryKey="PK_USER_ID" dataNode="pre_node" />
<table name="bd_user_progressive_sale_to_june" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_user_role" primaryKey="pk_user_role_id" type="global" dataNode="pre_node" />
<table name="bd_visit" primaryKey="PK_VISIT_ID" type="global" dataNode="pre_node" />
<!--2017-11-06 新增bd_work_diary表 -->
<table name="bd_work_diary" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<!--2017-11-07新增bd_work_diary_detail表 -->
<table name="bd_work_diary_detail" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_work_order" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_work_order_file" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_work_order_flow" primaryKey="PK_SHARE_ID" type="global" dataNode="pre_node" />
<table name="bd_work_order_group" primaryKey="PK_USER_ID" type="global" dataNode="pre_node" />
<table name="bd_work_order_operation" primaryKey="PK_ORDER_ORERA_ID" type="global" dataNode="pre_node" />
<table name="bd_work_order_resource" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_work_order_result" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="ini_dic" primaryKey="PK_DIC_ID" type="global" dataNode="pre_node" />
<table name="ini_dic_detail" primaryKey="PK_DIC_DETAIL_ID" type="global" dataNode="pre_node" />
<table name="rel_case_order" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="rel_channel_api" primaryKey="V_PK_ID" type="global" dataNode="pre_node" />
<table name="rel_channel_product" primaryKey="V_PK_ID" type="global" dataNode="pre_node" />
<table name="rel_contract_order" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="rel_corp_progressive_sales" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="rel_corp_user" primaryKey="pk_id" type="global" dataNode="pre_node" />
<table name="rel_group_customer" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="rel_invoice_order" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="rel_knowledge_point" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<!--2017-12-21新增bd_official_doc表 -->
<table name="bd_official_doc" primaryKey="PK_OFFICIAL_DOC_ID" type="global" dataNode="pre_node" />
<!--2017-12-21新增rel_official_process_config表 -->
<table name="rel_official_process_config" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="rel_order_property_price" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="rel_order_property_price_copy" primaryKey="PK_LABEL_ID" type="global" dataNode="pre_node" />
<table name="rel_order_relation" primaryKey="PK_RELATION_ID" type="global" dataNode="pre_node" />
<table name="rel_price_product" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="rel_price_property" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="rel_product_property" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="rel_product_userstar_royalty" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="rel_projectorder" primaryKey="ID" type="global" dataNode="pre_node" />
<!--2017-11-15新增rel_relate_review表 -->
<table name="rel_relate_review" primaryKey="pk_relate_review_id" type="global" dataNode="pre_node" />
<!--2017-12-06新增rel_user_duty表 -->
<table name="rel_user_duty" primaryKey="PK_DUTY_ID" type="global" dataNode="pre_node" />
<table name="rel_work_order_group" primaryKey="PK_USER_ID" type="global" dataNode="pre_node" />
<table name="rel_workorder" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="st_sale_census" primaryKey="pk_id" type="global" dataNode="pre_node" />
<table name="sys_message" primaryKey="PK_SYS_MESSAGE_ID" type="global" dataNode="pre_node" />
<table name="sys_property" primaryKey="PK_PROPERTY_ID" type="global" dataNode="pre_node" />
<table name="sys_property_area" primaryKey="PK_PROPERTY_AREA_ID" type="global" dataNode="pre_node" />
<table name="sys_property_value" primaryKey="PK_PROPERTY_VALUE_ID" type="global" dataNode="pre_node" />
<table name="vi_balance_case" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="vi_balance_case_thismonth" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="vi_balance_order" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="vi_balance_order_thismonth" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_account_bm" primaryKey="pk_account_id" type="global" dataNode="pre_node" />
<table name="bd_customer_bm" primaryKey="PK_CUSTOMER_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_body_bm" primaryKey="PK_CUSTOMER_BODY_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_body_file_bm" primaryKey="PK_CUSTOMER_BODY_FILE_ID" type="global" dataNode="pre_node" />
<table name="bd_order_info_bg" primaryKey="PK_ORDER_ID" type="global" dataNode="pre_node" />
<table name="bd_order_body_bg" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_order_property_value_bg" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_password_bm" primaryKey="pk_password_id" type="global" dataNode="pre_node" />
<table name="bd_user_info_bg" primaryKey="PK_USER_ID" type="global" dataNode="pre_node" />
<!--2018/01/22 -->
<table name="bd_customer_h" primaryKey="PK_CUSTOMER_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_rating" primaryKey="PK_CUSTOMER_RATING_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_d" primaryKey="PK_ADVANCED_PROPERTIES" type="global" dataNode="pre_node" />
<table name="bd_customer_attachment_summary" primaryKey="PK_ATTACHMENT_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_communication_file" primaryKey="PK_COMMUNICATION_FILE_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_communication" primaryKey="PK_CUSTOMER_COMMUNICATION" type="global" dataNode="pre_node" />
<table name="bd_customer_property_value" primaryKey="PK_PROPERTY_VALUE_ID" type="global" dataNode="pre_node" />
<table name="BD_CUSTOMER_STATISTICS" primaryKey="PK_CUSTOMER_STATISTICS_ID" type="global" dataNode="pre_node" />
<table name="bd_remind" primaryKey="PK_REMIND_ID" type="global" dataNode="pre_node" />
<table name="bd_remind_modal" primaryKey="PK_REMIND_MODAL_ID" type="global" dataNode="pre_node" />
<!--2018/01/29 -->
<table name="bd_customer_valuation" primaryKey="PK_CUSTOMER_VALUATION_ID" type="global" dataNode="pre_node" />
<!--2018/03/07 -->
<table name="bd_case_process_info" primaryKey="PK_CASE_PROCESS_INFO_ID" type="global" dataNode="pre_node" />
<table name="bd_relevant_people" primaryKey="PK_RELEVANT_PEOPLE_ID" type="global" dataNode="pre_node" />
<!--2018/03/14 -->
<table name="bd_idn" primaryKey="PK_IDN_ID" type="global" dataNode="pre_node" />
<!--2018/03/16 -->
<table name="bd_districtvalues_cpc" primaryKey="PK_DISTRICT_ID" type="global" dataNode="pre_node" />
<!--2018/03/23 -->
<table name="bd_customer_dn" primaryKey="PK_NEW_ATTRIBUTES_ID" type="global" dataNode="pre_node" />
<table name="bd_process_bio" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<!--2018/04/04-->
<table name="bd_document_list" primaryKey="PK_DOCUMENT_ID" type="global" dataNode="pre_node" />
<table name="bd_document_property" primaryKey="PK_PROPERTY_ID" type="global" dataNode="pre_node" />
<table name="bd_document_property_value" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="rel_document_property" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_case_doc_property_value" primaryKey="ID" type="global" dataNode="pre_node" />
<!--2018/04/18 -->
<table name="bd_question_naire" primaryKey="PK_QUESTION_NAIRE_ID" type="global" dataNode="pre_node" />
<!--2018/04/28 -->
<table name="bd_archive_file" primaryKey="PK_ARCHIVE_FILE_ID" type="global" dataNode="pre_node" />
<table name="bd_case_official_status_config" primaryKey="PK_CASE_OFFICIAL_STATUS_CONFIG_ID" type="global" dataNode="pre_node" />
<table name="bd_staff_contact" primaryKey="PK_STAFF_CONTACT_ID" type="global" dataNode="pre_node" />
<table name="bd_staff_notice" primaryKey="PK_STAFF_NOTICE_ID" type="global" dataNode="pre_node" />
<table name="bd_staff_operation" primaryKey="PK_ORERA_ID" type="global" dataNode="pre_node" />
<table name="bd_staff_records" primaryKey="PK_STAFF_ID" type="global" dataNode="pre_node" />
<table name="bd_training_record" primaryKey="PK_TRAINING_RECORD_ID" type="global" dataNode="pre_node" />
<table name="rel_staff_training_record" primaryKey="PK_STAFF_TRAINING_RECORD_ID" type="global" dataNode="pre_node" />
<table name="bd_approval_process" primaryKey="PK_APPROVAL_PROCESS_ID" type="global" dataNode="pre_node" />
</schema>
<!--002xxx项目_所需数据表配置_xxxx环境-->
<schema name="bingo_pre_schemas" checkSQLschema="false" >
<table name="applicants" primaryKey="id" type="global" dataNode="pre_node" />
<table name="bd_account_bm" primaryKey="pk_account_id" type="global" dataNode="pre_node" />
<table name="bd_account_copy" primaryKey="pk_account_id" type="global" dataNode="pre_node" />
<table name="bd_account_login_bm" primaryKey="PK_ACCOUNT_LOGIN" type="global" dataNode="pre_node" />
<table name="bd_activity_bg" primaryKey="PK_ACTIVITY_ID" type="global" dataNode="pre_node" />
<table name="bd_appraise_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_auditing_bg" primaryKey="PK_AUDITING_ID" type="global" dataNode="pre_node" />
<table name="bd_auditing_detail_bg" primaryKey="PK_AUDITING_DETAIL_ID" type="global" dataNode="pre_node" />
<table name="bd_auditor_bg" primaryKey="PK_AUDITOR_ID" type="global" dataNode="pre_node" />
<table name="bd_authority_bg" primaryKey="PK_AUTH_ID" type="global" dataNode="pre_node" />
<table name="bd_carousel_figure_bg" primaryKey="PK_CAROUSEL_FIGURE_ID" type="global" dataNode="pre_node" />
<table name="bd_contact_bg" primaryKey="PK_CONTACT_ID" type="global" dataNode="pre_node" />
<table name="bd_corp_info_bg" primaryKey="PK_CORP_ID" type="global" dataNode="pre_node" />
<table name="bd_coupon_bg" primaryKey="PK_COUPON_ID" type="global" dataNode="pre_node" />
<table name="bd_coupon_template_bg" primaryKey="PK_COUPON_TEMPLATE_ID" type="global" dataNode="pre_node" />
<table name="bd_coupon_template_value_bg" primaryKey="PK_COUPON_TEMPLATE_VALUE_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_bm" primaryKey="PK_CUSTOMER_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_body_bm" primaryKey="PK_CUSTOMER_BODY_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_body_file_bm" primaryKey="PK_CUSTOMER_BODY_FILE_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_operation_bm" primaryKey="PK_ORERA_ID" type="global" dataNode="pre_node" />
<table name="bd_dealing_people_bg" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_department_info_bg" primaryKey="PK_DEPARTMENT_ID" type="global" dataNode="pre_node" />
<table name="bd_districtvalues_bg" primaryKey="PK_DISTRICT_ID" type="global" dataNode="pre_node" />
<table name="bd_exclusive_bm" primaryKey="PK_EXCLUSIVE_ID" type="global" dataNode="pre_node" />
<table name="bd_exclusive_member_bm" primaryKey="PK_MEMBER_ID" type="global" dataNode="pre_node" />
<table name="bd_field_bg" primaryKey="PK_FIELD_ID" type="global" dataNode="pre_node" />
<table name="bd_field_value_bg" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_industry_bg" primaryKey="PK_INDUSTRT_ID" type="global" dataNode="pre_node" />
<table name="bd_info_bg" primaryKey="PK_INFO_ID" type="global" dataNode="pre_node" />
<table name="bd_info_operation_bg" primaryKey="PK_ORERA_ID" type="global" dataNode="pre_node" />
<table name="bd_invoice_bg" primaryKey="PK_INVOICE_ID" type="global" dataNode="pre_node" />
<table name="bd_invoice_body_bg" primaryKey="PK_INVOICE_BODY_ID" type="global" dataNode="pre_node" />
<table name="bd_invoice_body2" primaryKey="PK_INVOICE_BODY_ID" type="global" dataNode="pre_node" />
<table name="bd_invoice_body3" primaryKey="PK_INVOICE_BODY_ID" type="global" dataNode="pre_node" />
<table name="bd_invoice2" primaryKey="PK_INVOICE_ID" type="global" dataNode="pre_node" />
<table name="bd_invoice3" primaryKey="PK_INVOICE_ID" type="global" dataNode="pre_node" />
<table name="bd_ipc_class_bg" primaryKey="PK_IPC_CLASS_ID" type="global" dataNode="pre_node" />
<table name="bd_ipdata_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_log_info_bm" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_log_module_bm" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_message_module_bm" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_niceclassification_bg" primaryKey="PK_NiceClassification_ID" type="global" dataNode="pre_node" />
<table name="bd_order_body_bg" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_order_info_bg" primaryKey="PK_ORDER_ID" type="global" dataNode="pre_node" />
<table name="bd_order_info_copy" primaryKey="PK_ORDER_ID" type="global" dataNode="pre_node" />
<table name="bd_order_operation_bg" primaryKey="PK_ORDER_ORERA_ID" type="global" dataNode="pre_node" />
<table name="bd_order_property_value_bg" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_order_property_value_copy" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_password_bm" primaryKey="pk_password_id" type="global" dataNode="pre_node" />
<table name="bd_password_copy" primaryKey="pk_password_id" type="global" dataNode="pre_node" />
<table name="bd_process_bm" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_process_item_bm" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_process_item_value_bm" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_process_subitem_bm" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_product_bg" primaryKey="PK_PRODUCT_ID" type="global" dataNode="pre_node" />
<table name="bd_product_operation_bg" primaryKey="PK_PRODUCT_ORERA_ID" type="global" dataNode="pre_node" />
<table name="bd_product_property_bg" primaryKey="PK_PROPERTY_ID" type="global" dataNode="pre_node" />
<table name="bd_product_property_value_bg" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_product_property_value1" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_product_property1" primaryKey="PK_PROPERTY_ID" type="global" dataNode="pre_node" />
<table name="bd_product_range_bg" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_product_type_bg" primaryKey="PK_PRODUCT_TYPE_ID" type="global" dataNode="pre_node" />
<table name="bd_product1" primaryKey="PK_PRODUCT_ID" type="global" dataNode="pre_node" />
<table name="bd_resource_bg" primaryKey="PK_RESOURCE_ID" type="global" dataNode="pre_node" />
<table name="bd_role_authority_bg" primaryKey="pk_role_auth_id" type="global" dataNode="pre_node" />
<table name="bd_role_bg" primaryKey="role_id" type="global" dataNode="pre_node" />
<table name="bd_senior_log_bm" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_shelf_product_type_bg" primaryKey="PK_PRODUCT_TYPE_ID" type="global" dataNode="pre_node" />
<table name="bd_shopping_cart_bg" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_template_bg" primaryKey="PK_TEMPLATE_ID" type="global" dataNode="pre_node" />
<table name="bd_template_operation_bg" primaryKey="PK_TEMPLATE_ORERA_ID" type="global" dataNode="pre_node" />
<table name="bd_user_authdata_bg" primaryKey="PK_USER_AUTHDATA_ID" type="global" dataNode="pre_node" />
<table name="bd_user_bg" primaryKey="PK_USER_ID" type="global" dataNode="pre_node" />
<table name="bd_user_info_bg" primaryKey="PK_USER_ID" type="global" dataNode="pre_node" />
<table name="bd_user_info1" primaryKey="PK_USER_ID" type="global" dataNode="pre_node" />
<table name="bd_user_role_bg" primaryKey="pk_user_role_id" type="global" dataNode="pre_node" />
<table name="bd_work_order_body_bg" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_work_order_info_bg" primaryKey="PK_WORK_ORDER_ID" type="global" dataNode="pre_node" />
<table name="bd_workorder_operation_bg" primaryKey="PK_WORKORDER_ORERA_ID" type="global" dataNode="pre_node" />
<table name="ini_dic_bg" primaryKey="PK_DIC_ID" type="global" dataNode="pre_node" />
<table name="ini_dic_detail_bg" primaryKey="PK_DIC_DETAIL_ID" type="global" dataNode="pre_node" />
<table name="rel_activity_product_bg" primaryKey="PK_ACTIVITY_PRODUCT_ID" type="global" dataNode="pre_node" />
<table name="rel_activity_template_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="rel_invoice_order_bg" primaryKey="PK_REL_INVOICE_ORDER_ID" type="global" dataNode="pre_node" />
<table name="rel_order_relation_bg" primaryKey="PK_RELATION_ID" type="global" dataNode="pre_node" />
<table name="rel_process_messagemodule_bm" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="rel_product_process_bm" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="rel_product_product_bg" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="rel_product_property_bg" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="rel_product_property_copy1" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="rel_product_property1" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="rel_product_property2" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="rel_productrange_product_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="rel_template_field_bg" primaryKey="PK_TEMPLATE_FIELD_ID" type="global" dataNode="pre_node" />
<table name="rel_zcuser_info_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="st_consult_data_bg" primaryKey="pk_id" type="global" dataNode="pre_node" />
<table name="st_coupon_data_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="st_cs_operations_bg" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="st_daily_operations_bg" primaryKey="PK_OPERATIONS_ID" type="global" dataNode="pre_node" />
<table name="st_detail_data_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="st_iceclick_data_bm" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="st_law_product_data_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="st_lottery_draw_data_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="st_microblog_data_bg" primaryKey="pk_id" type="global" dataNode="pre_node" />
<table name="st_order_data_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="st_pay_data_bg" primaryKey="pk_id" type="global" dataNode="pre_node" />
<table name="st_phone_data_bg" primaryKey="pk_id" type="global" dataNode="pre_node" />
<table name="st_product_operations_bg" primaryKey="PK_PRODUCT_OPERATIONS_ID" type="global" dataNode="pre_node" />
<table name="st_receive_data_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="st_sign_data_bg" primaryKey="pk_id" type="global" dataNode="pre_node" />
<table name="st_special_data_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="st_user_data_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="st_wechat_data_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="st_window_data_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="user" primaryKey="ID" type="global" dataNode="pre_node" />
<!--2018/01/22 14:41 -->
<table name="bd_customer_rating" primaryKey="PK_CUSTOMER_RATING_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_property_value" primaryKey="PK_PROPERTY_VALUE_ID" type="global" dataNode="pre_node" />
<table name="BD_customer_statistics" primaryKey="PK_CUSTOMER_STATISTICS_ID" type="global" dataNode="pre_node" />
<table name="bd_industry" primaryKey="PK_INDUSTRT_ID" type="global" dataNode="pre_node" />
<table name="ini_dic_detail" primaryKey="PK_DIC_DETAIL_ID" type="global" dataNode="pre_node" />
<table name="bd_relate_info_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_user_info" primaryKey="PK_USER_ID" type="global" dataNode="pre_node" />
<table name="sys_property_value" primaryKey="PK_PROPERTY_VALUE_ID" type="global" dataNode="pre_node" />
<table name="sys_property" primaryKey="PK_PROPERTY_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_file" primaryKey="PK_FILE_ID" type="global" dataNode="pre_node" />
<table name="bd_contact" primaryKey="PK_CONTACT_ID" type="global" dataNode="pre_node" />
<table name="bd_contract" primaryKey="PK_CONTRACT_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_body" primaryKey="PK_CUSTOMER_BODY_ID" type="global" dataNode="pre_node" />
<table name="sys_property_area" primaryKey="PK_PROPERTY_AREA_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_communication" primaryKey="PK_CUSTOMER_COMMUNICATION_ID" type="global" dataNode="pre_node" />
<table name="bd_visit" primaryKey="PK_VISIT_ID" type="global" dataNode="pre_node" />
<table name="bd_label" primaryKey="PK_LABEL_ID" type="global" dataNode="pre_node" />
<table name="bd_label_type" primaryKey="PK_LABEL_TYPE_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_d" primaryKey="PK_ADVANCED_PROPERTIES_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_h" primaryKey="PK_CUSTOMER_ID" type="global" dataNode="pre_node" />
<!--2018/01/25 16:50 -->
<table name="bd_returnvisit" primaryKey="PK_RETURNVISIT_ID" type="global" dataNode="pre_node" />
<table name="bd_corp_info" primaryKey="PK_CORP_ID" type="global" dataNode="pre_node" />
<!--2018-01-29 -->
<table name="bd_case" primaryKey="PK_CASE_ID" type="global" dataNode="pre_node" />
<table name="bd_order_info" primaryKey="PK_ORDER_ID" type="global" dataNode="pre_node" />
<table name="bd_label_customer" primaryKey="PK_LABEL_CUSTOMER_ID" type="global" dataNode="pre_node" />
<table name="bd_case_property_configuration" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_case_official" primaryKey="PK_CASE_OFFICIAL_ID" type="global" dataNode="pre_node" />
<table name="bd_case_file" primaryKey="PK_ACASE_FILE_ID" type="global" dataNode="pre_node" />
<!--2018-03-20 -->
<table name="rel_qquser_info_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<!--2018-04-20 -->
<table name="bd_product_serveitem_bg" primaryKey="PK_PRODUCT_SERVEITEM_ID" type="global" dataNode="pre_node" />
<table name="rel_product_serveitem_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" /> </schema>
<!--003xxx项目_所需数据表配置_xxxx环境-->
<schema name="butler_pre_schemas" checkSQLschema="false" >
<!--2017-11-16 新增bd_butler_product-->
<table name="bd_butler_product" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_case" primaryKey="PK_CASE_ID" type="global" dataNode="pre_node" />
<table name="bd_case_flow" primaryKey="id" type="global" dataNode="pre_node" />
<table name="bd_contact" primaryKey="PK_CONTACT_ID" type="global" dataNode="pre_node" />
<table name="bd_contract" primaryKey="PK_CONTRACT_ID" type="global" dataNode="pre_node" />
<table name="bd_contract_file" primaryKey="ID" type="global" dataNode="pre_node" />
<!--2017-10-25 新增bd_contract_product -->
<table name="bd_contract_product" primaryKey="PK_CONTRACT_PRODUCT_ID" type="global" dataNode="pre_node" />
<!--2017-10-19 新增bd_corp_info -->
<table name="bd_corp_info" primaryKey="PK_CORP_ID" type="global" dataNode="pre_node" />
<table name="bd_customer" primaryKey="PK_CUSTOMER_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_body" primaryKey="PK_CUSTOMER_BODY_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_file" primaryKey="PK_FILE_ID" type="global" dataNode="pre_node" />
<!--2017-10-19 新增bd_department_info,bd_corp_info 同事-->
<table name="bd_department_info" primaryKey="PK_DEPARTMENT_ID" type="global" dataNode="pre_node" />
<table name="bd_districtvalues" primaryKey="PK_DISTRICT_ID" type="global" dataNode="pre_node" />
<table name="bd_flow" primaryKey="PK_FLOW_ID" type="global" dataNode="pre_node" />
<table name="bd_industry" primaryKey="PK_INDUSTRT_ID" type="global" dataNode="pre_node" />
<table name="bd_issued_audit" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_issued_file" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_label" primaryKey="PK_LABEL_ID" type="global" dataNode="pre_node" />
<table name="bd_label_customer" primaryKey="PK_LABEL_CUSTOMER_ID" type="global" dataNode="pre_node" />
<table name="bd_order_info" primaryKey="PK_ORDER_ID" type="global" dataNode="pre_node" />
<table name="bd_product" primaryKey="PK_PRODUCT_ID" type="global" dataNode="pre_node" />
<table name="bd_product_property" primaryKey="PK_PROPERTY_ID" type="global" dataNode="pre_node" />
<table name="bd_product_property_value" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_share" primaryKey="PK_SHARE_ID" type="global" dataNode="pre_node" />
<table name="bd_user_info" primaryKey="PK_USER_ID" type="global" dataNode="pre_node" />
<table name="sys_property" primaryKey="PK_PROPERTY_ID" type="global" dataNode="pre_node" />
<!--2017-11-20 新增ini_dic_detail -->
<table name="ini_dic_detail" primaryKey="PK_DIC_DETAIL_ID" type="global" dataNode="pre_node" />
<table name="sys_property_area" primaryKey="PK_PROPERTY_AREA_ID" type="global" dataNode="pre_node" />
<table name="sys_property_value" primaryKey="PK_PROPERTY_VALUE_ID" type="global" dataNode="pre_node" />
<table name="bd_account_bm" primaryKey="pk_account_id" type="global" dataNode="pre_node" />
<table name="bd_account_login_bm" primaryKey="PK_ACCOUNT_LOGIN" type="global" dataNode="pre_node" />
<table name="bd_activity_bg" primaryKey="PK_ACTIVITY_ID" type="global" dataNode="pre_node" />
<table name="bd_appraise_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_authority_bg" primaryKey="PK_AUTH_ID" type="global" dataNode="pre_node" />
<table name="bd_carousel_figure_bg" primaryKey="PK_CAROUSEL_FIGURE_ID" type="global" dataNode="pre_node" />
<table name="bd_corp_info_bg" primaryKey="PK_CORP_ID" type="global" dataNode="pre_node" />
<table name="bd_coupon_bg" primaryKey="PK_COUPON_ID" type="global" dataNode="pre_node" />
<table name="bd_coupon_template_bg" primaryKey="PK_COUPON_TEMPLATE_ID" type="global" dataNode="pre_node" />
<table name="bd_coupon_template_value_bg" primaryKey="PK_COUPON_TEMPLATE_VALUE_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_bm" primaryKey="PK_CUSTOMER_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_body_bm" primaryKey="PK_CUSTOMER_BODY_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_body_file_bm" primaryKey="PK_CUSTOMER_BODY_FILE_ID" type="global" dataNode="pre_node" />
<table name="bd_customer_operation_bm" primaryKey="PK_ORERA_ID" type="global" dataNode="pre_node" />
<table name="bd_dealing_people_bg" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_department_info_bg" primaryKey="PK_DEPARTMENT_ID" type="global" dataNode="pre_node" />
<table name="bd_districtvalues_bg" primaryKey="PK_DISTRICT_ID" type="global" dataNode="pre_node" />
<!--2017-10-10 新增bd_exclusive,bd_exclusive_member -->
<table name="bd_exclusive_bm" primaryKey="PK_EXCLUSIVE_ID" type="global" dataNode="pre_node" />
<table name="bd_exclusive_member_bm" primaryKey="PK_MEMBER_ID" type="global" dataNode="pre_node" />
<table name="bd_field_bg" primaryKey="PK_FIELD_ID" type="global" dataNode="pre_node" />
<table name="bd_field_value_bg" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_industry_bg" primaryKey="PK_INDUSTRT_ID" type="global" dataNode="pre_node" />
<table name="bd_info_bg" primaryKey="PK_INFO_ID" type="global" dataNode="pre_node" />
<table name="bd_info_operation_bg" primaryKey="PK_ORERA_ID" type="global" dataNode="pre_node" />
<table name="bd_invoice_bg" primaryKey="PK_INVOICE_ID" type="global" dataNode="pre_node" />
<table name="bd_invoice_body_bg" primaryKey="PK_INVOICE_BODY_ID" type="global" dataNode="pre_node" />
<table name="bd_ipc_class_bg" primaryKey="PK_IPC_CLASS_ID" type="global" dataNode="pre_node" />
<table name="bd_ipdata_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_log_info_bm" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_log_module_bm" primaryKey="ID" type="global" dataNode="pre_node" />
<!--2017-10-10 新增bd_message_module_bm表 -->
<table name="bd_message_module_bm" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_niceclassification_bg" primaryKey="PK_NiceClassification_ID" type="global" dataNode="pre_node" />
<table name="bd_order_body_bg" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_order_info_bg" primaryKey="PK_ORDER_ID" type="global" dataNode="pre_node" />
<table name="bd_order_operation_bg" primaryKey="PK_ORDER_ORERA_ID" type="global" dataNode="pre_node" />
<table name="bd_order_property_value_bg" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_password_bm" primaryKey="pk_password_id" type="global" dataNode="pre_node" />
<table name="bd_process_bm" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_process_item_bm" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_process_item_value_bm" primaryKey="ID" type="global" dataNode="pre_node" />
<!--2017-11-16 新增bd_process_subitem_bm表 -->
<table name="bd_process_subitem_bm" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_product_bg" primaryKey="PK_PRODUCT_ID" type="global" dataNode="pre_node" />
<table name="bd_product_operation_bg" primaryKey="PK_PRODUCT_ORERA_ID" type="global" dataNode="pre_node" />
<table name="bd_product_property_bg" primaryKey="PK_PROPERTY_ID" type="global" dataNode="pre_node" />
<table name="bd_product_property_value_bg" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_product_range_bg" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_product_type_bg" primaryKey="PK_PRODUCT_TYPE_ID" type="global" dataNode="pre_node" />
<table name="bd_resource_bg" primaryKey="PK_RESOURCE_ID" type="global" dataNode="pre_node" />
<table name="bd_role_bg" primaryKey="role_id" type="global" dataNode="pre_node" />
<table name="bd_role_authority_bg" primaryKey="pk_role_auth_id" type="global" dataNode="pre_node" />
<table name="bd_senior_log_bm" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="bd_shelf_product_type_bg" primaryKey="PK_PRODUCT_TYPE_ID" type="global" dataNode="pre_node" />
<table name="bd_shopping_cart_bg" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_template_bg" primaryKey="PK_TEMPLATE_ID" type="global" dataNode="pre_node" />
<table name="bd_template_operation_bg" primaryKey="PK_TEMPLATE_ORERA_ID" type="global" dataNode="pre_node" />
<table name="bd_user_info_bg" primaryKey="PK_USER_ID" type="global" dataNode="pre_node" />
<table name="bd_user_role_bg" primaryKey="pk_user_role_id" type="global" dataNode="pre_node" />
<table name="bd_work_order_body_bg" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_work_order_info_bg" primaryKey="PK_WORK_ORDER_ID" type="global" dataNode="pre_node" />
<table name="bd_workorder_operation_bg" primaryKey="PK_WORKORDER_ORERA_ID" type="global" dataNode="pre_node" />
<table name="ini_dic_bg" primaryKey="PK_DIC_ID" type="global" dataNode="pre_node" />
<table name="ini_dic_detail_bg" primaryKey="PK_DIC_DETAIL_ID" type="global" dataNode="pre_node" />
<table name="rel_activity_product_bg" primaryKey="PK_ACTIVITY_PRODUCT_ID" type="global" dataNode="pre_node" />
<table name="rel_activity_template_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="rel_invoice_order_bg" primaryKey="PK_REL_INVOICE_ORDER_ID" type="global" dataNode="pre_node" />
<!--2017-10-10 新增rel_process_messagemodule_bm表 -->
<table name="rel_process_messagemodule_bm" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="rel_product_process_bm" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="rel_product_property_bg" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="rel_productrange_product_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="rel_template_field_bg" primaryKey="PK_TEMPLATE_FIELD_ID" type="global" dataNode="pre_node" />
<table name="rel_zcuser_info_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="st_consult_data_bg" primaryKey="pk_id" type="global" dataNode="pre_node" />
<table name="st_coupon_data_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="st_cs_operations_bg" primaryKey="PK_CS_OPERATIONS_ID" type="global" dataNode="pre_node" />
<table name="st_detail_data_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<!--2017-09-26 新增表st_iceClick_data_bm -->
<table name="st_iceclick_data_bm" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="st_law_product_data_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="st_lottery_draw_data_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="st_microblog_data_bg" primaryKey="pk_id" type="global" dataNode="pre_node" />
<table name="st_order_data_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="st_pay_data_bg" primaryKey="pk_id" type="global" dataNode="pre_node" />
<table name="st_phone_data_bg" primaryKey="pk_id" type="global" dataNode="pre_node" />
<table name="st_product_operations_bg" primaryKey="PK_PRODUCT_OPERATIONS_ID" type="global" dataNode="pre_node" />
<table name="st_receive_data_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="st_sign_data_bg" primaryKey="pk_id" type="global" dataNode="pre_node" />
<table name="st_special_data_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="st_user_data_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="st_wechat_data_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<table name="st_window_data_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
<!--2018/01/30 -->
<table name="bd_customer_h" primaryKey="PK_CUSTOMER_ID" type="global" dataNode="pre_node" />
<!--2018/2/10 -->
<table name="BD_CASE_OFFICIAL" primaryKey="PK_CASE_OFFICIAL_ID" type="global" dataNode="pre_node" />
<!--2018/2/28 -->
<table name="bd_case_file" primaryKey="PK_ACASE_FILE_ID" type="global" dataNode="pre_node" />
<table name="bd_replenishment_detail" primaryKey="ID" type="global" dataNode="pre_node" />
<table name="bd_replenishment" primaryKey="PK_REPLENISHMENT_ID" type="global" dataNode="pre_node" />
<!--2018-03-20 -->
<table name="rel_qquser_info_bg" primaryKey="PK_ID" type="global" dataNode="pre_node" />
</schema> <!--004xxx所需数据表配置_xxxx环境-->
<schema name="logs_pre_schemas" checkSQLschema="false" dataNode="pre_node" > </schema>
<!--005xxx系统所需数据表配置_xxxx环境-->
<schema name="quartz_pre_schemas" checkSQLschema="false" dataNode="pre_node" > </schema>
<!--007xxx系统所需数据表配置_xxxx环境-->
<schema name="partners_pre_schemas" checkSQLschema="false" dataNode="pre_node" > </schema> <!--xxxx环境场景的mycat数据节点（datenode）后端对应数据库实例名配置-->
<!-- 001——Mycat数据节点_xxxx环境,数据库实例名：db_prd-->
<dataNode name="pre_node" dataHost="mysql_host1" database="db_mycat" />
<dataHost name="mysql_host1" maxCon="10000" minCon="10" balance="3" writeType="0" dbType="mysql" dbDriver="native" switchType="1">
<heartbeat>select user()</heartbeat>
<writeHost host="hostM1" url="47.94.220.179:3306" user="root" password="123456">
<readHost host="hostS1" url="47.94.211.118:3306" user="root" password="123456" />
</writeHost>
<writeHost host="hostM2" url="47.94.211.118:3306" user="root" password="123456"/>
</dataHost>
</mycat:schema>
schema.xml举例
<?xml version="1.0" encoding="UTF-8"?>
<!-- - - Licensed under the Apache License, Version 2.0 (the "License");
- you may not use this file except in compliance with the License. - You
may obtain a copy of the License at - - http://www.apache.org/licenses/LICENSE-2.0
- - Unless required by applicable law or agreed to in writing, software -
distributed under the License is distributed on an "AS IS" BASIS, - WITHOUT
WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. - See the
License for the specific language governing permissions and - limitations
under the License. -->
<!DOCTYPE mycat:server SYSTEM "server.dtd">
<mycat:server xmlns:mycat="http://io.mycat/">
<system>
<property name="defaultSqlParser">druidparser</property>
<property name="processors">64</property>
<property name="processorExecutor">256</property>
<property name="processorBufferPool">268435456</property>
<property name="processorBufferChunk">32768</property>
<property name="useGlobleTableCheck">0</property>
</system> <!--001xxx项目——Mycat对应jdbc连接账号_生产环境-->
<user name="ec_pre_user">
<property name="password">ecpre123456789</property>
<property name="schemas">ec_pre_schemas</property>
</user>
<!--002xxx项目——Mycat对应jdbc连接账号_生产环境-->
<user name="bingo_pre_user">
<property name="password">bingopre123456789</property>
<property name="schemas">bingo_pre_schemas</property>
</user>
<!--003xxx项目——Mycat对应jdbc连接账号_生产环境-->
<user name="butler_pre_user">
<property name="password">butlerpre123456789</property>
<property name="schemas">butler_pre_schemas</property>
</user>
<!--004xxx项目——Mycat对应jdbc连接账号_生产环境-->
<user name="logs_pre_user">
<property name="password">logspre123456789</property>
<property name="schemas">logs_pre_schemas</property>
</user>
<!--005xxx项目——Mycat对应jdbc连接账号_生产环境-->
<user name="quartz_pre_user">
<property name="password">quartzpre123456789</property>
<property name="schemas">quartz_pre_schemas</property>
</user>
<!--007xxx系统——Mycat对应jdbc连接账号_生产环境-->
<user name="partners_pre_user">
<property name="password">partnerspre123456789</property>
<property name="schemas">partners_pre_schemas</property>
</user> </mycat:server>
server.xml举例