Solve the problem of slow remote connection between MySQL and vsftp

For CentOS 6.3 (similar to other operating systems, same applies) Description:

When our services are configured properly, there are times when the connection is slow and the connection fails

Problem Analysis: These situations are usually DNS parsing.

MySQL Connection slow resolution:

To modify MY.CNF, add the following sentence in [mysqld]

Skip-name-resolve

Restart MySQL (#service mysql restart or/etc/init.d/mysql restart) to solve the problem.

Note: In this case, the program can not use localhost, can only use 127.0.0.1 or real IP address.


Vsftp Slow Connection Speed resolution:

Modify Vsftpd.conf, add the following sentence

Reverse_lookup_enable=no

Restart VSFTPD (#service vsftpd restart or/etc/init.d/vsftpd restart), problem solved.


Tip: You can view the default configuration of vsftp in detail by #man the 5 vsftpd.conf command