Stack Overflow
Stack Overflow

Questions tagged [mysqlrouter]

16 questions
8
votes
2 answers

sha256_password deprecated warnings filling logs

I've configured an InnoDB MySQL v8.0.19 Group Replication Cluster in single-primary mode. I have several webapps accessing the cluster via their own MySQL Router instance in a 1:1 relationship, as per the suggested pattern. Everything appears to be…
codeturner
  • 993
  • 1
  • 8
  • 20
2
votes
2 answers

Detection of outdated replicas at mysql router

I am using mysqlrouter to route traffic to InnoDB cluster nodes with master-slave replication (1 master + 2 slaves). For some reason, I am frequently facing replication issues and seeing that replicas don't have data for the last 2 hours. As a…
Rahul
  • 1,727
  • 3
  • 18
  • 33
1
vote
1 answer

MySQL router in K8 gets connection overflow

I had successfully deployed MySQL router in Kubernetes as described in this answer. But recently I noticed mysql router was having overflow issues after some time. Starting mysql-router. 2022-03-08 10:33:33 http_server INFO [7f2ba406f880] listening…
Sachith Muhandiram
  • 2,819
  • 10
  • 45
  • 94
1
vote
0 answers

Is it sensible to force SSL when connecting to MySQL Router via Unix socket?

I have a standard MySQL InnoDB Cluster deployment with MySQL Routers instances (8.0.24) running on each of the applications servers. I have a script which adds a lot of data with MySQL command-line client (5.7.30); I would like it to connect via…
mac-p
  • 140
  • 1
  • 6
1
vote
1 answer

How can I run mysql router in Docker with compose file with bootstrap mode

MySql Router has a command to bootstrap itself mysqlrouter --bootstrap root@127.0.0.1:3306 --directory /tmp/router After bootstrap, Router will exit, and we should run it again with config file generated by bootstrap since I will modify this…
wolf289184291
  • 31
  • 2
1
vote
0 answers

How can i know through which mysql router request has been sent to InnoDB cluster in a multirouter environment

I had configured my Java application to connect through multiple routers to the InnoDB cluster so that if one of my router stops working other router can take up the routing task (I have 6 router configured ) Now Can some one help me in finding…
Uttam Dey
  • 11
  • 1
0
votes
0 answers

How to test the mysql-router failover?

I implemented mysql innodb cluster using three servers "test-1", "test-2", "test-3". Out of which my test-3 is the master-node. My cluster setup is working as expected, now I would like to test the mysql-router failover. Kindly provide some useful…
vinod
  • 260
  • 3
  • 12
0
votes
0 answers

Not able to connect to mysql-router on IPv6 address

I am deploying mysqlrouter with IPv6 address on kubernetes cluster, router is deploying and is able to connect to mysql instances, but the router itself is not being able to connect to application services. Also I tried to do telnet to the…
SVD
  • 385
  • 4
  • 24
0
votes
0 answers

MySQL Simple Router Config - Dump metadata-cache-d Destination server value

This is part of the config [routing:MYCLUSTER_x_rw] bind_address=0.0.0.0 bind_port=3308 socket=/opt/mysql/MYCLUSTER_x_rw/mysqlx.sock destinations=metadata-cache://MYCLUSTER_x_rw/?role=PRIMARY # <----- I need to know the host…
DDan
  • 8,068
  • 5
  • 33
  • 52
0
votes
0 answers

getting router log routing ERROR [7f258b169700] classic::loop() processor failed: Bad message (generic:74) while connect and close using mysqlsh

getting below error while connect and close using Mysqsh with socket file for every min. Details: mysql version: 8.0.32 router version: 8.0.32 shell version: 8.0.32 OS version: centos 7 error in router log: 2023-02-09 16:00:01 routing INFO…
sateesh
  • 111
  • 1
  • 8
0
votes
0 answers

Does mysql-router has support for lua language?

I want to write and sql query interceptor and possibly manipulate query results too. I found some documentation for mysql-proxy at http://download.nust.na/pub6/mysql/tech-resources/articles/proxy-gettingstarted.html. this gives me flexibility to…
Raju Nimbalkar
  • 1
  • 2
0
votes
0 answers

Mock Server from MySQL Installation

I see there is a mock mysql functionality out of the box from mysql installation and it is documented here It involves, setting up a mock tcp port with binary called ./mysql_server_mock but I couldn't find this in my installation. I installed MySQL…
Mail
  • 314
  • 1
  • 2
  • 9
0
votes
1 answer

MySQL Router how to set windows service name

How to set Windows service name with MySQL Router? As per documentation there is only the option of --install-service, but as it seems, it is a fixed name "MySQLRouter". $ mysqlrouter --config "C:\mysql-router\mysqlrouter.conf"…
JPBorges
  • 53
  • 5
0
votes
2 answers

MySQL Router daemon not listening any ports

I installed the program as described here https://dev.mysql.com/doc/mysql-router/8.0/en/mysql-router-deploying-bootstrapping.html. After installation, the service mysqlrouter was launched in the system. But this service does not listen any of the…
Vladimir
  • 229
  • 2
  • 16
0
votes
1 answer

Mysql Router send request to down slave node for a Second

I have implemented InnoDB cluster using MySql router(version - 2.1.4) for HA This is my mysqlrouter.conf…
Sujan Kumar Sakthi
  • 403
  • 1
  • 5
  • 10
1
2