Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/mysql-stored-proc-configuring.html below:

Setting and showing binary log configuration

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);

name

The name of the configuration parameter to set.

value

The value of the configuration parameter.

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.

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;

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.

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4