In this post ,we mainly talk about MHA GTID behavior, we test different cases and find something is different from previous versions .
we have four machines for this test.
master server: 10.0.128.77 slave server : 10.0.128.110/113/114 port : 3306
we first do normal failover .
kill master server
we find MHA outputs:
Tue Dec 30 13:32:14 2014 - [warning] Got error on MySQL connect ping: DBI connect(';host=10.0.128.77;port=3306;mysql_connect_timeout=1','dbadmin',...) failed: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 at /usr/share/perl5/vendor_perl/MHA/HealthCheck.pm line 97 2013 (Lost connection to MySQL server at 'reading initial communication packet', system error: 111) Tue Dec 30 13:32:14 2014 - [info] Executing secondary network check …[Read more]