Questions tagged [mysqlrouter]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
23 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
25 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
18 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
36 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,...
0
votes
0answers
119 views

MySQL router Access denied for user 'routeruser'@'%' to database 'mysql_innodb_cluster_metadata' (1044)

I am trying to deploy MySQL-router in kubernetes, I had some problems previously and they were fixed. Now mysql-router pod is showing following error in kubernetes logs mysql-router-pod -n mysql-...
1
vote
0answers
78 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
0answers
57 views

What could cause mysql-router to not open/listen to port 6446 when running as a daemon?

I have a 3 primary node innodb cluster setup which is running as expected. To connect to these I have mysql-router setup, however, when running mysql-router as a daemon service mysql-router start it ...
0
votes
1answer
14 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
21 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
361 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
169 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 ...