Stack Overflow
Stack Overflow

Questions tagged [mysql-innodb-cluster]

51 questions
4
votes
0 answers

Why the error: Neither --relay-log nor --relay-log-index were used

So i have this mysql innodb cluster of 3 mysql instances on docker that is always failing with the error group replication not active. Looking at the error logs, the only thing i can find is this warning: Neither --relay-log nor --relay-log-index…
eedideyahoocom
  • 143
  • 1
  • 8
3
votes
2 answers

A node in MySQL 5.7 innoDB cluster is crashed and unable to re-join the crashed node to the cluster

We have a MySQL innodb cluster in one of our environments. One of the nodes in the cluster was crashed. Though, we were able to bring the crashed node online we were unable to join it to the cluster. Can someone please help to recover/restore the…
Siva Dasari
  • 1,059
  • 2
  • 19
  • 40
2
votes
2 answers

OCI Loadbalancer for exposing Innodb cluster To Internet

I have been trying to expose MySQL InnoDB Cluster setup on OCI OKE to Internet. This cluster was installed using MySQL Operator and the pods are listening on to port 6446 and 6447. I have ClusterIP to connect to pods by exec'ing into the pod.…
ZZzzZZzz
  • 1,800
  • 3
  • 29
  • 51
2
votes
0 answers

Restore mysql Innodb from filesystem folders

I have a mysql galera server ( innodb) datadir which got crashed with because of network failure . I am trying to restore the db thru the filesystem . tried innodb_force_recovery flag 1 , [mysqld] innodb_force_recovery = 1 Started the…
Shekhar
  • 56
  • 3
2
votes
2 answers

MySQL Replication: Question about a fallback-system

I want to set up a complete server (apache, mysql 5.7) as a fallback of a productive server. The synchronization on file level using rsync and cronjob is already done. The mysql-replication is currently the problem. More precisely: the choice of the…
ttz
  • 79
  • 4
2
votes
1 answer

Innodb cluster - add instance error - the server is not configured properly

I am trying to add instance to my innodb cluster. I turned off my firewall on both hosts (local vms). This is the output of the cluster.addInstance('root@innodb-2:3306'); command: ERROR: Unable to start Group Replication for instance…
Aline137
  • 73
  • 1
  • 7
2
votes
0 answers

How to use single datasource for reading and writing in Springboot with mysql-innodb-cluster

I am using Innodb-cluster with three instances with "Single-Primary" topology. Now when I configure MysqlRouter it gives me following two ports for reading and writing: - Read/Write Connections: localhost:6446 - Read/Only Connections:…
Ashish
  • 198
  • 3
  • 11
2
votes
1 answer

Creating a MySQL cluster, using mysql-server docker containers, on multiple servers

I'm trying to create an MySQL cluster of 3 nodes using mysql-server docker containers. I have 3 separate cloud instances and docker is setup on all 3 of them. Each server will have only 1 container running on it - to achieve High Availability when…
Chandra Kanth
  • 348
  • 2
  • 13
2
votes
1 answer

Use mySql innodb cluster sandbox after restart of system/ not working?

During installation I selected Inno db cluster sandbox configration, which left me with sandbox running at 3310 and mySql server at 3306. After restarting, nothing was working,how to restart and reinitiate the Inno DB cluster sandbox? Apparrently…
Ajay Tom George
  • 1,890
  • 1
  • 14
  • 26
2
votes
1 answer

InnoDB Cluster addInstance: Plugin group_replication reported: 'read failed'

Running an InnoDB Cluster using 5.7.25 (planning to migrate to 8.0 shortly) Two of my instances have left the cluster due to network issues, and I'm left with one healthy node. I'm doing the following procedure to add a node to the cluster, which…
nirg
  • 61
  • 1
  • 6
1
vote
0 answers

MySQL InnoDB Cluster failed to start in LKS

Description: I have been trying to set up MySQL InnoDB Cluster in K8S(Linode Kubernetes Service). For first when I provision the InnoDB cluster with 3 instances and 1 router, It starts and creates dynamic pv and PVC claim with Linode volume and…
Naresh Kumar
  • 11
  • 2
1
vote
0 answers

MySQL group replication insert statement time sometimes suddenly increases, how is this caused?

I used jmeter to stress test the table named test in my innodb cluster. I recorded all sql statements exceeding 1ms in the slow SQL log. I found that the time consumption of insert statements sometimes increased suddenly, but it was irregular.
Eden
  • 11
  • 1
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

Cannot disable query_cache_type in my.cnf

I am trying to disable the query_cache_type in my mariadb pod in docker due to known performance issues with that and InnoDB. I have some current settings in a production server running on an rpm that have the following…
jnexxo523
  • 13
  • 4
1
vote
1 answer

get ipallowlist in innodb cluster

I am new to innodb cluster and while setting up the innodb cluster, there is a step to setup ipAllowlist c.addInstance("cluster_admin@service_name_of_new_node:3306",{ipAllowlist:…
developthou
  • 343
  • 1
  • 10
1
2 3 4