[Maria-discuss] logging original SQL statement along with ROW events
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
On 10 Jun 2017, at 02:05, Justin Swanhart <greenlion@gmail.com> 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
https://mariadb.com/kb/en/mariadb/annotate_rows_log_event/ On Fri, Jun 9, 2017 at 11:05 AM, Justin Swanhart <greenlion@gmail.com> 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
Thanks! On Jun 9, 2017 2:17 PM, "Pavel Ivanov" <pivanof@google.com> wrote:
https://mariadb.com/kb/en/mariadb/annotate_rows_log_event/
Hi,
I seem to recall reading that MariaDB can annotate the binary log with
On Fri, Jun 9, 2017 at 11:05 AM, Justin Swanhart <greenlion@gmail.com> wrote: 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
participants (3)
-
Colin Charles -
Justin Swanhart -
Pavel Ivanov