One: Install and deploy MySQL in a Linux environment.
Open Binlog
Vim/etc/my.cnf
There are 3 binlog formats for MySQL, in order to parse Binlog into JSON data format, the format of Binlog to be set to row (Binlog has three formats: Statement, row, and mixed)
3 Restart MSYQL Service
Service mysqld Restart
See if Binlog is turned on
See if Binlog is turned on to row mode
/var/lib/mysql See generated the corresponding Binlog listening log file, master.000001 file, each restart MSYQL service, will generate a new listening file
Configuring Maxwell-related deployment work
1 Downloads Maxwell
Website
http://maxwells-daemon.io/
Installing TAR–ZXVF maxwell-1.14.4.tar.gz
Create DB and user for Maxwell
Create Database Maxwell;
GRANT all on maxwell.* to ' Maxwell ' @ ' percent ' identified by ' 123456 ';
GRANT SELECT, REPLICATION CLIENT, REPLICATION SLAVE on * * to ' Maxwell ' @ '% ';
Flush privileges;
3.5 Test stdout:
Bin/maxwell--user= ' Maxwell ' \
--password= ' 123456 '--host= ' 127.0.0.1 ' \
--producer=stdout
Test:
MySQL Insert data:
Insert into demo (id,name,age,address) VALUES (999, ' Jepson ', ' www.ruozedata.com ');
Maxwel
Monitor to Data
Use Maxwell components to monitor MySQL Binlog logs in real time