go-mysql-starrocks是一个用go语言开发的,用于mysql实时同步到starrocks的工具组件,方便构建实时数仓。
使用说明
1. 修改配置文件
mysql-to-starrocks.toml
# name 必填,多实例运行时需保证全局唯一
name = "mysql2starrocks"
[mysql] # mysql连接信息
host = "127.0.0.1"
port = 3306
username = "root"
password = ""
[starrocks] # starrocks连接信息
host = "127.0.0.1"
port = 8040
username = "root"
password = ""
[[rule]] # 库表同步映射1
source-schema = "mysql_test"
source-table = "tb1"
target-schema = "starrocks_test"
target-table = "tb1"
[[rule]] # 库表同步映射2
source-schema = "mysql_test"
source-table = "tb2"
target-schema = "starrocks_test"
target-table = "tb2"
2. 启动
[sr@ ~]$ ./go-mysql-starrocks-linux-xxxxxx -config mysql-to-starrocks.toml
3. 查看日志
默认输出到控制台
指定log-file参数运行
[sr@ ~]$ ./go-mysql-starrocks-linux-xxxxxx -config mysql-to-starrocks.toml -log-file mysql2starrocks.log
[sr@ ~]$ tail -f mysql2starrocks.log
4. 查看帮助
[sr@ ~]$ ./go-mysql-starrocks-linux-xxxxxx -h
5. 后台运行
[sr@ ~]$ ./go-mysql-starrocks-linux-xxxxxx -config mysql-to-starrocks.toml -log-file mysql2starrocks.log &
[sr@ ~]$ exit