Stack Overflow
Stack Overflow

Questions tagged [mysql-innodb-cluster]

51 questions
0
votes
0 answers

trying to configure mysql-innodb-cluster but have Pods pending error

I am trying to configure mysql-innodb-cluster using helm. Here is command : helm install mycluster mysql-operator/mysql-innodbcluster -n mysql-cluster. I already have made rook-ceph storageclass. But pods are still pending. I really don't know how…
박지환
  • 1
0
votes
1 answer

The designated data directory MySQL is unusable

I use bitnami/mysql to use mysql in k8s. I used this command: helm install my-sql bitnami/mysql --set global.storageClass=rook-cephfs --set image.debug=true --set auth.rootPassword="SAra131064" --set auth.username=ali --set auth.password=ali1234…
Ali Rezvani
  • 315
  • 2
  • 11
0
votes
1 answer

MySQL Replication and myAppExample, which IP to point the myAppExample to? To the Master, Router, one of the slaves?

MySQL Replication and myAppExample, which IP to point the app to? To the Master, Router, one of the slaves? I setup a typical lamp stack and also a MySQL InnoDB cluster. myAppExample: 10.3.1.9 mysql-0 : 10.3.1.10 mysql-1 : 10.3.1.11 mysql-2 …
newelement
  • 1
0
votes
0 answers

auto_increment_increment, auto_increment_offset in MySQL 8 InnoDB Cluster Multi-Primary

In InnoDB multi-primary mode, when members are composed of 8 or 9, the auto_increment_increment and auto_increment_offset values are different from those announced in the Mysql official documentation. I believe it's a bug and I've attached detailed…
mimdong
  • 1
0
votes
0 answers

How to create initial user with Kubernetes MySQL-InnoDBCluster?

So, currently, I'm deploying my own hand crafted Kubernetes deployment (yes, I know, should have been a stateful set!) for MySQL (8.0) and I've been using environment vars MYSQL_USER, MYSQL_PASSWORD and MYSQL_DATABASE to create the initial user…
Steve Folly
  • 8,327
  • 9
  • 52
  • 63
0
votes
1 answer

MySQL InnoDB Cluster config - configure node address

I'm setting up an InnoDB Cluster using mysqlsh. This is in Kubernetes, but I think this question applies more generally. When I use cluster.configureInstance() I see messages that includes: This instance reports its own address as…
Jerry
  • 3,391
  • 1
  • 19
  • 28
0
votes
1 answer

MySQL Router Connection Attributes Failed

I have a 3 node innodb cluster setup. On each server I also have a mysql router. I bootstrapped 1 of the routers. Started all 3 routers using the same conf that was created during the bootstrap. I am seeing the following warning in the mysql…
Crackerman
  • 717
  • 1
  • 9
  • 22
0
votes
1 answer

problems with mysql innodb_lock_wait_timeout attribute on the mysql in the coud

I am currently working on an application built in yii2 and I have an error in my MySQL in the cloud and I have the following error. General error: 1205 Lock wait timeout exceeded; try restarting transaction Googling I found that it can be solved…
almacenamiento fullcloud
  • 1
  • 1
0
votes
1 answer

How to execute inodbcluster status using bash shell script

I am working on the MySQL InnoDB cluster, I have a requirement to execute cluster status using shell script. MySQL db:3306 ssl JS > dba.getCluster().status() Is there any way that I can execute the above command using the bash shell script?
subbu
  • 1
0
votes
0 answers

Update ipAllowList in mysql shell

I haven't found the way to update ipAllowlist in innodbcluster using mysql shell. Is there a way to do this?
developthou
  • 343
  • 1
  • 10
0
votes
1 answer

InnoDB cluster memory issue with LOAD DATA

I need to create a new table with ~8M rows without causing too much noise for other services using the cluster. I split the data into chunks of 100k rows and use LOAD DATA LOCAL FILE, sleep 5s and repeat. Mysql starts to consume all memory until OOM…
MyGGaN
  • 1,766
  • 3
  • 30
  • 41
0
votes
0 answers

MySQL hangs on SELECT from table with blob fields

This question has been moved to dba.stackexchange.com I managed to create a mysql InnoDB cluster with three nodes and a router everything works great but when i try to run a select query from the table below from a another server it freezes, but…
mbouzahir
  • 1,424
  • 13
  • 16
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
1 answer

Mysql server 5.7 - Can't add new cluster instance with mysql shell 'cluster.addInstance()'

Hello I am trying to setup a mysql InnoDB cluster architecture so far I installed mysql server 5.7 on 3 different servers and configured mysql clustering using the following…
Yassir Khaldi
  • 1,452
  • 1
  • 17
  • 30
0
votes
1 answer

deploySandboxInstance() error while creating a sandbox instance in MySQL

We are performing HA InnoDb in Mysql. For that we need 3 instance to perform failover. While running this query in msql-js we got an error of invalid object member. Query - dba.deploySandboxInstance(3310); Error - Invalid object member…
Sarvesh Pandey
  • 31
  • 4
1 2
3
4