- 最新
- 投票最多
- 评论最多
Hi Jeff,
In the event that this is still a pending issue, I suspect your error may be related to the MySQL server system variable "skip_name_resolve". With "skip_name_resolve" disabled, any temporary DNS issues can lead to sporadic connection errors like you are seeing.
There also appears to be additional security benefits to enabling this server variable. The following links address both why this should resolve your issue and the security benefits of it (Note: I did not write this content and I don't guarantee that it is AWS or Lightsail specific).
https://serverfault.com/questions/393862/mysql-warning-ip-address-could-not-be-resolved
https://www.percona.com/blog/2008/05/31/dns-achilles-heel-mysql-installation/
https://nixcp.com/skip-name-resolve/
I see you're already familiar with modifying Lightsail database parameters, but here is the documentation for doing so if needed.
https://lightsail.aws.amazon.com/ls/docs/en_us/articles/amazon-lightsail-updating-database-parameters
Regards,
Eric B
相关内容
- AWS 官方已更新 2 年前
- AWS 官方已更新 9 个月前