Re: [Maria-discuss] logging original SQL statement along with ROW events

[Justin Swanhart]

Thanks!

On Jun 9, 2017 2:17 PM, "Pavel Ivanov"  wrote:

> https://mariadb.com/kb/en/mariadb/annotate_rows_log_event/
>
> On Fri, Jun 9, 2017 at 11:05 AM, Justin Swanhart 
> wrote:
> > Hi,
> >
> > I seem to recall reading that MariaDB can annotate the binary log with
> the
> > original SQL statement for a given set of ROW changes in the binary log,
> but
> > I can't seem to find documentation on this on the wiki.
> >
> > Can MariaDB log the original STATEMENT along with the ROW changeset?  If
> so,
> > can you point me to the relevant documentation, or better yet the patch
> > itself that makes this possible?
> >
> > Thanks,
> >
> > --Justin
> >
> > ___
> > 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
> >
>
___
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

Re: [Maria-discuss] logging original SQL statement along with ROW events

[Colin Charles]

> On 10 Jun 2017, at 02:05, Justin Swanhart  wrote:
> 
> I seem to recall reading that MariaDB can annotate the binary log with the 
> original SQL statement for a given set of ROW changes in the binary log, but 
> I can't seem to find documentation on this on the wiki.
> 
> Can MariaDB log the original STATEMENT along with the ROW changeset?  If so, 
> can you point me to the relevant documentation, or better yet the patch 
> itself that makes this possible?
> 

Is this what you were after? 
https://mariadb.com/kb/en/mariadb/annotate_rows_log_event/

--
Colin Charles, http://bytebot.net/blog/
twitter: @bytebot | skype: colincharles
"First they ignore you, then they laugh at you, then they fight you, then you 
win." -- Mohandas Gandhi


___
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

Re: [Maria-discuss] logging original SQL statement along with ROW events

[Pavel Ivanov]

https://mariadb.com/kb/en/mariadb/annotate_rows_log_event/

On Fri, Jun 9, 2017 at 11:05 AM, Justin Swanhart  wrote:
> Hi,
>
> I seem to recall reading that MariaDB can annotate the binary log with the
> original SQL statement for a given set of ROW changes in the binary log, but
> I can't seem to find documentation on this on the wiki.
>
> Can MariaDB log the original STATEMENT along with the ROW changeset?  If so,
> can you point me to the relevant documentation, or better yet the patch
> itself that makes this possible?
>
> Thanks,
>
> --Justin
>
> ___
> 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
>

___
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

[Maria-discuss] logging original SQL statement along with ROW events

[Justin Swanhart]

Hi,

I seem to recall reading that MariaDB can annotate the binary log with the
original SQL statement for a given set of ROW changes in the binary log,
but I can't seem to find documentation on this on the wiki.

Can MariaDB log the original STATEMENT along with the ROW changeset?  If
so, can you point me to the relevant documentation, or better yet the patch
itself that makes this possible?

Thanks,

--Justin
___
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