maxwell安装使用教程
安装
http://maxwells-daemon.io/quickstart/
下载后配置
$ vi my.cnf
[mysqld]
server_id=1
log-bin=master
binlog_format=row
或者在正在运行的服务器上
mysql> set global binlog_format=ROW;
mysql> set global binlog_row_image=FULL;
配置mysql用户名
mysql> GRANT ALL on maxwell.* to 'maxwell'@'%' identified by 'XXXXXX';
mysql> GRANT SELECT, REPLICATION CLIENT, REPLICATION SLAVE on *.* to 'maxwell'@'%';
# or for running maxwell locally:
mysql> GRANT SELECT, REPLICATION CLIENT, REPLICATION SLAVE on *.* to 'maxwell'@'localhost' identified by 'XXXXXX';
mysql> GRANT ALL on maxwell.* to 'maxwell'@'localhost';
运行
bin/maxwell --user='maxwell' --password='XXXXXX' --host='127.0.0.1' --producer=stdout
此时,maxwell已经在监控数据库的变化啦