MyCat安装文档
环境信息
节点 | 已安装软件 | 系统配置 |
---|---|---|
node7 | mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz;jdk-8u181-linux-x64.tar.gz | centos7.2 |
MySql安装参考
Jdk安装参考
下载MyCat安装包
解压安装
> 解压
tar -zxvf Mycat-server-1.6.5-release-20180122220033-linux.tar.gz
> 移动到 /url/local
mv mycat/ /usr/local/
> 添加环境变量
vi /etc/profile
export MYCAT_HOME=/usr/local/mycat
export PATH=$MYCAT_HOME/bin:$PATH
> 刷新配置
source /etc/profile
> 启动Mycat
mycat start
> 查看mycat启动情况
cd /usr/local/mycat/logs/
tail -f wrapper.log
默认配置会启动失败
mycat配置
server.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="serverPort">8066</property>
<property name="managerPort">9066</property>
<property name="nonePasswordLogin">0</property>
<property name="bindIp">0.0.0.0</property>
<property name="frontWriteQueueSize">2048</property>
<property name="charset">utf8</property>
<property name="txIsolation">2</property>
<property name="processors">8</property>
<property name="idleTimeout">1800000</property>
<property name="sqlExecuteTimeout">300</property>
<property name="useGlobleTableCheck">0</property>
<property name="sequnceHandlerType">1</property>
<property name="defaultMaxLimit">100</property>
<property name="maxPacketSize">104857600</property>
</system>
<user name="mycat">
<property name="password">123456</property>
<property name="schemas">mycat_db</property>
</user>
</mycat:server>
schema.xml
<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">
<schema name="mycat_db" checkSQLschema="true" sqlMaxLimit="100">
<table name="product_info" dataNode="product_db" primaryKey="product_id"/>
</schema>
<dataNode name="product_db" dataHost="mysql127" database="product_db"/>
<dataHost balance="3" maxCon="1000" minCon="10" name="mysql127" writeType="0" switchType="1" dbType="mysql" dbDriver="native">
<heartbeat>select user()</heartbeat>
<writeHost host="192.168.56.127" url="192.168.56.127:3306" password="123456" user="root"/>
</dataHost>
</mycat:schema>
创建数据库
1.在 192.168.56.125 上创建 product_db 的数据库
2.在product_db数据库下建表 product_info
/*
Navicat Premium Data Transfer
Source Server : 192.168.56.127
Source Server Type : MySQL
Source Server Version : 50722
Source Host : 192.168.56.127:3306
Source Schema : product_db
Target Server Type : MySQL
Target Server Version : 50722
File Encoding : 65001
Date: 17/11/2018 11:10:26
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for product_info
-- ----------------------------
DROP TABLE IF EXISTS `product_info`;
CREATE TABLE `product_info` (
`product_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '商品ID',
`product_code` char(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品编码',
`product_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品名称',
`bar_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '国条码',
`brand_id` int(10) UNSIGNED NOT NULL COMMENT '品牌表的ID',
`one_category_id` smallint(5) UNSIGNED NOT NULL COMMENT '一级分类ID',
`two_category_id` smallint(5) UNSIGNED NOT NULL COMMENT '二级分类ID',
`three_category_id` smallint(5) UNSIGNED NOT NULL COMMENT '三级分类ID',
`supplier_id` int(10) UNSIGNED NOT NULL COMMENT '商品的供应商id',
`price` decimal(8, 2) NOT NULL COMMENT '商品销售价格',
`average_cost` decimal(18, 2) NOT NULL COMMENT '商品加权平均成本',
`publish_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '上下架状态:0下架1上架',
`audit_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '审核状态:0未审核,1已审核',
`weight` float NULL DEFAULT NULL COMMENT '商品重量',
`length` float NULL DEFAULT NULL COMMENT '商品长度',
`heigh` float NULL DEFAULT NULL COMMENT '商品高度',
`width` float NULL DEFAULT NULL COMMENT '商品宽度',
`color_type` enum('红','黄','蓝','黒') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`production_date` datetime(0) NOT NULL COMMENT '生产日期',
`shelf_life` int(11) NOT NULL COMMENT '商品有效期',
`descript` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品描述',
`indate` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '商品录入时间',
`modified_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最后修改时间',
PRIMARY KEY (`product_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8716 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of product_info
-- ----------------------------
INSERT INTO `product_info` VALUES (1, '1700000000000001', '[凯乐石]连衣裙示例商品-1', '74841558', 4, 1, 9, 17, 3, 772.13, 772.13, 0, 0, NULL, NULL, NULL, NULL, NULL, '2018-12-07 05:59:54', 180, '', '2018-09-26 23:00:31', '2018-09-26 23:00:34');
INSERT INTO `product_info` VALUES (2, '1800000000000001', '[TheNorthFace]蕾丝裙示例商品-1', '7634065578', 6, 1, 9, 18, 2, 260.34, 260.34, 0, 0, NULL, NULL, NULL, NULL, NULL, '2018-11-10 03:55:46', 180, '', '2018-09-26 23:00:31', '2018-09-26 23:00:34');
INSERT INTO `product_info` VALUES (3, '1900000000000001', '[骆驼]套装裙示例商品-1', '1286304455', 3, 1, 9, 19, 3, 657.47, 657.47, 0, 0, NULL, NULL, NULL, NULL, NULL, '2018-12-22 03:36:33', 180, '', '2018-09-26 23:00:31', '2018-09-26 23:00:34');
INSERT INTO `product_info` VALUES (4, '2000000000000001', '[NB]棉麻连衣裙示例商品-1', '7510673234', 17, 1, 9, 20, 5, 549.18, 549.18, 0, 0, NULL, NULL, NULL, NULL, NULL, '2018-11-04 14:11:51', 180, '', '2018-09-26 23:00:31', '2018-09-26 23:00:34');
INSERT INTO `product_info` VALUES (5, '2100000000000001', '[骆驼]针织裙示例商品-1', '213877578', 3, 1, 9, 21, 14, 692.81, 692.81, 0, 0, NULL, NULL, NULL, NULL, NULL, '2019-01-11 16:07:57', 180, '', '2018-09-26 23:00:31', '2018-09-26 23:00:34');
INSERT INTO `product_info` VALUES (6, '2200000000000001', '[Jack Wolfskin]a字裙示例商品-1', '5315840371', 11, 1, 9, 22, 13, 850.75, 850.75, 0, 0, NULL, NULL, NULL, NULL, NULL, '2018-11-25 19:29:03', 180, '', '2018-09-26 23:00:31', '2018-09-26 23:00:34');
INSERT INTO `product_info` VALUES (7, '2300000000000001', '[骆驼]长裙示例商品-1', '334061078', 3, 1, 9, 23, 11, 630.72, 630.72, 0, 0, NULL, NULL, NULL, NULL, NULL, '2018-10-24 23:34:31', 180, '', '2018-09-26 23:00:31', '2018-09-26 23:00:34');
INSERT INTO `product_info` VALUES (8, '2400000000000001', '[李宁]针织衫示例商品-1', '3184662781', 16, 1, 10, 24, 13, 244.99, 244.99, 0, 0, NULL, NULL, NULL, NULL, NULL, '2018-10-18 00:21:41', 180, '', '2018-09-26 23:00:31', '2018-09-26 23:00:34');
INSERT INTO `product_info` VALUES (9, '2500000000000001', '[太平鸟]衬衫示例商品-1', '1746569092', 15, 1, 10, 25, 1, 851.28, 851.28, 0, 0, NULL, NULL, NULL, NULL, NULL, '2018-10-19 21:29:15', 180, '', '2018-09-26 23:00:31', '2018-09-26 23:00:34');
INSERT INTO `product_info` VALUES (10, '2600000000000001', '[北极狐]T恤示例商品-1', '4370255829', 5, 1, 10, 26, 13, 464.10, 464.10, 0, 0, NULL, NULL, NULL, NULL, NULL, '2018-11-02 01:01:20', 180, '', '2018-09-26 23:00:31', '2018-09-26 23:00:34');
SET FOREIGN_KEY_CHECKS = 1;
启动成功
cd /usr/local/mycat/logs
tail -f wrapper.log
用MySQL客户端工具查看
常用命令
mycat start
mycat stop
mycat restart