patternsqlMinor
What is default MySQL binlog retention in AWS RDS?
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
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:
Will cause the binlogs to be stored for 24 hours, for example.
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.