Dynamic adding ip from mysql to upstream nginx?

Question

MySQL

Good afternoon.
Got a question. It is necessary to dynamically add ip addresses from the musol to nginx, check every 15 minutes of the database.
Option 2. Govnokod, writing from the database to the ipshek file and a script that will pull the file.
The second option - advised to look towards lua. I am not familiar with this programming language at all, so I wanted to ask, did someone do something similar?
Thank you.

Answer 1

If you want dynamic upstreams, buy NGINX Plus.
https://docs.nginx.com/nginx/admin-guide/load-bala...
In open source, only editing the config with a restart. Or collective hosting with upstream domain names with rotation at the DNS server level