SQL Router Not Applying Round Rubin
0
votes
1
answer
56
views
I configure sql router under three machines and found if I use simple command
mysql -u ia -pTest@123 --port=7001
then its not applying round rubin connection request but when i use with protocol parameter then its working fine "mysql -u ia -pTest@123 --port=7001 --protocol=TCP"
I want to connect with normal command like mysql -u ia -pTest@123 --port=7001
and round rubin should work in this case.
=== Mysql Configuration
[logger]
level = INFO
[routing:secondary]
bind_address = localhost
bind_port = 7001
destinations = 192.168.0.187:3306,192.168.0.190:3306
routing_strategy = round-robin
[routing:primary]
bind_address = localhost
bind_port = 7002
destinations = 192.168.0.186:3306
routing_strategy = first-available (edited)
Asked by irfan_db
(11 rep)
Apr 3, 2020, 01:00 PM
Last activity: Apr 3, 2020, 02:29 PM
Last activity: Apr 3, 2020, 02:29 PM