Set skip-name-resolve=1 in my.cnf

Jesse Distad

• March 23, 2019 13:11

I'm in the process of optimizing mysql on a new server and one of the recommendations is to set skip-name-resolve=1 I have read in multiple places that doing so has caused issues on cPanel servers but those reports are not all that current, I'd like a definitive answer if this can be done without issue. I currently have bind_address set to 127.0.0.1 Will setting skip-name-resolve=1 affect accounts that have localhost set for their database connection? thanks in advance

• 

  GOT

  • March 23, 2019 20:41

  It does not break localhost connections. I have seen errors in the backup logs with this on though but I do not believe it's actually affecting backups. But to be Frank I have not experimented much on it. Cpanel official might have more info.

  0
• 

  Jesse Distad

  • March 24, 2019 13:14

  Thanks for the feedback.. Maybe there will be someone by to reply now that the weekend is over, eventually, hopefully :D

  0
• 

  cPanelLauren

  • March 26, 2019 20:06

  Skip name resolve can cause issues on cPanel servers and the benefit isn't necessarily notable. The backup errors I've not seen but we do recommend adding this to the MySQL configuration at your own discretion, it's not recommended.

  0

Please sign in to leave a comment.