My infrastructure group really wants to use DHCP (no reservation) for some new DB servers we are nearly ready to deploy (MySQL 8) and we use a single replication server. Looking around I do not see that DHCP is recommended - just looking for confirmation that this is the case.
Hey there @Alexk1,
The problem with DHCP on your database is how will applications learn the new IP when it changes? Your infra team might say “use dns” but that can be unreliable, and is itself prone to performance issues because every connection and privilege check must incur a DNS lookup. If DNS blips, or goes down, apps can no longer connect, and MySQL might timeout connection attempts while waiting for DNS response.
I would recommend to your infra team that dynamic IPs be used on dynamic/stateless systems (like app servers), and use static IPs for static/stateful services like databases.
Thank you - I am meeting with them tomorrow and needed a outside opinion. Very helpful.