proxysql does not refresh dns records

sysown / proxysql

High-performance MySQL proxy with a GPL license.

http://www.proxysql.com

GNU General Public License v3.0

5.98k stars 974 forks source link

proxysql does not refresh dns records #3255

Open barakseri1 opened 3 years ago

barakseri1 commented 3 years ago

version: ProxySQL version 2.0.10-27-g5b319972, codename Truls

My SQL backend servers are configured with dns names. After updating the dns values (with low ttl), proxysql did not take the updated value only until it was restarted

Is there a way to refresh its dns cache without a restart?

yakirgb commented 3 years ago

~ProxySQL doesn't not keep DNS cache, but maybe you didn't kill active connections that was on old dns record.~ ~Next time, try to close connection before dns change:~ ~1. Change MySQL server to OFFLINE_HARD~ ~2. Change DNS~ ~3. Change MySQL server to ONLINE~

barakseri1 commented 3 years ago

Thanks Yakir, I'll give it a try

pipozzz commented 1 year ago

is it possible to fix this with proxysql dns cache feature ?