Bifrost Document

Version 1.6.x

Bifrost ---- A heterogeneous middleware which can synchronize MySQL binlog data To Redis,MongoDB,ClickHouse...

Batch Config

Use Case:

  1. Multiple tables synchronize the same target library

Methond

two Methond

1. Batch Bind Channel and table

image image

1). Multi select check box

2). click button “批量绑定” , and then click button “保存”

3). show success log

开始添加

binlog_field_hprose_plugin_test ADD Result:success

binlog_field_http_plugin_test ADD Result:success

添加完成


2. Batch table bind toServer

2.1 Different data structures

image

Batch configuration of tables with different table structures to the same target library depends on whether the plug-in implementation supports it.

Like Redis,http,Kafka,RabbitMQ,ActiveMQ is supported.

1). Multi select check box ( must be binded channel )

2). Invalid selection field

3). click button “批量添加”,If not, you will be prompted not to support

4). show success log

开始提交

binlog_field_test success

bristol_performance_test success

执行完成
2.2 The data table structure is the same

= V1.4

image

Examle:

Tables : binlog_field_test_1,binlog_field_test_2,binlog_field_test_3

1). Click button “ADD” of table “binlog_field_test_1”

2). change FuzzyMatching to “YES”

3). change TableName to “binlog_fieldtest*”

4). select channel

5). click button “添加”

A virtual table name “binlog_fieldtest*” will append to table list

then you can controller the “binlog_fieldtest*”

image

3. AllTables

image

1). selected “AllTables”, SchemaName “AllDataBases” is all the database and table

2). select toServer

3). click button “提交”. If not, you will be prompted not to support

4. FuzzyMatching rule

change TableName must be contain “*”

Examle:

bak_binlog_field_test_mytest

binlog_field_test

binlog_field_test_1

binlog_field_test_2

binlog_field_test_3

table_nodata

table_nodata_2

rule 1:

binlog_fieldtest*

matching tables : binlog_field_test_1 , binlog_field_test_2 , binlog_field_test_3

not matching tables : bak_binlog_field_test_mytest 和 binlog_field_test

5. Notes

1). you schema name can’t be AllDataBases,AllTables

2). Invalid selection field

Last updated on 8 Sep 2020
Edit on GitHub