Deployment of the Canal Client (code not)

Infrastructure mysql-5.7.17+canal.deployer-1.0.23 MySQL Binlog Open and configure server-side Deployment client deployment Binlog Open and configuration

The main is to modify the MySQL configuration file in general under the/ETC/MY.CNF directory, add the following:

Log-bin=master-bin #产生binlog的前缀
Log-bin-index=master-bin.index #产生binlog的样式 such as master-bin-00001
Binlog-format=row #binlog的格式, the server resolves only the ROW format, be sure.
Server-id=1 #区分主从, multiple MySQL ServerID is to be set to a different

Restart MySQL, make MySQL configuration effective, go to MySQL to view the opening:

Show binary logs;     #会有master-bin.000001 This document show
variables like ' Binlog_format ';
+---------------+-------+
| variable_name | Value |
+---------------+-------+
| binlog_format | ROW   |
+---------------+-------+ show
variables like ' log_bin ';
+---------------+-------+
| variable_name | Value |
+---------------+-------+
| Log_bin       | On    |
+---------------+-------+

configuration will have the above display, if not, there are problems in the configuration

service-side deployments

Download the canal.deployer-1.0.23 package, please download the latest version of the server side of the package
Domestic download will be very slow, if you want to quickly download words can call me, I have the latest bag, the canal port is 11111
Next, unzip the package

TAR-ZXVF canal.deployer-1.0.23.tar.gz Canal

To modify a configuration file:

Vim Canal/conf/example/instance.properties

Reference configuration:

#################################################
# # mysql serverid
canal.instance.mysql.slaveId = 1234

# position Info
canal.instance.master.address = 127.0.0.1:3306
canal.instance.master.journal.name = 
canal.instance.master.position = 
Canal.instance.master.timestamp = 

#canal. instance.standby.address = 
#canal. instance.standby.journal.name =
#canal. instance.standby.position = 
# Canal.instance.standby.timestamp = 

# username/password
canal.instance.dbUsername = Username
of your database Canal.instance.dbPassword = The password of your data
Canal.instance.defaultDatabaseName =
Canal.instance.connectionCharset = UTF-8

# table regex
Canal.instance.filter.regex =. *\\ ... *
# Table Black regex
Canal.instance.filter.black.regex =  

######################################### ########

Open the server side, here is a place to note that the general restart the MySQL service and restart the canal service side. The canal is mainly disguised as a slave to get the binlog of MySQL. CD to Bin directory open

./startup.sh  #开启
./stop.sh     #关闭

View the log CD below the Logs/canal directory

Tail-f Canal.log 
saw the content service opened #start the 
Canal server[ip:11111]
#the Canal server is running now ...

Remote access can telnet IP 11111 to view port conditions
Note: Check to see if your 11111 port is occupied with client (zues) deployment when opening the service

Development tools: Maven, rpm Download the latest code, and compiled into a package

Make Package
CD to target directory, install package

sudo rpm-ivh zues-1.0-snapshot[version number].noarch.rpm--nodeps--force
Install Client
Sudo/homes/zues/bin/zues start_xxx #XXX目前对panda和dolphin有配置
View Log

Tail-f/homes/zues/logs/zues.log