Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [mysqlrouter]

10 questions
2
votes
1 answer

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 servers. When I run router on server1 I use the…
Manuel
  • 91
  • 7
1
vote
1 answer

Configuring High Availability for MySQL Router in a MySQL InnoDB Cluster

I've configured a MySQL InnoDB Cluster for high availability with two servers on a Windows system (Server 1: h01xxxxxxxxx1, IP: 10.xxx.xx.61, Server 2: h01xxxxxxxxx2, IP: 10.xxx.xx.71), running smoothly under the cluster name 'H01xxxxxE.'. When one…
alaa
  • 11
  • 1
1
vote
0 answers

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 cluster on MySQL 5.7.30 with 13 application servers…
TheFox
  • 11
  • 3
0
votes
0 answers

MySQL Router 8.0 doesn't revert back to first destination after failover

I have 4 MySQL-Servers (Version: 8.0.40) set up in a multi-primary group replication configuation. Recently, I added MySQL Router (Version 8.0.4) in order to implement failover to the other servers in case the MySQL-Server on the localhost becomes…
BalticLab
  • 1
  • 1
0
votes
0 answers

Error 1827 on MySQL Replication slaves when MySQL Router creates a user

I'm running MySQL 8.0.37 on three different servers, configured as a master with two slaves. All of the versions are exactly the same. My applications connect to the cluster via MySQL's Community Router. My replication system uses GTID replication,…
JVal90
0
votes
1 answer

Load Balancing in mysql InnoDB cluster

I have set up an InnoDB cluster with one primary(R/W) and two secondaries (R/O) and bootstrapped a MySQL Router. The router has 2 port 6646(R/W port) and 6647(R/O) port. My application is currently connected to the cluster through the R/W port. Now…
Wong Chung sze
  • 1
0
votes
1 answer

MySqlRouter cant connect to MySqlServer

mysqlrouter service is running ports are listening tcp 0 0 0.0.0.0:6446 0.0.0.0:* LISTEN 6150/mysqlrouter tcp 0 0 0.0.0.0:6447 0.0.0.0:* LISTEN 6150/mysqlrouter tcp …
butching
0
votes
1 answer

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 mysql instance on the same server. Is this…
Ken
  • 21
  • 3
0
votes
1 answer

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 parameter then its working fine "mysql -u ia…
irfan_db
  • 11
  • 4
0
votes
1 answer

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 in c:/mysqlrouter/. But when I run: mysqlrouter…
IGGt
  • 2,266
  • 6
  • 35
  • 49