Score
0
Watch 8 Star 20 Fork 5

qieangel2013 / goMontioringDdlGo

Join us
Explore and code with more than 2 million developers,Free private repositories !:)
Sign up
go 通过binlog实现监控ddl发送钉钉报警 spread retract

Clone or download
Cancel
Notice: Creating folder will generate an empty file .keep, because not support in Git
Loading...
README.md

goMontioringDdl 是go通过binlog实现对ddl监控发送钉钉消息

v1.0.1

1、添加对sql做优化建议
效果图:

输入图片说明 输入图片说明

Install

  • Install Go (1.6+) and set your GOPATH
  • go get github.com/qieangel2013/goMontioringDdl, it will print some messages in console, skip it. :-)
  • cd $GOPATH/src/github.com/qieangel2013/goMontioringDdl
  • go build main
  • ./main

How to use?

  • Create table in MySQL.
  • Config base, see the example config river.toml.
  • Config ding_webhook_url,send dinding message.
  • Set MySQL source in config file, see Source below.
  • Customize MySQL and Elasticsearch mapping rule in config file, see Rule below.
  • Start ./main and enjoy it.

Notice

  • binlog format must be row.
  • binlog row image must be full for MySQL, you may lost some field data if you update PK data in MySQL with minimal or noblob binlog row image. MariaDB only supports full row image.
  • Can not alter table format at runtime.
  • MySQL table which will be synced should have a PK(primary key), multi columns PK is allowed now, e,g, if the PKs is (a, b), we will use "a:b" as the key. The PK data will be used as "id" in Elasticsearch. And you can also config the id's constituent part with other column.
  • You should create the associated mappings in Elasticsearch first, I don't think using the default mapping is a wise decision, you must know how to search accurately.
  • mysqldump must exist in the same node with go-mysql-elasticsearch, if not, go-mysql-elasticsearch will try to sync binlog only.
  • Don't change too many rows at same time in one SQL.

Source

source config.

The format in config file is below:

# MySQL data source
[[source]]
schema = "test"
tables = ["*"]

# MySQL data source
[[source]]
schema = "test_1"
tables = ["*", t4]

如果你对我的辛勤劳动给予肯定,请给我捐赠,你的捐赠是我最大的动力

项目捐赠列表

Comments ( 8 )

Sign in for post a comment

Go
1
https://gitee.com/qieangel2013/goMontioringDdl.git
git@gitee.com:qieangel2013/goMontioringDdl.git
qieangel2013
goMontioringDdl
goMontioringDdl
master

Help Search