We have two hostgroups. One is doing RR for regular cluster operations. (Xtradb Cluster)
The second one is choosing the first available node of the cluster and redirecting all the traffic to this one. We need that for our migration scripts. Flyway locks a table row to make sure only one instance is migrating. This works very well.
The only problem is that PMM shows duplicate hosts because the HG filter isn’t applied to the “Endpoint Status” widget.
Configured like in the screenshot only 3 servers should be visible.