Sample Header Ad - 728x90

Is there a way to set different destination order with mysql-router?

0 votes
1 answer
244 views
I have innodb cluster setup with 3 mysql instances. Each instance is on different server and each server has mysql-router also. I would like each mysql-router on each server to try to connect to the mysql instance on the same server. Is this possible? Currently all mysql-router will check the "destinations=metadata-cache://mycluster/default?role=PRIMARY" option and try to connect to the top server. Is there a way so each mysql-router trys to first try to connect to different instances? (the instance on the same server as mysql-router)
Asked by Ken (21 rep)
Jun 26, 2020, 01:58 PM
Last activity: Jun 26, 2020, 02:21 PM