MySQL Forums
Forum List  »  Utilities

Fabric - Lazy way to fix FAULTY node in DEV environment
Posted by: Vincent Poore
Date: December 05, 2016 05:39PM

In a dev environment where the time to simply restore the full database to the slave is shorter than the expected time to investigate the cause, what are the recommended mysqlfabric commands?

The following works for me, but is there a better procedure?

1) Remove faulty server from group with "mysqlfabric group remove"
2) Restore faulty server with "mysqlfabric server clone"'
2a) Run "FLUSH PRIVILEGES" in slave. (I should probably log an enhancement to include --flush-privileges in the mysqldump executed by the clone command)
3) Re-add server to group with "mysqlfabric group add"

Options: ReplyQuote

Written By
Fabric - Lazy way to fix FAULTY node in DEV environment
December 05, 2016 05:39PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.