Configuring - Amazon Aurora
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).


The following stored procedures set and show configuration parameters, such as for binary log file retention.


Specifies the number of hours to retain binary logs or the number of seconds to delay replication.


CALL mysql.rds_set_configuration(name,value);



The name of the configuration parameter to set.


The value of the configuration parameter.

Usage notes

The mysql.rds_set_configuration procedure supports the following configuration parameters:

The configuration parameters are stored permanently and survive any DB instance reboot or failover.

binlog retention hours

The binlog retention hours parameter is used to specify the number of hours to retain binary log files. Amazon Aurora 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 Aurora.

The default value of binlog retention hours is NULL. For Aurora MySQL, NULL means binary logs are cleaned up lazily. Aurora MySQL binary logs might remain in the system for a certain period, which is usually not longer than a day.

To specify the number of hours to retain binary logs on a DB cluster, use the mysql.rds_set_configuration 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);


You can't use the value 0 for binlog retention hours.

For Aurora MySQL version 2.11.0 and higher and version 3 DB clusters, the maximum binlog retention hours value is 2160 (90 days).

After you set the retention period, monitor storage usage for the DB instance to make sure that the retained binary logs don't take up too much storage.


The number of hours that binary logs are retained.


CALL mysql.rds_show_configuration;

Usage notes

To verify the number of hours that Amazon RDS retains binary logs, use the mysql.rds_show_configuration stored procedure.


The following example displays the retention period:

call mysql.rds_show_configuration; name value description binlog retention hours 24 binlog retention hours specifies the duration in hours before binary logs are automatically deleted.