Allow binlog_row_metadata to be adjusted
In order to synchronize MySQL to Snowflake, binlogs need to be synced. Due to MySQL limitations, the binlog order is changed after a maintenance update or failover causes a node to be replaced.
One way this can be avoided is with third-party tools like Snowflake's SQL agent. However, this requires "binlogrowmetadata" to be set to "FULL". This is not currently possible on the platform.
1
vote
AdminPeter Thomas
(Technical Support Engineer, Aiven.io)
shared this idea