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.

This procedure is supported for all RDS for MySQL 5.7 versions, and RDS for MySQL 8.0.26 and higher 8.0 versions.