We have recently introduced proxysql 2.x for loadbalancing a galera cluster in production environment. It is working great so far.
I have been tasked to separate staging cluster which is currently in same production instance.
Can I use the same proxysql instance to load balance staging cluster to avoid redundancy ?
I am bit hesitant at the same time considering proxysql 2.x does not really know anything about the cluster.
Has anyone of you used the same proxysql 2.x instance for multiple clusters? Are there any risks?