AWS Documentation » Amazon Relational Database Service (RDS) » User Guide » MySQL on Amazon RDS » MySQL on Amazon RDS SQL Reference » mysql.rds_set_master_auto_position

mysql.rds_set_master_auto_position

Sets the replication mode to be based on either binary log file positions or on global transaction identifiers (GTIDs).

Syntax

CALL mysql.rds_set_master_auto_position (
auto_position_mode
);

Parameters

auto_position_mode

A value that indicates whether to use log file position replication or GTID-based replication:

• 0 – Use the replication method based on binary log file position. The default is 0.

• 1 – Use the GTID-based replication method.

Usage Notes

The master user must run the mysql.rds_set_master_auto_position procedure.

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