[root@mysql-host1 /data/bifrost/data]# cat db.Bifrost | python3 -mjson.tool
{
"Version": "v1.8.0-beta.01",
"ToServer": {
"dba_test-tb1_all": {
"PluginName": "clickhouse",
"PluginVersion": "v1.7.3",
"ConnUri": "tcp://192.168.56.11:9000?username=default&password=123&compress=true",
"Notes": "dba_test-tb1_all",
"LastID": 3,
"CurrentConn": 3,
"MaxConn": 20,
"MinConn": 1,
"AvailableConn": 3,
"UpdateTime": 1661154931
}
},
"DbInfo": {
"dba_test": {
"Name": "dba_test",
"ConnectUri": "bifrost:123@tcp(10.0.0.11:3306)/dba_test",
"ConnStatus": "running",
"ConnErr": "",
"ChannelMap": {
"1": {
"Name": "default",
"MaxThreadNum": 1,
"CurrentThreadNum": 0,
"Status": "running"
},
"2": {
"Name": "channel10",
"MaxThreadNum": 10,
"CurrentThreadNum": 0,
"Status": "running"
}
},
"LastChannelID": 2,
"TableMap": {
"dba_test_-tb1": {
"Name": "tb1",
"ChannelKey": 2,
"LastToServerID": 1,
"ToServerList": [
{
"ToServerID": 1,
"PluginName": "clickhouse",
"MustBeSuccess": true,
"FilterQuery": false,
"FilterUpdate": true,
"FieldList": [],
"ToServerKey": "dba_test-tb1_all",
"LastSuccessBinlog": {
"BinlogFileNum": 265,
"BinlogPosition": 802,
"GTID": "ea42d50c-88c0-11ec-9a53-000c2911ac8b:1-3627862",
"Timestamp": 1661226651,
"EventID": 1119
},
"LastQueueBinlog": {
"BinlogFileNum": 265,
"BinlogPosition": 771,
"GTID": "",
"Timestamp": 1661226651,
"EventID": 1118
},
"BinlogFileNum": 265,
"BinlogPosition": 802,
"PluginParam": {
"AutoCreateTable": false,
"BatchSize": 1,
"BifrostFilterQuery": false,
"BifrostMustBeSuccess": true,
"CkSchema": "dba_test",
"CkTable": "tb1_all",
"Field": [
{
"CK": "id",
"MySQL": "id"
},
{
"CK": "c1",
"MySQL": "c1"
},
{
"CK": "c2",
"MySQL": "c2"
},
{
"CK": "c3",
"MySQL": "c3"
},
{
"CK": "c4",
"MySQL": "c4"
},
{
"CK": "c5",
"MySQL": "c5"
},
{
"CK": "create_time",
"MySQL": "create_time"
},
{
"CK": "update_time",
"MySQL": "update_time"
},
{
"CK": "binlog_event_type",
"MySQL": "{$EventType}"
},
{
"CK": "ts",
"MySQL": "{$BinlogTimestamp}"
},
{
"CK": "dts",
"MySQL": ""
}
],
"LowerCaseTableNames": 0,
"NullNotTransferDefault": true,
"PriKey": [
{
"CK": "id",
"MySQL": "id"
}
],
"SyncType": "insertAll"
},
"Status": "",
"Error": "",
"ErrorWaitDeal": 0,
"ErrorWaitData": null,
"LastBinlogFileNum": 265,
"LastBinlogPosition": 771,
"QueueMsgCount": 0,
"FileQueueStatus": false,
"Notes": "",
"ThreadCount": 0,
"FileQueueUsableCount": 0,
"FileQueueUsableCountStartTime": 0
}
],
"IgnoreTable": ""
}
},
"IsGtid": true,
"LastEventID": 1119,
"Gtid": "ea42d50c-88c0-11ec-9a53-000c2911ac8b:1-3627862",
"BinlogDumpFileName": "mysql-bin.000265",
"BinlogDumpPosition": 802,
"BinlogDumpTimestamp": 1661226651,
"MaxBinlogDumpFileName": "",
"MaxinlogDumpPosition": 0,
"ReplicateDoDb": {
"dba_test": 1
},
"ServerId": 113313,
"AddTime": 1661154319
}
},
"User": null,
"Warning": null
}
[root@mysql-host1 /data/bifrost/data]#
标签：Bifrost,CK,dba,db,tb1,MySQL,test,true From： https://www.cnblogs.com/zhouwanchun/p/16615727.html