# open-go2es

**Repository Path**: watchme/open-go2es

## Basic Information

- **Project Name**: open-go2es
- **Description**: 实现mysql迁移数据到es
- **Primary Language**: Java
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-07-06
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# open-go2es

#### 介绍
实现MYSQL数据迁移到ES

#### 软件架构
软件架构说明


#### 安装教程

>1.  es_config.properties

    # MySQL address, user and password
    mysql_address = jdbc:mysql://172.16.14.33:3306/sbk_access?characterEncoding=utf8
    mysql_username = root
    mysql_password = root
    mysql_sql = select * from ag_access_log
    mysql_field_rule = {"ID":"id","LOG_NAME":"logName","SURL_ORDER_ID":"surlOrderId","SURL_ORDER_ITEM_ID":"surlOrderItemId","USER_ID":"userId","APPLICATION_ID":"applicationId","REMOTE_ADDR":"remoteAddr","USER_AGENT":"userAgent","REQUEST_URI":"requestUri","REQUEST_METHOD":"requestMethod","REQUEST_PARAMS":"requestParams","COST_TIMES":"costTimes","RESPONSE_CODE":"responseCode","RESPONSE_MSG":"responseMsg","CRT_TIME":"crtTime","CRT_USER":"crtUser","CRT_NAME":"crtName","UPD_TIME":"updTime","UPD_USER":"updUser","UPD_NAME":"updName","DEL_FLAG":"delFlag"}
    
    # Elasticsearch address
    es_scheme = http
    es_address = 172.16.14.34
    es_port = 9200
    es_index = sbk_access
    es_type = ag_access_log
    es_commit_size = 5000
    


#### 使用说明

1. 修改配置文件es_config.properties 里面的数据库连接和es连接信息
2. java -jar open-go2es-1.0-SNAPSHOT-jar-with-dependencies.jar  ./es_config.properties 1

说明：
参数1：es_config.properties 需要为绝对路径
参数2：选填 0表示日志写入控制台，1表示日志写入文件