create database log_db DEFAULT CHARACTER SET utf8mb4;

四、schema.xml 的配置

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

<schema name="LOG_DB" checkSQLschema="false" sqlMaxLimit="100"><table name="tb_log" dataNode="dn1,dn2,dn3" primaryKey="id" rule="mod- long" /></schema>

<dataNode name="dn1" dataHost="host1" database="log_db" /><dataNode name="dn2" dataHost="host2" database="log_db" /><dataNode name="dn3" dataHost="host3" database="log_db" />

<dataHost name="host1" maxCon="1000" minCon="10" balance="0" writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100"><heartbeat>select user()</heartbeat><writeHost host="hostM1" url="192.168.192.157:3306" user="root" password="itcast"></writeHost></dataHost>

<dataHost name="host2" maxCon="1000" minCon="10" balance="0" writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100"><heartbeat>select user()</heartbeat><writeHost host="hostM2" url="192.168.192.158:3306" user="root" password="itcast"></writeHost></dataHost>

<dataHost name="host3" maxCon="1000" minCon="10" balance="0" writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100"><h

【一线大厂Java面试题解析+核心总结学习笔记+最新架构讲解视频+实战项目源码讲义】
浏览器打开：qq.cn.hn/FTf 免费领取

eartbeat>select user()</heartbeat><writeHost host="hostM3" url="192.168.192.159:3306" user="root" password="itcast"></writeHost></dataHost>

</mycat:schema>

五、server.xml 的配置

<user name="root" defaultAccount="true"><property name="password">123456</property><property name="schemas">LOG_DB</property></user>

<user name="test"><property name="password">123456</property><property name="schemas">LOG_DB</property></user>

<user name="user"><property name="password">123456</property><property name="schemas">LOG_DB</property><property name="readOnly">true</property></user>

六、测试

1.在 MyCat 数据库中执行建表语句

CREATE TABLE tb_log (id bigint(20) NOT NULL COMMENT 'ID',model_name varchar(200) DEFAULT NULL COMMENT '模块名',model_value varchar(200) DEFAULT NULL COMMENT '模块值',return_value varchar(200) DEFAULT NULL COMMENT '返回值',return_class varchar(200) DEFAULT NULL COMMENT '返回值类型',operate_user varchar(20) DEFAULT NULL COMMENT '操作用户',operate_time varchar(20) DEFAULT NULL COMMENT '操作时间',param_and_value varchar(500) DEFAULT NULL COMMENT '请求参数名及参数值',operate_class varchar(200) DEFAULT NULL COMMENT '操作类',operate_method varchar(200) DEFAULT NULL COMMENT '操作方法',cost_time bigint(20) DEFAULT NULL COMMENT '执行方法耗时, 单位 ms',source int(1) DEFAULT NULL COMMENT '来源 : 1 PC , 2 Android , 3 IOS',PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

2.插入数据

INSERT INTO tb_log (id, model_name, model_value, return_value,return_class, operate_user, operate_time, param_and_value, operate_class,operate_method, cost_time，source)VALUES('1','user','insert','success','java.lang.String','10001','2020-02-26 18:12:28','{"age":"20","name":"Tom","gender":"1"}','cn.itcast.controller.UserController','insert','10',1);

INSERT INTO tb_log (id, model_name, model_value, return_value,return_class,operate_user, operate_time, param_and_value, operate_class, operate_method, cost_time，source)