Sup, team! I have just a question about priority of servers with weight. For ex. i have config:

# servers

[ss_1]

type=server

address=mysql-ss-1.fr.local

port=3306

protocol=MySQLBackend

s_weight=0

[ss_2]

type=server

address=mysql-ss-2.fr.local

port=3306

protocol=MySQLBackend

s_weight=0

[ss_3]

type=server

address=mysql-ss-3.fr.local

port=3306

protocol=MySQLBackend

s_weight=0

[ss_4]

type=server

address=mysql-ss-4.fr.local

port=3306

protocol=MySQLBackend

s_weight=0

[ss_5]

type=server

address=mysql-ss-1.ms.local

port=3306

protocol=MySQLBackend

s_weight=1

[ss_6]

type=server

address=mysql-ss-2.ms.local

port=3306

protocol=MySQLBackend

s_weight=1

[ss_7]

type=server

address=mysql-ss-1.al.local

port=3306

protocol=MySQLBackend

s_weight=110

where ~99% of connections will be routed to mysql-ss-1.al.local and ~1% to mysql-ss-1.ms.local and mysql-ss-2.ms.local . When mysql-ss-1.al.local will be down, all of connections will be routed to mysql-ss-1.ms.local and mysql-ss-2.ms.local , and when they will be down too, all connections will be routed to other servers with weight 0. But what i should set to s_weight param, if i want to route 100% of connections to mysql-ss-1.al.local , then if it will be down, i want to route 100% of connections to mysql-ss-1.ms.local and mysql-ss-2.ms.local , and then if they will be down too, route 100% of connections to other servers ?