expire_logs_days does not exists in MariaDB 10.11 Parameter group

0

For some reasons I need to set expire_logs_days to 7 days. However I found expire_logs_days does not exist in MariaDB 10.11 Parameter group.

  • I guess I need to run call mysql.rds_set_configuration('binlog retention hours', 24 * 7);?

Tom Lo
asked 25 days ago38 views
1 Answer
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

profile pictureAWS
EXPERT
answered 25 days ago
profile picture
EXPERT
reviewed 25 days ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions