SQL boxes each have 2 NICs, one attached to a private switch on a network like ‘10.%’, with the other NIC configured for a public IP on another network. ProxySQL boxes have public IPs but are not attached to that switch.
proxysql-admin configures users like ‘proxysql_monitor’@‘10.%’ but of course those don’t work, because it needs to connect using the public IP not the internal cluster switch.
Is there any way to get ProxySQL / proxysql-admin to work with this configuration? Seems like this would be the preferred method for a cluster, no?