MySQL Serverconnection closed by foreign host. Problem solving

Issue background:

Yesterday should apply the demand, designed to build a set of Percona database with TOKUDB storage engine, using common dual-master architecture. The specific architecture is as follows:

The architecture process is smooth, but the following problem occurs when validating on 172.20.32.x1:

Fhost ' 172.20.32.216 ' is not a allowed to connect to this MySQL serverconnection closed by foreign host.

Troubleshoot the problem:

The first reaction is: whether it is a network-level problem

A. See if the ping Pass

B. Look at the state of the firewall

C. View IP information

The conclusion is: The network is fine.

The second reaction is: do not have the corresponding host information does not add IP trust

As shown, 172.20.32.216 is not in the host column. I was on the 172.20.32.61 telnet 172.20.32.216 3306, the database does not recognize my actual ip172.20.32.61 and only recognize my VIP172.20.32.216, although my actual IP has been added to the trust but the virtual IP is not in the list, resulting in the above problems.

Solution:

To add a VIP to the trusted hosts list

| GRANT USAGE on *. Zabbix ' @ ' 172.20.32.216 ' identified by PASSWORD ' *befa76037a38eb65db0589ad6b5c8bf6a596f7d0 ' |
| GRANT all Privileges "Zabbix". * to ' Zabbix ' @ ' 172.20.32.216 '

MySQL Serverconnection closed by foreign host. Problem solving