安装go-mysql-elasticsearch同步mysql数据到elasticsearch

本文介绍了如何在Linux环境下安装go-mysql-elasticsearch,并详细阐述了配置环境变量、编写同步规则、执行测试SQL以及启动和设置开机自启动的方法,帮助将MySQL数据高效地同步到Elasticsearch。
摘要由CSDN通过智能技术生成

安装go
官网下载并解压

wget https://dl.google.com/go/go1.12.13.linux-amd64.tar.gz
tar -xvf go1.12.13.linux-amd64.tar.gz -C /opt

配置环境变量

sudo vi ~/.bashrc

输入

export GOROOT=/opt/go
export GOPATH=/home/ubuntu/go-workplace
export PATH=$PATH:$GOROOT/bin:/$GOPATH/bin

使生效

source /etc/profile

查看版本

go version

安装go-mysql-elasticsearch

go get github.com/siddontang/go-mysql-elasticsearch
cd $GOPATH/src/github.com/siddontang/go-mysql-elasticsearch&&make

编写同步规则

# MySQL address, user and password
# user must have replication privilege in MySQL.
my_addr = "127.0.0.1:3306"
my_user = "root"
my_pass = "147258369"
my_charset = "utf8"

# Set true when elasticsearch use https
#es_https = false
# Elasticsearch address
es_addr = "127.0.0.1:9200"
# Elasticsearch user and password, maybe set by shield, nginx, or x-pack
es_user = ""
es_pass = ""

# Path to store data, like master.info, if not set or empty,
# we must use this to support breakpoint resume syncing. 
# TODO: support other storage, like etcd. 
data_dir = "./var"

# Inner Http status address
stat_
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值