Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MHA should support RESET SLAVE ALL in MySQL 5.5.16+ #12

Closed
yoshinorim opened this issue Sep 23, 2011 · 2 comments
Closed

MHA should support RESET SLAVE ALL in MySQL 5.5.16+ #12

yoshinorim opened this issue Sep 23, 2011 · 2 comments

Comments

@yoshinorim
Copy link
Owner

Originally reported from Joffrey Michaie -- Thanks!

Starting with MySQL 5.5, reset slave does not loose the replication user and replication password, it just removes the replication position.
As you can imagine this is really dangerous, if the end-user does a "start slave" on the new master, this can be a disaster !

The behavior was changed in MySQL 5.1 :
http://dev.mysql.com/doc/refman/5.5/en/reset-slave.html

Starting from MySQL 5.5.16, RESET SLAVE ALL was introduced. MHA should be aware of this command.

@yoshinorim
Copy link
Owner Author

Fix: 4cee0be

@yoshinorim
Copy link
Owner Author

5.0 and 5.1 fix: d64c44f

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant