Skip to content

A Mysql data to file/elasticsearch/kafka/redis/redis-cluster/mongodb(audit and normal)/TiDB/postgresql with binlog tool.

Notifications You must be signed in to change notification settings

gitstliu/MysqlToAll

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

24 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

中文

MysqlToAll

A Mysql data to file/elasticsearch/kafka/redis/redis-cluster with binlog tool.

High Performance

How to config?

canalconfigs

xxx.toml (canal config file) xxx.pos (binlog pos file) 

config

config.toml (Output source config file) 

具体用法

QQ群

691944436

The answer is zero

Performance Test Data

Test Machine : 4C 8G

Scene1:Mixed Channels:Tow mysql master binlog write to redis、redis-cluster、kafka、es、local file in one time.

Total Binlog Raw Count:1 Million Bulksize: 1000 Resource utilization CPU: 250% Mem:3% Duration:178s 

Scene2:Single Channel:One mysql master binlog write to redis.

Total Binlog Raw Count:1 Million Bulksize: 1000 Resource utilization CPU: 230% Mem:0.5% Duration:27s 

Scene3:Single Channel:One mysql master binlog write to redis-cluster.

Total Binlog Raw Count:1 Million Bulksize: 1000 Resource utilization CPU: 230% Mem:0.5% Duration:21s 

Scene4:Single Channel:One mysql master binlog write to elasticsearch.

Total Binlog Raw Count:1 Million Bulksize: 1000 Resource utilization CPU: 90% Mem:0.5% Duration:62s 

Scene5:Single Channel:One mysql master binlog write to kafka.

Total Binlog Raw Count:1 Million Bulksize: 1000 Resource utilization CPU: 230% Mem:1% Duration:24s 

Scene6:Single Channel:One mysql master binlog write to local file.

Total Binlog Raw Count:1 Million Bulksize: 1000 Resource utilization CPU: 280% Mem:0.5% Duration:38s 

About

A Mysql data to file/elasticsearch/kafka/redis/redis-cluster/mongodb(audit and normal)/TiDB/postgresql with binlog tool.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages