HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

What is default MySQL binlog retention in AWS RDS?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
retentionwhatdefaultmysqlawsrdsbinlog

Problem

I tried to retrieve my MySQL RDS binlogs in order to run manual "rollback" for some SQLs.
Unfortunately, I noticed that only 2 binlogs for the last 30 minutes are available.

"call mysql.rds_show_configuration" provides "binlog retention hours | NULL".

I guess (because RDS provides ability to point-in-time restore between daily backups) that AWS RDS keeps its binlogs for 24 hours. But it seems that it's unavailable for the end user...

TIA,
Vitay

Solution

You need to give it a value if you wish to preserve the binlogs:

call mysql.rds_set_configuration('binlog retention hours', 24);


Will cause the binlogs to be stored for 24 hours, for example.

Code Snippets

call mysql.rds_set_configuration('binlog retention hours', 24);

Context

StackExchange Database Administrators Q#68272, answer score: 9

Revisions (0)

No revisions yet.