Specifies the number of hours to retain binary logs.
The name of the configuration parameter to set.
The value of the configuration parameter.
mysql.rds_set_configuration procedure currently supports only the
binlog retention hours configuration parameter.
binlog retention hours parameter is used to specify the number of hours to retain binary log files.
Amazon RDS normally purges a binary log as soon as possible, but the binary log might still be required for replication
with a MySQL database external to Amazon RDS. The default value of
binlog retention hours is NULL (do not retain binary logs).
To specify the number of hours for Amazon RDS to retain binary logs on a DB instance, use the
stored procedure and specify a period with enough time for replication to occur, as shown in the following example.
call mysql.rds_set_configuration('binlog retention hours', 24);
For MySQL DB instances, the maximum
binlog retention hours value is 168 (7 days). For Amazon Aurora
DB instances, the maximum is 720 (30 days).
After you set the retention period, monitor storage usage for the DB instance to ensure that the retained binary logs don't take up too much storage.
mysql.rds_set_configuration is available in these versions of
Amazon RDS MySQL: