Details
-
Task
-
Status: Closed (View Workflow)
-
Trivial
-
Resolution: Won't Do
-
2.1.17
-
None
-
centos 6
Description
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 ?