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 <dbmsp...@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 <piva...@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 <dbmsp...@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 _______________________________________________ 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
