Bug #68547 Remote Binlog Back-up should save binlog file along with position no.
Submitted: 2 Mar 2013 10:08 Modified: 2 Mar 2013 10:31
Reporter: rajnish kumar Email Updates:
Status: Open Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version:5.6 OS:Any
Assigned to: CPU Architecture:Any
Tags: Remote Binlog Back-up need improvement for saving its current binlog file name a

[2 Mar 2013 10:08] rajnish kumar
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
[2 Mar 2013 10:30] rajnish kumar
sorry OS should be ALL
[2 Mar 2013 10:31] rajnish kumar
OS should be ALL