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.

nn

CALL mysql.rds_reset_external_master;n

nn

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.

nn

### Tags

nn

    n

  • mysql
  • n

  • rds
  • n

  • replication
  • n

  • mariadb
  • n

  • aws
  • n

n

Proudly powered by WordPress

Discover more from Dedunu

Subscribe now to keep reading and get access to the full archive.

Continue reading