Sample Header Ad - 728x90

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