MyCat安装文档

MyCat安装文档

环境信息

节点	已安装软件	系统配置
node7	mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz;jdk-8u181-linux-x64.tar.gz	centos7.2

MySql安装参考

Cenos7 安装、卸载 MySql5.7

Jdk安装参考

Centos7 安装jdk 1.8

下载MyCat安装包

• 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