v.22.11Experimental Feature

Ignore MySQL Binlog SAVEPOINT Events in MaterializedMySQL

Ignore MySQL binlog SAVEPOINT event for MaterializedMySQL. #42931 (zzsmdfj). Handle (ignore) SAVEPOINT queries in MaterializedMySQL. #43086 (Stig Bakken).
MaterializedMySQL engine now ignores MySQL binlog SAVEPOINT events during replication.

Why it matters

This feature addresses issues caused by MySQL SAVEPOINT statements in binlog events that the MaterializedMySQL engine previously did not handle properly. By ignoring SAVEPOINT events, replication becomes more stable and consistent, eliminating errors related to savepoints and improving compatibility with MySQL replication.

How to use it

No explicit user action is required; the MaterializedMySQL engine automatically ignores SAVEPOINT events from MySQL binlogs starting from this update.