mysql.rds_skip_repl_error
Skips and deletes a replication error on a MySQL DB instance.
Syntax
CALL mysql.rds_skip_repl_error;
Usage notes
The master user must run the mysql.rds_skip_repl_error
procedure.
To determine if there are errors, run the MySQL show slave status\G
command. If a replication error isn't critical, you can run
mysql.rds_skip_repl_error to skip the error. If there are multiple
errors, mysql.rds_skip_repl_error deletes the first error, then warns
that others are present. You can then use show slave status\G to
determine the correct course of action for the next error. For information about the
values returned, see the MySQL documentation
For more information about addressing replication errors with Amazon RDS, see Troubleshooting a MySQL read replica problem.
If you try to call mysql.rds_skip_repl_error, you might encounter the following
error: ERROR 1305 (42000): PROCEDURE mysql.rds_skip_repl_error does not
exist. If you do, upgrade your MySQL DB instance to the latest minor
version or one of the minimum minor versions listed in this topic.
Replication stopped error
When you call the mysql.rds_skip_repl_error command, you might receive the following error message:
Slave is down or disabled.
This error message appears because replication has stopped and could not be restarted.
If you need to skip a large number of errors, the replication lag can increase
beyond the default retention period for binary log (binlog) files. In this case,
you might encounter a fatal error due to binlog files being purged before they
have been replayed on the read replica. This purge causes replication to stop,
and you can no longer call the mysql.rds_skip_repl_error command to
skip replication errors.
You can mitigate this issue by increasing the number of hours that binlog
files are retained on your source database instance. After you have increased the
binlog retention time, you can restart replication and call the
mysql.rds_skip_repl_error command as needed.
To set the binlog retention time, use the mysql.rds_set_configuration
procedure and specify a configuration parameter of 'binlog retention hours' along with the
number of hours to retain binlog files on the DB cluster. The following example sets
the retention period
for binlog files to 48 hours.
CALL mysql.rds_set_configuration('binlog retention hours', 48);
