Description:
Hi Team,
Mysql 5.6 have a lots of improvement especially in replication and Remote Binlog Back-up (New Features ).
Is there is any way in which mysqlbinlog note down the current binary log file name and its position number ,when we are using it with raw options for remote binary log storing.
I means when we are using mysqlbinlog with raw and stop never option to continuous copy of bin log to a remote server , and due to some network issue or some error or restart mysql db server ,how we can start our binlog sync process.
currently I am manually doing it by seeing binlog file name and match with master Db server .
Is there is any way so that mysqlbinlog automatically wrote binlog file name and position like master.info file in replication process .
How to repeat:
using below command we start remote bin log sync
mysqlbinlog --read-from-remote-server --host <hostname/ip- addess> -u<username> -p --raw --stop-never <binlogfilename>
due to some error/network issue or restart main MySQL DB server , how we resume our syncing process .
Suggested fix:
Hi team ,
can mysqlbinlog create a simple text file (assume rbinsync.txt) like master.info in replication process,so that text file can store simple master node hostname/ip ,username ,password along with binary log file name and position which they are already synced it, so that when any issue or error occur in syncing and we are going to start again sync process mysqlbinlog will automatically fetch all required details and start sync after that position .
when we run mysqlbnlog it will check whether text file (assume rbinsync.txt) is exist or not if it is not present it means we are running mysqlbinlog first time so that time we have to passed all parameters and their values like [mysqlbinlog --read-from-remote-server --host <hostname/ip- addess> -u<username> -p --raw --stop-never <binlogfilename>]
,after that mysqlbinlog create a text file (assume rbinsync.txt) and stored all information for resume capabilities .when we again start mysqlbinlog it will check text file exist so it will read all information from there and also overwrite command line values .
--
Note :
1. mysqlbinlog always looking a text file (assume rbinsync.txt) when we using it --read-from-remote-server options.
2. the text file (assume rbinsync.txt) always contains below details
hostname/ip- address , username ,password ,binlog filename ,binlog position
