Balancing proxysql rules

[Kim_Van_Holderbeke]

Hello,

I’m using proxysql version 2.4.8-2-g2cc900a.

I’m using following setup

I did this to create a rule for a specific user that need always to run on the secondary database that is sstdba21.

The rule is

I’m wondering there is a way to define that this rule need to run to hostgroup 1 when server in hostgroup 3 isn’t available.

kind regards
Kim

[matthewb]

hostgroup 3 should always be available. You should fix mysql_servers so that all your potential hosts that receive reads are in there. Use ‘weight’ to focus traffic to your reader. server3 weight 1000, server2 weight 1000, server1 weight 1. That will split reads 50/50-ish between servers 3 & 2, and might send 0.01% of reads to server1, unless both 3 & 2 are down, then server1 gets it all.