# binlog

**Repository Path**: fyunpeng/binlog

## Basic Information

- **Project Name**: binlog
- **Description**: dolphindb plugin binlog
- **Primary Language**: C++
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-01-04
- **Last Updated**: 2021-01-04

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

``` shell
sudo systemctl status mysql.service
sudo mysql -uroot -p

[mysqld]
log-bin=mysql-bin # 开启 binlog
binlog-format=ROW # 选择 ROW 模式
server_id=1 # 配置 MySQL replaction 需要定义，不要和 canal 的 slaveId 重复

sudo systemctl restart mysql.service

show binary logs;

CREATE USER canal IDENTIFIED BY 'DolphinDB123';  
GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'canal'@'%';
-- GRANT ALL PRIVILEGES ON *.* TO 'canal'@'%' ;
FLUSH PRIVILEGES;

loadPlugin("/home/ypfan/fanyunpeng/DolphinDBPlugin/binlog/cmake-build-debug/PluginBinlog.txt");
binlog::test(1);
```