Sample Header Ad - 728x90

Aurora MySQL: how do I keep binlogs around after reboot?

1 vote
1 answer
722 views
We have a request to enable binlogs on an Aurora MySQL instance and to keep those logs around for a certain amount of time. To test, we enabled binlogging with binlog_format=ROW and set our retention time to 1 hour.
call mysql.rds_set_configuration('binlog retention hours', 1);
However, we are seeing inconsistent behavior when we reboot the instance. A new binlog gets created and the old one *sometimes* drops after only a couple of minutes. It was my understanding that setting the retention hours would keep the old file(s) around for an hour. There is also the global config expire_logs_days=0, would that affect keeping the old file(s) around?
Asked by Nate H (31 rep)
Aug 18, 2021, 04:23 PM
Last activity: Apr 16, 2025, 07:01 PM