MySQL Forums
Forum List  »  Router & Proxy

mysqlrouter 8.0.29 next-available config
Posted by: lorenzo tombini
Date: July 18, 2022 07:12AM

Hi all,
I'm testing mysqlrouter for master/replica environment in ubuntu 20.04 using mysql community packages, but there is something I can'tunderstand about routing_strategy.
This is my routing conf

[routing:MasterReplica]
bind_address = 127.0.0.1
bind_port = 3306
destinations = 192.168.1.181:3306,192.168.1.181:3406
routing_strategy = next-available

I've 2 mysqld instances on same machine.

Reading docs "next-available" means that when a server is unreacheable is marked as unreachable then it gets discarded and is never used again as a destination till mysqlrouter restart.

In my case when I raise up the instance gone dow, the logs show that the server is remouved from quarantine.

"2022-07-18 14:54:02.785 routing DEBUG [7fd09feab700] Destination candidate '192.168.1.181:3306' is available, remove it from quarantine"

Could someone help me to understand which is my fault?

Thanks a lot in advanced



Edited 1 time(s). Last edit at 07/18/2022 07:19AM by lorenzo tombini.

Options: ReplyQuote


Subject
Views
Written By
Posted
mysqlrouter 8.0.29 next-available config
46
July 18, 2022 07:12AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.