mysql.rds_set_master_auto_position - Amazon Relational Database Service


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


CALL mysql.rds_set_master_auto_position ( 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 RDS for MySQL 5.7, this procedure is supported for MySQL 5.7.23 and later MySQL 5.7 versions. This procedure is not supported for RDS for MySQL 5.6 or 8.0.