Mariadb database, use the actual IP (10.0.1.155) can remote login, but using VIP (10.0.1.154) cannot log in, this is what reason, please comment, thank you!

CodePudding user response:

Can 't connect to MySQL server on' 10.0.1.154 '" Connection refused "(111)

CodePudding user response:

Make sure your VIP is available, you can use the PING test
Confirm your MySQL port with VIP, that can be connected with Telnet test

CodePudding user response:

The VIP can be ping, but is unable to connect:
/root @ ctl2m ~ # Telnet 10.0.1.154 3306
Trying 10.0.1.154...
Telnet: connect to address 10.0.1.154: Connection refused
/root @ ctl2m ~ # Telnet 10.0.1.155 3306
Trying 10.0.1.155...
Connected to 10.0.1.155.
The Escape character is' ^].
Y
5.5.5-10.1.19 - MariaDBU)] zm4 [% L? Ptwvk6k7pQ bmysql_native_password

! # 8 s01got packets out of orderConnection closed by foreign host.