How to get a list of IPs from which connections to the database are made?

Question

linux

Hello colleagues! There is a base that is accessed by many services (Percona Xtradb + Galera cluster, connection via maxscale). You need to get a list of unique IPs that connect to the database during, for example, a day. The main condition is to do without restarting both mysql and maxscale.

Answer 1

1. the list can be obtained in real time via netstat
2. you can enable log by port in iptables

Answer 2

host where your base ass looks out to the world?