maria-discuss team mailing list archive

[Pavel Ivanov <pivanof@xxxxxxxxxx>]

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@xxxxxxxxx> 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@xxxxxxxxxx>:
>>
>> 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@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>> > Unsubscribe : https://launchpad.net/~maria-discuss
>> > More help   : https://help.launchpad.net/ListHelp
>> >
>
>
>
>
> --
> Ljr