Amazon Relational Database Service
User Guide (API Version 2014-10-31)

mysql.rds_skip_transaction_with_gtid

Skips replication of a transaction with the specified global transaction identifier (GTID) on a MySQL DB instance.

You can use this procedure for disaster recovery when a specific GTID transaction is known to cause a problem. Use this stored procedure to skip the problematic transaction. Examples of problematic transactions include transactions that disable replication, delete important data, or cause the DB instance to become unavailable.

Syntax

CALL mysql.rds_skip_transaction_with_gtid ( gtid_to_skip );

Parameters

gtid_to_skip

The GTID of the replication transaction to skip.

Usage Notes

The master user must run the mysql.rds_skip_transaction_with_gtid procedure.

On Amazon RDS MySQL 5.7, this procedure is supported for MySQL 5.7.23 and later. This procedure is not supported on Amazon RDS MySQL 5.6.

On this page: