How to reset replication in MySQL/MariaDB RDS?

RESET SLAVE; doesn’t work in AWS MySQL RDS. You should use the below command to stop replication.

CALL mysql.rds_reset_external_master;

You will see something like an error message. You can safely ignore that. Try SLAVE STATUS\G. If you get an empty set, your instance has successfully reset the replication.

· mysql, rds, replication, mariadb, aws