SQL Router Not Applying Round Rubin

Question

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)

score 0 · Answer 1 · answered Apr 03 '20 at 14:29

Every connection has a -h 127.0.0.1 or as you have a --protocol=TCP" on local computers to use round-Robin.

The problem is on linux computers mysql tries to open a socket connection, where you can' use Roud-Robin.

The same is true for Windows computers, but there mysql uses named pipes

so you have to force the connection to use tcp/ip, that works with an ipadress in -h or like you used forcing the protocol

SQL Router Not Applying Round Rubin

1 Answers1