mha4mysql-manager icon indicating copy to clipboard operation
mha4mysql-manager copied to clipboard

Add command line option to check for errant transaction

Open LaurentKol opened this issue 6 years ago • 0 comments

This errant transactions check is only performed if --check_for_errant_transactions is present on masterha_master_switch command line, default behavior is unchanged.

If errant transactions are found, switch-over is aborted during Phase 1 (Configuration Check Phase) and a fix is suggested using mysqlslavetrx.

This is to prevent switch-over to get stuck after the CHANGE MASTER statement with replication error 1236.

LaurentKol avatar Jun 04 '18 06:06 LaurentKol