mysql5.6 and MARIADB remote pull binary logs

Support remote pull binary log from mysql5.6

Mysqlbinlog--raw--stop-never--result-file=/tmp/log/--read-from-remote-server-h 192.168.10.17-p 3306-u liuwei-p123 456 mysql-bin.000475

Option Description:

-H--host: IP address of the remote host

-P--port: Port of the remote host

-U--user: User of remote database

-P--password: Password for remote database user

--raw: Pull the binary log to the disk as a record

--stop-never: Non-disruptive replication of binary logs to local

--result-file: The binary log that is pulled is in the local location, and must end with a '/' at the end of the directory.

-R--read-from-remote-server: Plus this option means getting logs from a remote host

mysql-bin.000475: Which binary log from the remote host starts to pull, this file must exist, or it will be an error

This article is from the "burning Years of Passion" blog, please be sure to keep this source http://liuzhengwei521.blog.51cto.com/4855442/1882182

mysql5.6 and MARIADB remote pull binary logs