I faced a problem when I use MHA in multi-instance environment as follows.
server1:3306 in app1
server1:3307 in app2
if manager for app1 and manager for app2 execute at the same time, apply_diff_relay_logs script will use a single workfile.
I added port number in workfile name to solve this problem.
I faced a problem when I use MHA in multi-instance environment as follows.
server1:3306 in app1 server1:3307 in app2
if manager for app1 and manager for app2 execute at the same time, apply_diff_relay_logs script will use a single workfile. I added port number in workfile name to solve this problem.