[MDEV-32674] Extend mariadb-binlog with Scripting Support Created: 2023-11-03  Updated: 2024-02-06

Status: Open
Project: MariaDB Server
Component/s: Replication, Scripts & Clients
Fix Version/s: 11.5

Type: Task Priority: Major
Reporter: Brandon Nesterenko Assignee: Brandon Nesterenko
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-26982 Create a template script to collect s... Open

 Description   

Where mariadb-binlog unparses a binary log into its executable (and readable) transactions, there are many different use cases in which these can be replayed or analyzed. A few examples apart from normal transaction replay are 1) the --flashback option to play transactions backwards and reset replication state, 2) MDEV-26982, which proposes a configurable way to collect statistics about the events during replay, and 3) a proposed ability to estimate an initial data state of an arbitrary binary log, so the binary log can be replayed for debugging/profiling purposes.

To help facilitate for the wide-range of use cases in transaction analysis and replay, mariadb-binlog could be extended to call a script so users could utilize the parsing of mariadb-binlog, but add on their own functionality. One potential implementation could be an embedded Python API, where mariadb-binlog provides hooks to invoke after it parses an event, with specific functions to override for custom analysis.

We could also provide a few simple scripts for some common use cases, which could be designed for users to extend.


Generated at Thu Feb 08 10:33:08 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.