# goMontioringDdl

**Repository Path**: copen/goMontioringDdl

## Basic Information

- **Project Name**: goMontioringDdl
- **Description**: go 通过binlog实现监控ddl发送钉钉报警
- **Primary Language**: Go
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 12
- **Created**: 2020-11-22
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

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

### v1.0.1
	1、添加对sql做优化建议
	效果图:
![输入图片说明](https://images.gitee.com/uploads/images/2019/1107/085205_50b4cbb5_636453.png "1.png")
![输入图片说明](https://images.gitee.com/uploads/images/2019/1107/085216_baf7d905_636453.png "2.png")

## Install

+ Install Go (1.6+) and set your [GOPATH](https://golang.org/doc/code.html#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](./etc/river.toml).
+ Config ding_webhook_url,send dinding message.
+ Set MySQL source in config file, see [Source](#source) below.
+ Customize MySQL and Elasticsearch mapping rule in config file, see [Rule](#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]
```
### 如果你对我的辛勤劳动给予肯定，请给我捐赠，你的捐赠是我最大的动力
![](https://gitee.com/qieangel2013/zys/blob/master/public/images/pw.jpg)
![](https://gitee.com/qieangel2013/zys/blob/master/public/images/pay.png)
[项目捐赠列表](https://github.com/qieangel2013/zys/wiki/%E9%A1%B9%E7%9B%AE%E6%8D%90%E8%B5%A0)