It is possible in low write databases; such as development or test databases; that log files will not fill up to rotate before the log retention setting. This will break the pipeline. For these databases, please execute the following to rotate the logs every 24 hours.
Copy
Ask AI
-- Execute the following SQL statement to turn on the event scheduler.SET GLOBAL event_scheduler = ON;--Create a custom event that rotates (flushes) the binary logs every 24 hoursDROP EVENT IF EXISTS rotate_binlog_24_hrs_event;CREATE EVENT streamkap_rotate_binlog_24_hrs_event ON SCHEDULE EVERY 24 hourDO FLUSH BINARY LOGS;