Questions tagged [mysqlrouter]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
88 views

How to increase mysql_connect_error on mysqlrouter?

I have an problem with mysqlrouter. I try to increase the max_connect_errors variable on mysqlrouter but is still value 100 in the file log. 2021-03-02 14:30:59 routing INFO [7f31a73f3700] [routing:...
0
votes
0answers
32 views

Whether can mysql router connects to several MySQL InnoDB CLuster?

As suggested by MySQL, we can install MySQL Router service on application server.But how to configure the MySQL Router service when it needs to connect to several MySQL InnoDB Cluster? For example, we ...
0
votes
0answers
23 views

MySQL router making mysql general log not useful

I am running MySQL 5.7 on a 3 node cluster using InnodBCluster. It is making the user of the general_log quite challenging. The mysqlrouter check ins are being logged in the mysql general_log. These ...
0
votes
0answers
50 views

MySQL Router failing with "write error: Resource Temporarily Unavailable"

I have been using MySQL Router for the past few months without any issues, but I just ran apt-get upgrade on my Linux server, and mysql-router was upgraded from version 8.0.21 up to 8.0.22. Since then,...
1
vote
0answers
92 views

MySQL router on server with tomcat memory leak

Memory is slowly used by mysql router. I am running mysql router version 8.0.20 (I found there was a memory leak on mysql router 2.1.2 but mysql router 8.x is newer) I have a 3 node single-primary ...
0
votes
1answer
18 views

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

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 ...
0
votes
1answer
22 views

SQL Router Not Applying Round Rubin

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 ...
0
votes
1answer
449 views

How to configure MySQL Router on two application servers?

I have three MySQL servers running with group replication and inside a InnoDB Cluster. I have two app servers that will be connecting to the cluster and I need to configure mysql router on both app ...
0
votes
1answer
227 views

MySQLRouter on Windows 10 Unable to connect to the metadata server

I have set up a set of three MySQL 8.0.17 databases using group replication. They are all on my Windows 10 PC, using ports 3306,3307,3308. I am now trying to set up mysqlrouter. I have installed it ...