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已经在监控数据库的变化啦