1 Answer
- Newest
- Most votes
- Most comments
2
I believe, certain parameters were deprecated from 10.11 in MariaDB. As rightly mentioned by you, in order to retain the binary logs, it is required to call a stored procedure that will allow you to set up retention period in hours.
Below is the command :
call mysql.rds_set_configuration('binlog retention hours', 48);
This will help you retain the binlogs for 48 hours.
To see the value set you can run the following command:
CALL mysql.rds_show_configuration;
Some references:
mysql.rds_set_configuration - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/mysql_rds_set_configuration.html Accessing MySQL binary logs - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.MySQL.Binarylog.html
Relevant content
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 5 months ago
- AWS OFFICIALUpdated 5 months ago
I guess I need to run
call mysql.rds_set_configuration('binlog retention hours', 24 * 7);
?