I guess you can do it like that, yes. I wonder what do you need it for though. On Thu, Nov 17, 2016 at 9:45 PM, Ljr Yang <dbmsprog@gmail.com> wrote:

Thank you.

innobackup backup info on slave: #cat xtrabackup_binlog_info mysql-bin.000003 83882214 0-118-60061898358

Only filter GTID 0-118-60061898358 in all binlog file of slave ?

mysqlbinlog -vv mysqbin.000001 | grep -B5 "0-118-60061898358" mysqlbinlog -vv mysqbin.000002 | grep -B5 "0-118-60061898358" ........

2016-11-18 13:24 GMT+08:00 Pavel Ivanov <pivanof@google.com>:

...

There is no way to find corresponding binlog file and position on the slave. You should use GTIDs to find corresponding binlog positions.

On Thu, Nov 17, 2016 at 7:19 PM, Ljr Yang <dbmsprog@gmail.com> wrote:

...

Hi, we config master slave and set log_slave_updates = 1 on slave. on master server‘s binlog file and pos , example: mysql-bin.000005 2036891 , how could quick find corresponding binlog file and pos on slave? Thanks.

-- Ljr

_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

-- Ljr